index on an existing table, if you know that the table has not changed since the index was
backed up, use RESTORE with the INDEXES EXPLICIT option.
• If a base table and its indexes are backed up with the INDEXES IMPLICIT option, you can
restore the base table only by specifying the INDEXES EXPLICIT option and the base table
name in the RESTORE command.
Examples
• To restore all SQL indexes whose tables were on the volume $FIN:
1> RESTORE $TAPE, $FIN.*.* , INDEXES IMPLICIT, AUDITED
You can produce the same result if you do not specify the IMPLICIT parameter.
• To restore only SQL indexes that have the primary partition on the volume $FIN:
1> RESTORE $TAPE1, $FIN.*.*, INDEXES EXPLICIT, AUDITED
ISLACK
The ISLACK option sets the minimum slack space for index blocks. Used it only when converting
key-sequenced Enscribe files from the DP1 to DP2 format.
ISLACK percentage
percentage
is an integer in the range 0 through 99. The default value is 0.
KEEP
The KEEP option specifies that a file on tape is restored only if it does not have the same name as
an existing disk file.
KEEP
Guidelines
• If you omit the KEEP option, the file on disk is purged when a file of the same name is restored
from tape. However, if the file on tape is an Enscribe file and the file on disk is an SQL file
(or vice versa), the file is not purged.
• To specify the MAP NAMES or CATALOG[S] and PARTONLY ON options in the same RESTORE
command, you must also specify the KEEP option.
LISTALL
The LISTALL option lists the names of the disk files that are copied successfully from tape (by
RESTORE) and the names of disk files that were not restored (because of errors).
LISTALL
Guideline
If you omit the LISTALL option, RESTORE lists only the file names associated with error messages.
RESTORE sends the listing to the OUT listfile specified in your command or to the device
where you entered the command.
136 RESTORE
To Next Page
Loading...
Need help?
General