Backup and Restore 2 Manual

BRCOM BACKUP Command
Backup and Restore 2 Manual—522696-019
6-51
SQL/MX Backup Examples
Backing Up a Delimited SQL/MX Schema
Backing up a delimited schema also backs up all the subordinate tables, indexes, and
partitions. To back up all objects in “SCHema1” of “CATalog1”:
BR> BACKUP =mytape, MX SCHEMA ”CATalog1”.”SCHema1”;
Backing Up an SQL/MX Table
Backing up a table also backs up all the subordinate indexes and partitions. For
example, to back up all objects in tab3:
BR> BACKUP =mytape, MX TABLE cat1.sch3.tab3;
As shown in Table 6-8
, table cat1.sch3.tab3 and all its subordinate objects are backed
up.
Table 6-7. Schema and Subordinate Objects Backed Up
Catalog Schema Table
Table
Partition or
Index
Index
Partition Description
cat1.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
Note. SQL/MX schemas containing delimiters are supported only on systems running H06.06
or later H-series RVUs.
Table 6-8. Table and Subordinate Objects Backed Up
Catalog Schema Table
Table
Partition
or Index
Index
Partition Description
cat1.sch3.tab3 Subordinate table of
cat1.sch3
-tpart3 Subordinate table
partition of
cat1.sch3.tab3