Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-75
Restore Examples With Both OSS and SQL/MX
Objects
Restoring a Delimited SQL/MX Object to a Different Target
To restore a delimited SQL/MX object to a different delimited target:
BR> RESTORE =mytape, MX (SCHEMA “CATalog1”.”SCHema1”, TGT
CATALOG “SAMPle”).
Restoring SQL/MX Objects With Filtering
You can use a WHERE expression to select and exclude the SQL/MX objects to be
restored. For example, you can filter SQL/MX table partitions by the modification time.
BR> RESTORE =mytape, MX(TPART cat2.sch1.tab1 PARTITION
BR+> (TPART2)) WHERE (MODTIME BEFORE 12 DEC 2000),
BR+> PARTONLY ON, INDEXES EXCLUDED,CONSTRAINTS EXCLUDED;
Because TPART2 was modified after 12 DEC 2000, no objects are restored and an
error occurs.
For more information, see Filters for SQL/MX Objects on page 7-33
Restore Examples With Both OSS and SQL/MX Objects
This example restores both OSS and SQL/MX objects with filtering and without
indexes or constraints:
BR> RESTORE =mytape, OSS (((/usr/bin, TGT /newdir),
BR+> /usr/local/bin) WHERE (EOF > 200000 AND OWNER =
BR+> software.sitaramv), ((/home/sv/myfile, TGT /home/sv),
BR+> /etc/rc, /var/x) WHERE MODTIME AFTER JAN 17 1999), MX
BR+> ((CATALOG cat1, (TABLE cat2.sch2.tab1, TGT SCH sch3),
BR+> (TPART cat2.sch.tab2 PARTITION (tpart5),
BR+> TGT TAB catn1.schn1.tab3)) WHERE (CREATIONTIME BEFORE 12
BR+> DEC 2000)), TAPEDISPOSITION NOREWIND, INDEXES EXCLUDED,
BR+> CONSTRAINTS EXCLUDED,PARTONLY ON;
The same example is formatted to show different parts of the command. It clearly
shows which parts of the source specification apply to each WHERE expression.:
Note. SQL/MX objects containing delimiters are supported only on systems running H06.06 or
later H-series RVUs.