Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-71
SQL/MX Restore Examples
For both these commands, the objects shown in Table 7-14 are restored:
To exclude the indexes and index partitions, specify this command:
BR> RESTORE =mytape, MX TABLE cat1.sch1.tab1, INDEXES EXCLUDED;
These objects as shown in Table 7-15 are restored but the indexes and index partitions
are not restored:
Restoring SQL/MX Indexes Separately
To restore indexes individually, specify the INDEX option. For index restores, mention
the target table.
Table 7-14. Table and Subordinate Objects Restored Including the Index and
Index Partition
Catalog Schema Table
Table
Partition or
Index
Index
Partition Description
cat1.sch1.tab1 Subordinate
table of
cat1.sch1
-tpart1 Subordinate
table partition
of tab1
-ind1 Subordinate
index of tab1
-ipart1 Subordinate
index partition
of the index
for tab1
Table 7-15. Table Restored Excluding Indexes and Index Partitions
Catalog Schema Table
Table
Partition or
Index
Index
Partition Description
cat1.sch1.tab1 Subordinate
table of
cat1.sch1
-tpart1 Subordinate
table partition
of tab1