Backup and Restore 2 Manual

Backup and Restore 2 Overview
Backup and Restore 2 Manual—522696-019
1-12
SQL/MX
Table Partitions
A table partition is a subordinate object of the table object. A table partition is a
physical object:

Backing up an individual table partition includes the partition data only when you
specify the PARTONLY job option.

Restoring an individual table partition includes the partition data and is only
permitted when you specify the PARTONLY ON job option.
Indexes
An index is a subordinate object of the table object. It is a logical object. Index consists
of index partition. The creator of the schema owns the index object, including the
subordinate objects of the index.
Index Partitions
An index partition is a subordinate object of the Index object. An index partition is a
physical object:

Backing up an individual index partition includes the partition data only when you
specify the PARTONLY job option.

Restoring an individual index partition includes the partition data and is only
permitted when you specify the PARTONLY ON job option.
Constraints
A constraint is a logical object. You cannot directly specify a constraint in BACKUP or
RESTORE commands. To back up or restore a constraint, you must back up or restore
the table that contains the constraint. The constraints that are backed up or restored
depends on whether you specify CONSTRAINTS INCLUDED or CONSTRAINTS
EXCLUDED:
CONSTRAINTS INCLUDED EXCLUDED
Check Yes No
Not Null Yes Yes
Unique Yes No
Primary key
droppable
Yes No
Primary key not
droppable
Yes Yes
Referential
integrity
No No