Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-73
SQL/MX Restore Examples

However, all the objects from the backup job under the catalog cat1 are restored to
the same parent object they were backed up from.
Consider the following points while restoring partitions to an alternate target table:

While restoring a table partition, if the target table has partitions in it, ensure that
the partition range matches with the partition range in the backed up image. If the
partitions do not exist, they will be created during the restore operation.

If the ranges of table partitions mismatch with the ones that are in the backup
image, BR2 will create new partitions with the same name as in the backup image
and restore the data. This will result in an inconsistent table.
Table 7-17. Some SQL/MX Objects Restored to a Different Target
Catalog Schema Table
Table
Partition
or Index
Index
Partition Description
cat1 Catalog
-sch1 Subordinate schema of cat1
-tab1 Subordinate table of sch1
-tpart1 Subordinate table partition of
tab1
-sch2 Subordinate schema of cat1
-tab2 Subordinate table of sch2
-tpart1 Subordinate table partition of
tab2
-tpart2 Subordinate table partition of
tab2
-tpart5 Subordinate table partition of
tab2
-sch3 Subordinate schema of cat1
-tab3 Subordinate table of sch3
-tpart3 Subordinate table partition of
tab3
-tpart5 Subordinate table partition of
tab3
cat3 Catalog
-sch1 Subordinate schema of cat1
-tab1 Subordinate table of sch1
-tpart1 Subordinate table partition of
tab1
-tpart2 Subordinate table partition of
tab1