Backup and Restore 2 Manual

BRCOM BACKUP Command
Backup and Restore 2 Manual—522696-019
6-52
SQL/MX Backup Examples
To back up only the DDL for tables, specify the SQLDATA OFF option. User data is not
backed up. For example:
BR> BACKUP =mytape, MX TABLE cat1.sch2.tab2, SQLDATA OFF ;
Backing Up a Delimited SQL/MX Table
Backing up a delimited table also backs up all the subordinate indexes and partitions.
For example, to back up all objects in “TAble1”:
BR> BACKUP =mytape, MX TBL ”CATalog1”.”SCHema1”.”TAble1”;
Backing Up SQL/MX Table Partitions
To back up all the table partitions in a table, specify the table. For example:
BR> BACKUP =mytape, MX TABLE cat1.sch1.tab1;
As shown in Table 6-9, all the subordinate objects, including the table partitions are
backed up.
To back up individual table partitions, specify TPART, the table that contains the
partitions, the partitions to be backed up, and these job options. For example:
BR> BACKUP =mytape, MX (TPART cat1.sch2.tab2 PARTITION
BR+> (TPART5, TPART1)), PARTONLY ON, CONSTRAINTS EXCLUDED,
BR+> INDEXES EXCLUDED;
Both the data and DDL of the objects shown in Table 6-10
are backed up. The table
tab2 and the table partition tpart2 are not backed up.
Note. SQL/MX tables containing delimiters are supported only on systems running H06.06 or
later H-series RVUs.
Table 6-9. Table Backed Up Including All Table Partitions and Indexes
Catalog Schema Table
Table
Partition
or Index
Index
Partition Description
cat1.sch1.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