SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

You can also specify every catalog that was backed up:
BR> RESTORE $tape-drive, MX CAT *;
For more information, see the Backup and Restore 2 Manual.
Restoring Schemas
When you restore a schema, all its dependent objects are restored as well.
Restore one or more schemas either implicitly, by restoring the associated catalogs, or explicitly,
by using the SCHEMA restore object:
BR> RESTORE $tape-drive, MX SCHEMA CAT3.SCH;
BR> RESTORE $tape-drive, MX SCHEMA CAT2.SCH, SCHEMA CAT3.SCH;
For more information, see the Backup and Restore 2 Manual.
Restoring Tables and Partitions
When you restore a table, all its dependent objects, including partitions, are also restored. Similarly,
when you restore a table partition, all its dependent objects (for example, indexes and constraints)
are restored.
NOTE: Hash-partitioned tables must be restored in their entirety. Individual hash partitions cannot
be restored.
You can restore one or more tables, either implicitly, by restoring associated schemas or catalogs,
or explicitly, by using the TABLE restore object:
BR> RESTORE $tape-drive, MX TABLE cat1.sch1.table1;
BR> RESTORE $tape-drive, MX TABLE cat1.sch1.t1, TABLE cat2.sch.t2;
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;
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).
For more information, 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;
252 Performing Recovery Operations