Backup and Restore 2 Manual

BRCOM BACKUP Command
Backup and Restore 2 Manual—522696-019
6-27
CONSTRAINTS Job Option

BRIC is an unstructured binary code 0 file and contains the metadata of the backup
operation.

BRCMD is a code 101 file and contains the command that was used for the
backup operation.

You must manage the BRIC and BRCMD files because BR2 does not catalog
these files or the information inside them.

If the CLEANUP command is used from BRCOM for a JOB ID, the files are
removed from the location. If the job is aborted or abended, the files might not be
present or might contain incomplete information.

The BRIC and BRCMD files are saved with the security privileges of the user
running the BR2 job.

For a backcopy, the saved BRIC file corresponds to the target tape which is written
in to.
CONSTRAINTS Job Option
Constraints are rules that protect the integrity of data in a table by restricting the values
in a particular column or set of columns to those that meet the conditions of the
constraints. This job option specifies which constraints are backed up from the source
table. INCLUDED is the default.
INCLUDED
backs up the primary key, unique, not null, and check constraints from the source
table.
EXCLUDED
backs up the NOT NULL constraint from the source table. The PRIMARY KEY
constraint from the source table is backed up only if it is NOT DROPPABLE.
Guidelines

The CONSTRAINTS job option supports only SQL/MX objects. If you specify this
option but do not specify any SQL/MX object, an error occurs. This option is not
supported for OSS.

If you specify PARTONLY ON, you must specify CONTRAINTS EXCLUDED.

If you specify CONSTRAINTS INCLUDED, you cannot specify INDEXES
EXCLUDED or PARTONLY ON.

If you specify CONSTRAINTS INCLUDED during the RESTORE command, it is
meaningful only if CONSTRAINTS INCLUDED was specified or defaulted to during
the BACKUP command.
CONSTRAINTS { EXCLUDED | INCLUDED }