Backup and Restore 2 Manual

BRCOM BACKUP Command
Backup and Restore 2 Manual—522696-019
6-54
SQL/MX Backup Examples
Backing Up SQL/MX Indexes Separately
To back up indexes individually, specify the INDEX option. For example:
BR> BACKUP $tape01, MX (IND cat.sch.ind1, INDEX cat.sch.ind2),
tapedisposition bot;
Backing Up SQL/MX Index Partitions
To back up index and index partitions, specify the IPART option. For example:
BR> BACKUP $tape01, MX (IPART cat.sch.ind1 PARTITION (ipart5),
IPART cat.sch.ind1 PARTITION (ipart1)), PARTONLY ON,
tapedisposition bot;
Excluding SQL/MX Indexes
To exclude the indexes and index partitions, specify the INDEXES EXCLUDED job
option. For example:
BR> BACKUP =mytape, MX TABLE cat1.sch1.tab1, INDEXES EXCLUDED;
As shown in Table 6-11 on page 6-54, the indexes and index partitions are not backed
up.
Backing Up SQL/MX Objects Using Filtering
To select certain objects to back up while excluding other objects, use a WHERE
expression. For example:
BR> BACKUP =mytape, MX (CATALOG cat2, TABLE cat1.sch1.tab1,
BR+> TPART cat1.sch2.tab2 PARTITION (TPART5)) WHERE
BR+> (CREATIONTIME BEFORE 1 APR 2003), PARTONLY ON, INDEXES
BR+> EXCLUDED, CONSTRAINTS EXCLUDED;
Table 6-11. Indexes Excluded From Backup
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