Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-66
SQL/MX Restore Examples
Restoring a Delimited SQL/MX Catalog
To restore all objects in “CATalog1”:
BR> RESTORE = mytape, MX CATALOG “CATalog1”;
Restoring an SQL/MX Schema
To restore all objects in cat1.sch2:
BR> RESTORE =mytape, MX SCHEMA cat1.sch2;
Schema cat1.sch2 and all its subordinate objects as shown in Table 7-9 are restored.
-tpart2 Subordinate table partition of
tab2 (last modified on 31 AUG
2002)
-tpart5 Subordinate table partition of
tab2
-sch3 Subordinate schema of cat1
-tab3 Subordinate table of sch3
-tpart3 Subordinate table partition of
tab3
Note. SQL/MX catalogs containing delimiters are supported only on systems running H06.06
or later H-series RVUs.
Table 7-9. Schema and Subordinate Objects Restored
Catalog Schema Table
Table
Partition
or Index
Index
Partition Description
cat1.sch2 Subordinate schema of
cat1
-tab2 Subordinate table of sch2
-tpart1 Subordinate table partition
of tab2
-tpart2 Subordinate table partition
of tab2
-tpart5 Subordinate table partition
of tab2
Table 7-8. Catalog and Subordinate Objects Restored (page 2 of 2)
Catalog Schema Table
Table
Partition
or Index
Index
Partition Description