Ensure that the volume name of the remote system should not be more than seven characters
(including $).
• To change file names, use the MAP NAMES option, not the VOL option. The VOL option has
limitations handling secondary partitions, alternate-key files, and SQL objects.
• Wild-card characters can be used in the volume, subvolume, and file-id fields of the
old-fileset-list:
* (asterisk) matches from 0 through 8 characters in the position where it appears.
? (question mark) matches one character in the position where it appears.
For example, the volume name $SB?? matches all four-character volume names that begin
with SB. The file name *CH? matches all file names that end with CH followed by any single
character.
• The new-fileset-list parameter cannot include the question mark (?) wild-card character,
but can include the asterisk (*).
• When more than one renaming pattern is specified in the MAP NAMES option, the first
applicable pattern is used if there is a conflict.
• Use the RESTORE AUTOCREATECATALOG and CATALOGS options (with the MAP NAMES
option) to move SQL files to another node. In addition to these options, use the SQLCOMPILE
ON option to move an SQL program file. The SQL program file must have been compiled
before it was backed up.
Be careful that you define the MAP NAMES and CATALOGS parameters correctly for the
dependent tables, indexes, views, and programs. An incorrect mapping scheme can leave
the objects invalid or cause the RESTORE process to fail. In addition to the examples here, for
more information, see Restoring Using Name Mapping (page 171) and Restoring SQL Files
(page 166).
RESTORE Options 139
To Next Page
Loading...
Need help?
General