Backup and Restore 2 Manual

BRCOM BACKUP Command
Backup and Restore 2 Manual—522696-019
6-49
SQL/MX Backup Examples
Backing Up All SQL/MX Catalogs
To back up all catalogs:
BR> BACKUP =mytape, MX CATALOG *;
All the catalogs and their subordinate objects as listed in Table 6-5 on page 6-48 are
backed up to tape.
Backing Up an SQL/MX Catalog
Backing up a catalog also backs up all the subordinate schemas, tables, indexes, and
partitions. To back up all objects in cat1:
BR> BACKUP =mytape, MX CATALOG cat1;
Catalog cat1 and all its subordinate objects as shown in Table 6-6
are backed up.
-tpart5 Subordinate table partition of
tab2 (created 1 JUN 2003)
-sch3 Subordinate schema of cat1
-tab3 Subordinate table of sch3
-tpart3 Subordinate table partition of
tab3
cat2 Catalog
-sch1 Subordinate schema of cat2
-tab1 Subordinate table of sch1
(created on 05 AUG 2003)
-tpart1 Subordinate table partition of
tab1
-tpart2 Subordinate table partition of
tab1 (last modified on 30 NOV
2003)
cat3 Catalog
cat4 Catalog
-sch Subordinate schema of cat4
Table 6-5. Database Structure on Disk (page 2 of 2)
Catalog Schema Table
Table
Partition
or Index
Index
Partition Description