Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-70
SQL/MX Restore Examples
Restoring a Delimited SQL/MX Table Partition
To restore individual delimited table partitions, PARt1 and PARt2, you must specify the
PARTONLY ON job option. For example:
BR> RESTORE =mytape, MX (TPART “CATalog1”.”SCHema1”.”TAble1”
BR+>PARTITION (“PARt1”, “PARt2”)), PARTONLY ON, CONSTRAINTS
BR+> EXCLUDED,INDEXES EXCLUDED;
Restoring SQL/MX Indexes
INDEXES INCLUDED is the default. When you restore a table, the table’s indexes and
index partitions are restored unless you specify the INDEXES EXCLUDED job option.
In this example, INDEXES INCLUDED is not specified but is assumed:
BR> RESTORE =mytape, MX TABLE cat1.sch1.tab1;
You can also specify INDEXES INCLUDED. For example:
BR> RESTORE =mytape, MX(TABLE cat1.sch1.tab1), INDEXES
BR+> INCLUDED;
Note. SQL/MX tables partitions containing delimiters are supported only on systems running
H06.06 or later H-series RVUs.