SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Planning Database Security and Recovery
HP NonStop SQL/MX Installation and Management Guide—523723-004
5-29
Using Backup and Restore 2 for Database Recovery
Constraints Unless you specify the
CONSTRAINTS EXCLUDED
option, all SQL/MX constraints
are automatically backed up
when you back up their
catalog, schema, or table. See
Constraints
on page 5-33.
All constraints except
REFERENTIAL INTEGRITY can
be restored with Backup and
Restore 2. To restore a
REFERENTIAL INTEGRITY
constraint, run the OBEY
command file for the constraint
generated by the RESTORE
SHOWDDL ON command. See
Using the RESTORE SHOWDDL
ON Option to Re-Create Objects
on page 5-36.
Index Unless you specify the
INDEXES EXCLUDED option,
all indexes and their index
partitions are automatically
backed up when you back up
their catalog, schema, or table.
See Indexes and Index
Partitions on page 5-33.
Unless you specify the index with
the INDEXES EXCLUDED option,
an index and its index partitions
are automatically restored when
you restore their catalog, schema,
or table.
Index partition
metadata
To back up only the metadata
for index partitions, specify the
SQLDATA OFF option and do
not specify INDEXES
EXCLUDED when you back up
the index’s table. The metadata
is backed up, and the user data
is not.
To restore only the metadata for
index partitions, specify the
SQLDATA OFF option and do not
specify INDEXES EXCLUDED
when you restore the index’s
table. The metadata is restored,
and the user data is not.
SPJ When you back up a catalog or
schema, BACKUP
automatically backs up the
SQL/MX metadata of all SPJs
therein. To back up the Java
bytecode of the SPJ Java
methods, which are stored in
class or JAR files in OSS
directories, you must specify
OSS backup objects. See
Backing Up and Restoring SPJ
Metadata Information on
page 5-35 and Backing Up and
Restoring SPJ Class or JAR
Files on page 5-35.
Does not automatically restore
SPJs. You can run the OBEY
command file for the SPJ
generated by the RESTORE
SHOWDDL ON command to
reregister SPJs. See Using the
RESTORE SHOWDDL ON
Option to Re-Create Objects on
page 5-36.
Table 5-2. Backup and Restore of SQL/MX and OSS Objects (page 2 of 3)
SQL/MX or OSS
Object BACKUP Command RESTORE Command