Backup and Restore 2 Manual

BRCOM BACKUP Command
Backup and Restore 2 Manual—522696-019
6-48
SQL/MX Backup Examples

Backing Up an SQL/MX Table on page 6-51

Backing Up a Delimited SQL/MX Table on page 6-52

Backing Up SQL/MX Table Partitions on page 6-52

Backing Up a Delimited SQL/MX Table Partition on page 6-53

Backing Up SQL/MX Objects Using Filtering on page 6-54

Backing Up SQL/MX Indexes on page 6-53

Backing Up SQL/MX Indexes Separately on page 6-54

Backing Up SQL/MX Index Partitions on page 6-54

Excluding SQL/MX Indexes on page 6-54

Backing Up SQL/MX Objects Using Filtering on page 6-54
For these examples, assume this database structure:
Note. SQL/MX catalogs containing delimiters are supported only on systems running H06.06
or later H-series RVUs.
Table 6-5. Database Structure on Disk (page 1 of 2)
Catalog Schema Table
Table
Partition
or Index
Index
Partition Description
cat1 Catalog
-sch1 Subordinate schema of cat1
-tab1 Subordinate table of sch1
(created on 30 SEP 2002)
-tpart1 Subordinate table partition of
tab1 (last modified on 31 JUL
2002)
-ind1 Subordinate index of tab1
-ipart1 Subordinate index partition of
the index for tab1
-sch2 Subordinate schema of cat1
-tab2 Subordinate table of sch2
(created on 31 JAN 2003)
-tpart1 Subordinate table partition of
tab2
-tpart2 Subordinate table partition of
tab2 (last modified on 31 AUG
2002)