Backup and Restore 2 Manual

BRCOM BACKUP Command
Backup and Restore 2 Manual—522696-019
6-53
SQL/MX Backup Examples
Backing Up a Delimited SQL/MX Table Partition
To back up individual table partitions, specify TPART, the table that contains the
partitions, the partitions to be backed up, and the job options. For example:
BR> BACKUP =mytape, MX (TPART “CATalog1”.”SCHema1”.”TAble1”
BR+>PARTITION (“PARt1”, “PARt2”)), PARTONLY ON, CONSTRAINTS
BR+> EXCLUDED,INDEXES EXCLUDED;
Backing Up SQL/MX Indexes
When you back up a table, all its indexes and its index partitions are backed up unless
you specify INDEXES EXCLUDED. However, you cannot directly back up indexes or
index partitions by name.
To back up a table’s indexes and its index partitions, specify the table that contains the
indexes. For example:
BR> BACKUP =mytape, MX TABLE cat1.sch1.tab1, INDEXES
BR+> INCLUDED;
In this example, INDEXES INCLUDED is not specified but is assumed:
BR> BACKUP =mytape, MX TABLE cat1.sch1.tab1;
For both these commands, the table and all subordinate objects including the index
partitions are backed up as shown in Table 6-9
on page 6-52.
To back up only the DDL for indexes, specify the SQLDATA OFF option and do not
specify INDEXES EXCLUDED. The DDL is backed up, but the user data is not backed
up. For example:
BR> BACKUP =mytape, MX CATALOG cat1, SQLDATA OFF;
Table 6-10. Individual Table Partitions Backed Up
Catalog Schema Table
Table
Partition
or Index
Index
Partition Description
-tpart1 Subordinate table partition of
cat1.sch2.tab2
-tpart5 Subordinate table partition of
cat1.sch2.tab2
Note. SQL/MX tables partitions containing delimiters are supported only on systems running
H06.06 or later H-series RVUs.