RDF System Management Manual for J-series and H-series RVUs (RDF 1.10)

4. You are restoring four tables from two different schemas in catalog PCAT.
5. Schema information:
Backup schema nameSchema subvolumePrimary schema name
BCAT.MYSCHEMAZSDAAAAAPCAT.MYSCHEMA
BCAT.MYSCHEMAXZSDBBBBBPCAT.MYSCHEMAX
1. Table and Index information:
Guardian Names for partitions and indexesTable or Index Name
\P.$data01.ZSDAAAAA.HEBFRW00
\P.$data02.ZSDAAAAA.HEBFRX00
\P.$data03.ZSDAAAAA.HEBFRY00
\P.$data02.ZSDAAAAA.YREWPO00
PCAT.MYSCHEMA.MYTABLE1
PCAT.MYSCHEMA.MYINDEX1
\P.$data01.ZSDAAAAA.GABCDE00
\P.$data02.ZSDAAAAA.GABCDF00
\P.$data03.ZSDAAAAA.GABCDG00
\P.$data02.ZSDAAAAA.YZZWPO00
PCAT.MYSCHEMA.MYTABLE2
PCAT.MYSCHEMA.MYINDEX2
\P.$data01.ZSDBBBBB.FGABCD00
\P.$data02.ZSDBBBBB.FGABCE00
\P.$data03.ZSDBBBBB.FGABCF00
\P.$data03.ZSDBBBBB.IGABCD00
PCAT.MYSCHEMAX.MYTABLE1
PCAT.MYSCHEMAX.MYINDEX1
\P.$data04.ZSDBBBBB.EFGHIJ00
\P.$data03.ZSDBBBBB.DEFGHI00
PCAT.MYSCHEMAX.MYTABLE2
PCAT.MYSCHEMAX.MYINDEX2
2. The RESTORE command would be:
RESTORE $tape,
( MX
( ( TBL PCAT.MYSCHEMA.MYTABLE1, TGT CATALOG BCAT ),
( TBL PCAT.MYSCHEMA.MYTABLE2, TGT CATALOG BCAT ),
( TBL PCAT.MYSCHEMX.MYTABLE1, TGT CATALOG BCAT ),
( TBL PCAT.MYSCHEMX.MYTABLE2, TGT CATALOG BCAT )
),
LOCATION
(
\P.$data01.ZSDAAAAA.HEBFRW00 TO \B.$data01.ZSDAAAAA.HEBFRW00,
\P.$data02.ZSDAAAAA.HEBFRX00 TO \B.$data02.ZSDAAAAA.HEBFRX00,
\P.$data03.ZSDAAAAA.HEBFRY00 TO \B.$data03.ZSDAAAAA.HEBFRY00,
\P.$data02.ZSDAAAAA.YREWPO00 TO \B.$data02.ZSDAAAAA.YREWPO00,
\P.$data01.ZSDAAAAA.GABCDE00 TO \B.$data01.ZSDAAAAA.GABCDE00,
\P.$data02.ZSDAAAAA.GABCRF00 TO \B.$data02.ZSDAAAAA.GABCRF00,
\P.$data03.ZSDAAAAA.GABCRG00 TO \B.$data03.ZSDAAAAA.GABCRG00,
\P.$data02.ZSDAAAAA.YZZWPO00 TO \B.$data02.ZSDAAAAA.YZZWPO00,
\P.$data01.ZSDBBBBB.FGABCD00 TO \B.$data01.ZSDBBBBB.FGABCD00,
\P.$data02.ZSDBBBBB.FGABCE00 TO \B.$data02.ZSDBBBBB.FGABCE00,
\P.$data03.ZSDBBBBB.FGABCF00 TO \B.$data03.ZSDBBBBB.FGABCF00,
\P.$data03.ZSDBBBBB.IGABCD00 TO \B.$data03.ZSDBBBBB.IGABCD00,
\P.$data04.ZSDBBBBB.EFGHIJ00 TO \B.$data04.ZSDBBBBB.EFGHIJ00,
\P.$data03.ZSDBBBBB.DEFGHI00 TO \B.$data03.ZSDBBBBB.DEFGHI00
), INDEXES INCLUDED
);
As described in “Creating a NonStop SQL/MX Backup Database From an Existing Primary
Database” (page 310), you can use the MXGNAMES utility to automatically generate the correct
LOCATION clauses, substituting the backup node name as needed. However, you must remap
any nonmatching volume names in these locations manually.
318 NonStop SQL/MX and RDF