• To restore a shorthand view, the view must have been backed up explicitly. In this example,
the shorthand view is restored to a different volume from the one on which it was backed up;
its underlying table and index were previously moved to a different volume from the one on
which they were backed up. The MAP NAMES option moves the files and resets the pointers
to maintain consistency in the SQL object.
1> RESTORE $TAPE, $A.A.SVIEW, AUDITED, LISTALL &
1> &MAP NAMES ($A.A.* TO $D.D.*, &
1> &$B.B.INDX TO $E.E.INDX), &
1> &CATALOGS ($C.CAT FOR $E.*.*, $D.CAT FOR $D.*.*)
• To explicitly restore index table $B.B.INDX:
2> RESTORE $TAPE1, $B.B.INDX, AUDITED, LISTALL &
2> &INDEXES EXPLICIT
• To explicitly restore the secondary partition $D.D.PART:
3> RESTORE $TAPE2, $D.D.PART, LISTALL, AUDITED, &
3> &PARTONLY ON
• To perform the RESTORE process, when disk volumes $A and $B can contain both Enscribe
and SQL files:
4> RESTORE $TAPE, ($A.*.*, $B.*.*), &
4> &CATALOGS ($A.CAT FOR $A.*.* , &
4> &$B.CAT FOR $B.*.*), AUDITED, LISTALL
This command has these results:
â—¦ The tape files are copied to disk if they have the volume name $A or $B. All partitions,
protection views, and indexes associated with files that have volume name $A or $B are
restored.
â—¦ The newly copied disk files are given the same names as the ones on the tape. All the
new disk files have the volume name $A or $B.
â—¦ Existing disk files whose names match the file names generated by RESTORE are purged.
â—¦ Any SQL object that is restored to $A.*.* will be registered in the catalog $A.CAT.
Similarly, any SQL object that is restored to $B.*.* will be registered in the catalog
$B.CAT.
â—¦ An output listing is displayed on the terminal. This listing includes the names of all the
disk files that were successfully restored, the names of disk files that were not restored
because of errors, and the error messages for the disk files that were not generated.
170 RESTORE
To Next Page
Loading...
Need help?
General