Backup and Restore 2 Manual

Backup and Restore 2 Overview
Backup and Restore 2 Manual—522696-019
1-11
SQL/MX

Droppable constraints unless you specify the CONSTRAINTS EXCLUDED job
option

All table data unless you specify the SQLDATA OFF job option

Indexes and index partitions unless you specify the INDEXES EXCLUDED job
option

SG_TABLE, if the table contains an IDENTITY column.
When you restore a SQL/MX table that already exists, the object is first dropped and
then restored, unless the table has referential integrity constraints, views, stored
procedures, or triggers. You can use the MXCI SHOWDDL command to check if the
table has subordinate objects. For more information, see the SQL/MX Reference
Manual.
The only subordinate objects present after the restore operation are the objects that
were backed up. Any subordinate objects added after the back up are lost after the
restore operation. For example, SQL/MX table C contains table partitions S1 and S2
when you back it up. Later, you create another table partition in this table, S3. If you
restore table C, table C is dropped and then restored. Table partitions S1 and S2 are
restored, but table partition S3 is lost. This behavior differs from that of OSS. For more
information about OSS, see OSS Objects on page 1-5.
IDENTITY column:
An IDENTITY column is a numeric column in a table for which the system generates
unique values using the internal sequence generator. For usage details, see SQL/MX
3.1 Reference Manual.
SG_TABLE:
An SG_TABLE is a Sequence Generator table. SG_TABLE is an associated table
which is automatically created when you define an IDENTITY column in a base table.
For usage details, see SQL/MX 3.2.1 Reference Manual.
SEQUENCE GENERATOR:
A sequence generator object is a schema level object that is used to create a
sequence of numeric values. The sequence values can be used to create unique
values across a set of tables.
BR2 does not support individual backup and restore of sequence generator objects.
However, these objects can be backed up and restored as part of a full schema or
catalog level backup-restore operation.
For more information, see SQL/MX 3.2.1 Reference Manual.
Note. IDENTITY column feature is supported only in SQL/MX 3.1 versions and later.
Note. Starting with SQL/MX Release 3.2.1, sequence generators are supported.