SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Planning Database Security and Recovery
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
5-29
Using Backup and Restore 2 for SQL/MX Database
Recovery
Index Explicitly backs up the named
index. Unless specifically
excluded, an index is
automatically backed up when
you back up its associated
catalog or schema. See
Backing Up Indices and Index
Partitions on page 5-33
Explicitly restores the named
index. Unless specifically
excluded, an index is
automatically restored when you
restore its associated catalog or
schema. See Backing Up Indices
and Index Partitions on
page 5-33.
Index partition Explicitly backs up the named
partitions of a named index
when you specify the IPART
object type. To back up the
SQL data in an index partition
and its metadata, specify
SQLDATA ON. To back up the
DDL information in an index
partition and its metadata,
specify SQLDATA OFF. See
Backing Up Indices and Index
Partitions on page 5-33.
Explicitly restores the named
partitions of a named index when
you specify the IPART object
type. To restore the SQL data in a
table partition and its metadata,
specify SQLDATA ON. To restore
the DDL information in an index
partition and its metadata, specify
SQLDATA OFF. See Backing Up
Indices and Index Partitions on
page 5-33.
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