Backup and Restore 2 Manual

Backup and Restore 2 Overview
Backup and Restore 2 Manual—522696-019
1-9
SQL/MX
For each of the objects that you specify directly, all its subordinate objects are
automatically backed up or restored unless you exclude them using the job options or
a WHERE expression. For example, constraints, indexes, and index partitions are
included by default. However, you can use the CONSTRAINTS EXCLUDED or
INDEXES EXCLUDED job options to exclude them.

CATALOG

SCHEMA (subordinate object of catalog)

SEQUENCE GENERATOR (subordinate object of the schema)

TABLE (subordinate object of schema)

TABLE PARTITION (subordinate object of table)

CONSTRAINT (subordinate object of table)

INDEX (subordinate object of table)

INDEX PARTITION (subordinate object of the index)

SG_TABLE (subordinate object of the table, if the table contains an
IDENTITY column)
Catalogs
A catalog is a logical object that consists of a collection of schemas.

Backing up a catalog includes backing up all the subordinate objects in its object
hierarchy.

Restoring a catalog includes restoring all the subordinate objects in its object
hierarchy.
You can back up or restore a catalog using any user ID. However, the user ID you use
to backup or restore a catalog should be either the super ID (255,255) or the owner of
all the schemas subordinate to the catalog. Otherwise, you will not be able to back up
or restore the objects subordinate to the catalog.
Schemas
A schema is a logical object that consists of a collection of tables and views.

Backing up a schema includes backing all the subordinate objects in its object
hierarchy.

Restoring a schema includes restoring all the subordinate objects in its object
hierarchy.
Note. Sequence generators are supported only in SQL/MX 3.2.1 version and later.
Note. IDENTITY
column feature is supported only in SQL/MX 3.1 versions and later.