SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-12
MODIFY CATALOG with REPLACE VOLUME
MODIFY LABEL with REPLACE VOLUME operation on all catalog tables in the
catalog first. For more information about MODIFY CATALOG with REPLACE
VOLUME, see Considerations-MODIFY CATALOG with REPLACE VOLUME for more
details.
catalog-list-1 [ EXCLUDE catalog-list-2 ]
identifies one or more SQL catalogs to modify. The catalogs need not be registered
in the system catalog at the time the MODIFY CATALOG with REPLACE VOLUME
command is run. To specify a single catalog, enter the name of the catalog (the
name of the subvolume that contains the catalog). To specify multiple catalogs in a
catalogset, use wild-card characters. You can use these wild-card characters:
For example, $DATA.* specifies all catalogs on the volume $DATA, and *.*
specifies all catalogs on the node. *VOL* matches NEWVOL, OLDVOL1, and
VOL45. VOL? matches VOL1 and VOLX, but not VOL or VOL48.
The MODIFY CATALOG with REPLACE VOLUME command assumes that a
subvolume contains a valid catalog if the subvolume contains the catalog table
MODIFY [DICTIONARY] CATALOG target-spec replace-spec
WITH volume-name [ [,] option ] ... ;
target-spec is:
catalog-list-1 [ EXCLUDE catalog-list-2 ]
replace-spec is:
REPLACE VOLUME volume-name [ ( node-name1 [,node-name2]
[EXCLUDE node-name3 [,node-name4]… ] ) ]
option is:
[| ALLOWERRORS [ OFF | ON | number-of-errors ] |]
[| [ NO ] LISTALL |]
[| DETAIL [ MATCH | ALL ] REPORT [ TO EMS-Collector ]|]
[| [ ON ]|]
[| [ OFF ]|]
[| CHECKONLY |]
catalog-list-n (where n = 1,2) is:
{ catalogset }
{ ( catalogset [ , catalogset ] ... ) }
* Matches 0 to 8 characters in the position where it appears. Specifying only
an asterisk indicates that any name is acceptable. To specify all volumes,
use either $*.* or *.*
? Matches any single character