Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-62
SQL/MX Restore Examples
Restoring with KEEPGFN Job Option
The KEEPGFN job option is used to specify whether the Guardian file names of table
and index partitions have to be retained or not during the restore operation.
To restore the schema cat1.sch1 to the target catalog cat2:
RESTORE $tape, MX (SCHEMA cat.sch, target CATALOG cat), KEEPGFN
ON, listall on, tapedisposition bot;
On restoring to a remote or a local node:

If the target schema cat2.sch1 exists, the physical file names will be retained as
that of BACKUP-OBJECTS and the subvolume name of the cat2.sch1 will be used.

If the target schema cat2.sch1 does not exist:

If the subvolume name of BACKUP-OBJECTS is already used by any schema,
the restore of schema cat2.sch1 and all its table and indexes are skipped.

If the subvolume name of BACKUP-OBJECTS name is not used by any other
schema, the schema cat2.sch1 will be restored with the BACKUP-OBJECTS
names and subvolume name.
Assume that the schema cat1.sch1 has ZSDSCH01 as subvolume name and the
target schema cat2.sch1 already exists with the subvolume ZSDSCH02.
-sch3 Subordinate schema of cat1
-tab3 Subordinate table of sch3
-tpart3 Subordinate table partition of
tab3
cat2 Catalog
-sch1 Subordinate schema of cat2
-tab1 Subordinate table of sch1
-tpart1 Subordinate table partition of
tab1
-tpart2 Subordinate table partition of
tab1 (last modified on 30 NOV
2002)
cat3 Catalog
Note. BACKUP-OBJECTS are the files that are copied onto the tape.
Table 7-7. Database Structure on Tape (page2of2)
Catalog Schema Table
Table
Partition
or Index
Index
Partition Description