Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-52
SQLDATA Job Option

To use OBEYDDL job option, you must specify the SHOWDDLLOC option and set
SHOWDDL option to ON.

OBEYDDL job option is used for restoring catalogs, schemas, and tables.
Restoring table partitions, indexes, and index partitions is not supported with this
option.
SQLDATA Job Option
Use this job option to use the DDL information to re-create an empty version of table
partitions and index partitions. ON is the default.
OFF
uses the DDL information to re-create an empty version of the SQL/MX object.
The table partitions or index partitions are not populated.
ON
restores the SQL data.
Guidelines

This job option is not supported for OSS.

The SQLDATA job option is supported only for SQL/MX objects. If you specify this
job option but do not specify any SQL/MX objects, an error occurs.

If you specify SQLDATA OFF, you cannot specify the PARTONLY ON job option.

Table partitions and index partitions are the only supported SQL/MX objects that
are physical objects. The SQLDATA OFF job option restores only the object's DDL.
The user data in the table partitions and index partitions is not restored.

Catalogs, schemas, tables, and indexes are logical objects. Therefore, the
SQLDATA OFF job option does not affect the restore of these objects. However,
the subordinate table partitions and index partitions are affected.
TAPEDATE Job Option
Use this job option to set the lastopen and modification timestamps. ON is the default.
ON
sets the lastopen and modification timestamps of the restored objects to the values
they had during the backup job.
SQLDATA { OFF | ON }
TAPEDATE { ON | OFF }