Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-42
LISTALL Job Option
ON
restores the partitions with same Guardian file names as is in the backup image.
OFF
restores the partitions with the system-generated Guardian file names.
Guidelines

This job option is not supported for OSS file-system objects.

This job option is supported only for SQL/MX objects. If you specify this job option
without specifying any SQL/MX objects, syntax error occurs.

If PARTONLY is ON and target partitions are created before restoration, the
Guardian file name of target partitions on restore is retained rather than the
Guardian file name of partitions in backup image irrespective of KEEPGFN is ON
or OFF.

On restore if KEEPGFN is ON and the target schema exists already, all partitions
might get restored with same file name and subvolume of that existing target
schema. For more information about naming, see the SQL/MX Installation and
Management Guide.

Restore of a target schema will be skipped if KEEPGFN is ON and subvolume of
that target schema is used by any other target schema. In that case, a target
schema has to be created manually or the other target schema has to be dropped
before the restore operation.

Restore of a table, index, or table partition will be skipped if KEEPGFN is ON and
same Guardian file name is used by some other SQL/MX object under that same
target schema and volume.

The LOCATION job option has higher precedence over KEEPGFN job option and
so mapping given in LOCATION option will override the KEEPGFN behavior
irrespective of KEEPGFN is ON or OFF.

The KEEP job option has higher precedence over KEEPGFN job option.
LISTALL Job Option
Use this job option to generate a list about the objects being restored to the OUT file or
your current terminal. OFF is the default.
Note. The KEEPGFN job option is supported only on systems running H06.11 or later H-series
RVUs.
LISTALL { ON | OFF | DETAIL }