Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-51
OBEYDDL Job Option
oss-directory
is the name of an OSS directory in which the restore operation should generate the
files.
Guidelines

If you specify this job option, you must also specify the SHOWDDL ON job option.

The SHOWDDLLOC 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 an OSS directory that already contains SHOWDDL files with the
same name as the files that are being generated, the original files are overwritten.
OBEYDDL Job Option
The OBEYDDL job option restores views, triggers, referential integrity constraints, and
stored procedures. This option is used to obey the DDL information automatically in the
OSS files captured during the backup operation.
ON
Restores views, triggers, referential integrity constraints, and stored procedures.
OFF
Does not restore views, triggers, referential integrity constraints, and stored
procedures.
Guidelines

If the DDL statement has a dependency on other catalogs, schemas or tables that
do not exist or are not yet restored, then errors are returned during the restore
operation. The DDL statements and errors are logged in log files named
OBEYLOG_<dep_objects>, where dep_objects can be either VIEWS,
TRIGGERS, RI_CONSTRAINTS, or STORED_PROCEDURES.
These OBEYLOG files are found in the OSS location specified in the
SHOWDDLLOC option. You must verify the log files for the failed DDL statements
and manually run them after resolving the errors.

For example, to restore stored procedures, the Java class file must be present in
the location specified in the DDL statement else the DDL statement fails.

OBEYDDL job option is supported for SQL/MX objects.

OBEYDDL job option requires MXCI to be present in
/usr/tandem/sqlmx/bin/mxci for its proper functioning.
OBEYDDL { OFF | ON }