SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-34
Considerations-MODIFY LABEL with REPLACE
VOLUME
DETAIL [ MATCH | ALL ] REPORT [ TO EMS-Collector ]
[ON ]
[OFF ]
specifies the details about the MODIFY LABEL with REPLACE VOLUME operation
that is to be sent in event messages to a valid EMS collector.
If MATCH is specified, details are reported about SQL file labels specified in target-
spec that contain volume names that match the criteria specified in the REPLACE
clause. If ALL is specified, details are reported about all SQL file labels specified in
target-spec irrespective of a match being identified with regards to volume name.
MATCH is the default option.
CHECKONLY
specifies that the file labels specified in target-spec should be checked to see if
they contain volume names that match the criteria specified in the REPLACE
clause. No file labels are changed. The CHECKONLY option enables you to
estimate the effect of running the MODIFY LABEL with REPLACE VOLUME
command before modifying the SQL file labels.
Considerations-MODIFY LABEL with REPLACE VOLUME

You must be logged on as the super ID to run a MODIFY LABEL with REPLACE
VOLUME command unless you specify the CHECKONLY option. If you specify the
CHECKONLY option, you must have authority to read the catalogs.

SQL uses the TMF subsystem to protect the integrity of the database during the
MODIFY operation. The MODIFY LABEL with REPLACE VOLUME command is
not allowed inside a user-defined transaction.
One system-defined transaction is used for each SQL object file label modified. If
an error occurs while MODIFY LABEL with REPLACE VOLUME is modifying a file
label, the changes made to that particular file label is backed out. Changes made
to other file labels by the same instance of MODIFY LABEL with REPLACE
VOLUME command are not backed out. Thus, if an error occurs, some labels
might have been changed and others might not have been changed.

The MODIFY LABEL with REPLACE VOLUME command is one of a set of
commands that uses the MODIFY DICTIONARY utility. The other related
commands are MODIFY CATALOG with REPLACE NODENAME (to replace node
name in catalog), MODIFY LABEL with REPLACE NODENUMBER (to replace
node number in file label), MODIFY CATALOG with REPLACE VOLUME (to
replace volume name in catalog), and MODIFY REGISTER Command (to register
user-defined catalogs in the local system catalog).

If the volume name where the SQL catalog exists has already been changed to a
different name, then run the MODIFY LABEL with REPLACE VOLUME command
on all catalog objects in the catalog sub-volume before running the MODIFY
CATALOG with REPLACE VOLUME command. This is required to update the
volume name corresponding to the CATALOG field in the file label. The MODIFY