Backup and Restore 2 Manual

BRCOM BACKUP Command
Backup and Restore 2 Manual—522696-019
6-50
SQL/MX Backup Examples
Backing Up a Delimited SQL/MX Catalog
Backing up a delimited catalog also backs up all the subordinate schemas, tables,
indexes, and partitions. To back up all objects in “CATalog1”:
BR> BACKUP =mytape, MX CATALOG ”CATalog1”;
Backing Up an SQL/MX Schema
Backing up a schema also backs up all the subordinate tables, indexes, and partitions.
To back up all objects in sch2 of cat1:
BR> BACKUP =mytape, MX SCHEMA cat1.sch2;
Schema cat1.sch2 and all its subordinate objects as shown in Table 6-7
are backed up.
Table 6-6. Catalog and Subordinate Objects
Catalog Schema Table
Table
Partition
or Index
Index
Partition Description
cat1 Catalog
-sch1 Subordinate schema of cat1
-tab1 Subordinate table of cat1.sch1
-tpart1 Subordinate table partition of
cat1.sch1.tab1
-ind1 Subordinate index of
cat1.sch1.tab1
-ipart1 Subordinate index partition of
the index for cat1.sch1.tab1
-sch2 Subordinate schema of cat1
-tab2 Subordinate table of cat1.sch2
-tpart1 Subordinate table partition of
cat1.sch2.tab2
-tpart2 Subordinate table partition of
cat1.sch2.tab2
-tpart5 Subordinate table partition of
cat1.sch2.tab2
-sch3 Subordinate schema of cat1
-tab3 Subordinate table of cat1.sch3
-tpart3 Subordinate table partition of
cat1.sch3.tab3
Note. SQL/MX catalogs containing delimiters are supported only on systems running H06.06
or later H-series RVUs.