1.
Primary Node: \P Backup Node: \B
2.
All volume names are identical on the primary and backup systems.
3.
Primary catalog name: PCAT Backup catalog name: BCAT
4.
You are restoring four tables from two different schemas in catalog PCAT.
5.
Schema information:
Backup schema name
Schema subvolume
Primary schema name
BCAT.MYSCHEMA
ZSDAAAAA
PCAT.MYSCHEMA
BCAT.MYSCHEMAX
ZSDBBBBB
PCAT.MYSCHEMAX
1.
Table and Index information:
Guardian Names for partitions and indexes
Table 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
);
334
NonStop SQL/MX and RDF
Содержание NonStop RDF
Страница 68: ...68 ...
Страница 186: ...186 ...
Страница 260: ...260 ...
Страница 278: ...278 ...
Страница 284: ...284 ...
Страница 290: ...290 ...
Страница 308: ...308 ...
Страница 322: ...322 ...
Страница 336: ...336 ...
Страница 348: ...348 ...
Страница 464: ...464 ...
Страница 478: ......