SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)
Planning Database Security and Recovery
HP NonStop SQL/MX Installation and Management Guide—523723-004
5-32
SQL/MX Objects That Are Backed Up Explicitly
SQL/MX Objects That Are Backed Up Explicitly
Backing Up Catalogs
SQL/MX catalogs are backed up only when specified, not by default. When you back
up a catalog, all of its subordinate objects (for example, schemas and tables) are
backed up as well unless they are specifically excluded.
You can specify the MX CATALOG backup object to back up one or more catalogs:
BR> BACKUP $tape-drive, MX CATALOG mycat1;
You can also use it to specify every catalog in the SQL/MX file system.
BR> BACKUP $tape-drive, MX CATALOG CAT*;
You can specify either CAT or CATALOG in the BACKUP command. The CAT * object
specifier, which directs BACKUP to back up every catalog and its subordinate objects,
effectively backs up every file in the SQL/MX file system.
Backing Up Schemas
When you back up a schema, all of its subordinate objects are backed up as well
unless they are specifically excluded.
You can back up one or more schemas, either implicitly, by backing up associated
catalogs, or explicitly, by identifying the SCHEMA backup object:
BR> BACKUP $tape-drive, MX SCHEMA mycat1.sch1;
BR> BACKUP $tape-drive, MX SCHEMA mycat1.sch1, mycat1.sch2;
Backing Up Tables and Partitions
When you back up a table, all its subordinate objects (for example, partitions) are
backed up as well unless they are specifically excluded.
You can back up one or more tables, either implicitly, by backing up associated
schemas or catalogs, or explicitly, by specifying the MX TABLE or MX TBL backup
object:
BR> BACKUP $tape-drive, MX TABLE cat1.sch1.table1;
BR> BACKUP $tape-drive, MX TABLE cat1.sch1.table1,
cat1.sch1.table2;
You can back up one or more table partitions, either implicitly, by backing up
associated tables, or explicitly, by using the PARTITION backup object specification:
BR> BACKUP $tape-drive, MX (TPART cat1.sch1.table1 PARTITION
(part1)), PARTONLY ON;
BR> BACKUP $tape-drive, MX (TPART cat1.sch1.table1 PARTITION
(part1, part2))
BR+>, PARTONLY ON;