SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Performing Recovery Operations
HP NonStop SQL/MX Installation and Management Guide—640325-001
12-24
Restoring Indices and Index Partitions
You can restore one or more table partitions, either implicitly, by restoring associated
tables, or explicitly, by using the PARTITION restore object:
BR> RESTORE $tape-drive, MX (TPART cat1.sch1.table1 PARTITION
(part1)), PARTONLY ON;
BR> RESTORE $tape-drive, MX (TPART cat1.sch1.table1 PARTITION
(part1, part2))
BR+>, PARTONLY ON;
For more information about restoring tables and table partitions, see the Backup and
Restore 2 Manual.
Restoring Indices and Index Partitions
When you restore an index, all its dependent objects, including partitions, are also
restored. Similarly, when you restore a index partition, all its dependent objects
(for example, indexes and constraints) are restored.
You can restore one or more indices, either implicitly by restoring associated
schemas or catalogs or explicitly by using the INDEX restore object:
To restore one or more indices, restore the associated schemas or catalogs implicitly
or use the INDEX restore object explicitly:
BR> RESTORE $tape-drive, MX INDEX cat1.sch1.index1;
BR> RESTORE $tape-drive, MX INDEX cat1.sch1.index1, INDEX
cat2.sch.index2;
To restore one or more index partitions, restore the associated indices implicitly or use
the PARTITION restore object explicitly:
BR> RESTORE $tape-drive, MX (IPART cat1.sch1.index1
PARTITION(part1)), PARTONLY ON;
BR> RESTORE $tape-drive, MX (IPART cat1.sch1.index1
PARTITION(part1, part2))
BR+>, PARTONLY ON;
For more information about restoring indices and index partitions, see the Backup and
Restore 2 Manual.
Using SHOWDDL
When SHOWDDL is turned ON during a restore operation, the RESTORE command
writes to an OSS EDIT file the DDL for each CREATE statement that has executed.
You can modify the EDIT files to be used as MXCI OBEY command files to regenerate
these SQL/MX objects that cannot be backed up or restored directly:
Caution. Use care when using the PARTONLY object in Backup and Restore 2 operations for
partitioned tables. It is possible to make the primary and secondary partitions of a table
inconsistent, both with each other and with indexes (for example, by performing DML
operations on only one of two backed up partitions before you restore both).