Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-69
SQL/MX Restore Examples
Restoring SQL/MX Table Partitions
When you restore a table, the table’s partitions are also restored. To restore only an
individual table partition, you must specify the PARTONLY ON job option. For example:
BR> RESTORE =mytape, MX TPART cat1.sch2.tab2 PARTITION
BR+> (TPART5), PARTONLY ON, INDEXES EXCLUDED, CONSTRAINTS
BR+> EXCLUDED ;
As shown in Table 7-12, only TPART5 is restored.
If you restore individual table partitions, you must specify INDEXES EXCLUDED and
CONSTRAINTS EXCLUDED. For example:
BR> RESTORE =mytape, MX (TABLE cat1.sch1.tab1, TPART
BR+> cat1.sch2.tab2 PARTITION (TPART5)), PARTONLY ON, INDEXES
BR+> EXCLUDED, CONSTRAINTS EXCLUDED;
The objects shown in Table 7-13 are restored. The indexes, index partitions, and
constraints subordinate to the specified table are not restored.
Table 7-12. Individual Table Partition Restored
Catalog Schema Table
Table Partition or
Index
Index
Partition Description
tpart5 Subordinate
table partition of
cat1.sch2.tab2
Table 7-13. Individual Table Partitions Restored Excluding Indexes, Index
Partitions, and Constraints
Catalog Schema Table
Table
Partition
or Index
Index
Partition Description
cat1.sch1.tab1 Subordinate table
of sch1
-tpart1 Subordinate table
partition of tab1
-tpart5 Subordinate table
partition of
cat1.sch2.tab2