Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-41
KEEP Job Option

Use this option with caution. Job creation fails if there is already a job in BRJOBS
with the same job identifier or if there are any files in $workvolume.jobid. If you
omit this option and let BRCOM assign the job identifier, job creation will not fail for
these reasons.
KEEP Job Option
Use this job option to specify whether a tape file is restored if a file with the same name
already exists on disk. OFF is the default.
ON
restores an object on tape only if the object does not already exist at the target.
OFF
restores an object on tape even if an OSS directory, SQL/MX table, or its
subordinate object already exists at the target. In some circumstances, the disk file
cannot be purged.
Guidelines

If you specify the KEEP ON job option, any objects on tape for which there are
active objects in the specified target are not restored.

Catalogs and schemas cannot be dropped even if you specify KEEP OFF.
Dropping catalogs and schemas would destroy files that were not previously
backed up.

If you specify the KEEP OFF job option, the disk file is purged when a file of the
same name is restored from tape unless the table contains constraints, views,
triggers, or stored procedures. In that case, the table cannot be dropped. For
information about checking if the table has these subordinate objects and dropping
objects, see the MXCI command SHOWDDL in the SQL/MX Reference Manual
and SQL/MX Installation and Management Guide.

When a restore job (for OSS objects) with the KEEP ON job option fails, a
temporary file with a unique name will be left in the target directory.
KEEPGFN Job Option
Use this job option to specify whether the Guardian file names of table and index
partitions have to be retained during the restore operation. This job option is supported
only for SQL/MX objects. ON is the default.
KEEP { ON | OFF }
KEEPGFN { ON | OFF }