Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-38
DIRECTORY Job Option

If you specify CONSTRAINTS INCLUDED, you cannot specify INDEXES
EXCLUDED or PARTONLY ON.

If you specify CONSTRAINTS EXCLUDED, you must specify the INDEXES
EXCLUDED.

If you specify a WHERE expression and CONSTRAINTS INCLUDED, a constraint
is not restored unless it meets the filter criteria of the WHERE expression.

The constraints restored vary depending on whether you specify INCLUDED or
EXCLUDED. Some types of constraints are not supported.
DIRECTORY Job Option
Use this job option to use a BRIC disk file for the RESTORE rather than the BRIC tape
file. For more information about the BRIC file, see Backup and Restore Intermediate
Catalog (BRIC) File on page 1-4. The DIRECTORY option has no default.
directory-file
is the name of BRIC disk file to be used as the directory for a restore job.
Guidelines

If you do not specify this option, RESTORE re-creates the BRIC file from tape
before restoring any files.

Before you can use the DIRECTORY job option, you must restore the BRIC file to
disk using the RESTOREDIR job option.

If you are using the DIRECTORY job option a tape drive is not needed if:

You specify the LISTONLY ON or LISTONLY DETAIL job option.

You specify the VERIFYTAPE OFF job option.

You do not specify the RESTOREDIR job option.

You do not specify the RESTOREBKUPSPEC job option.
CONSTRAINT INCLUDED EXCLUDED
CHECK Yes No
NOT NULL Yes Yes
UNIQUE Yes No
PRIMARY KEY DROPPABLE Yes No
PRIMARY KEY NOT DROPPABLE Yes Yes
REFERENCIAL INTEGRITY No No
DIRECTORY directory-file