Backup and Restore 2 Manual

Backup and Restore 2 Overview
Backup and Restore 2 Manual—522696-019
1-10
SQL/MX
The schema’s creator owns the schema object and all its subordinate objects:

Sequence Generator

Tables

Table partitions

Indexes

Index partitions

SG_TABLEs associated with those base table that contains an IDENTITY column.
If you attempt to back up or restore objects with a user ID that does not own the
schema associated with those objects, only the catalog and schemas owned by the job
user ID are backed up or restored. Errors are issued for the schemas that are not
backed up or restored.
Tables
A table is a logical object that consists of a collection of partitions and indexes. The
schema’s creator owns the table object, including the table’s subordinate objects:

Table partitions

Indexes

Index partitions

SG_TABLE (subordinate object of the table, if the table contains an IDENTITY
column).
Backing up a table includes:

Nondroppable constraints

Droppable constraints unless you specify the CONSTRAINTS EXCLUDED job
option

All table data unless you specify the SQLDATA OFF job option

Indexes unless you specify the INDEXES EXCLUDED job option

All index partitions unless you specify the INDEXES EXCLUDED job option

SG_TABLE, if the table contains an IDENTITY column.
Restoring a table includes:

Nondroppable constraints
Note. Starting with SQL/MX Release 3.2.1, sequence generators are supported.
Note. IDENTITY
column feature is supported only in SQL/MX 3.1 versions and above.
Note. IDENTITY
column feature is supported only in SQL/MX 3.1 versions and above.
Note. IDENTITY
column feature is supported only in SQL/MX 3.1 versions and above.