SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-24
Considerations—MODIFY LABEL with REPLACE
NODENUMBER
specified in the REPLACE clause. If ALL is specified, detail is reported about all
SQL objects and object programs specified in target-spec.
MATCH is the default.
For information on report options, see REPORT Option on page R-3.
CHECKONLY
specifies that file labels specified by target-spec should be checked to see if
they contain node numbers that match the criteria specified in the REPLACE
clause. No file labels are modified. The CHECKONLY option enables you to
estimate the effect of running the MODIFY LABEL with REPLACE NODENUMBER
command before actually modifying the file labels.
The amount of information written to the current OUT file depends on whether
LISTALL or NO LISTALL is specified.
Considerations—MODIFY LABEL with REPLACE NODENUMBER

You must be logged on as the super ID to run a MODIFY LABEL with REPLACE
NODENUMBER command unless you specify the CHECKONLY option. If the
MODIFY LABEL with REPLACE NODENUMBER CHECKONLY option is specified,
the user must have authority to read the SQL objects and object programs.

NonStop SQL/MP uses the TMF subsystem to protect the integrity of the database
during the MODIFY operation. MODIFY LABEL with REPLACE NODENUMBER
commands are 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 NODENUMBER is in the
middle of modifying a file label of an SQL object, the changes made to that
particular label are backed out. Changes made to other file labels by the same
instance of the MODIFY LABEL with REPLACE NODENUMBER command are not
backed out. Thus, if an error occurs, some labels might have been changed and
others might not have been.
SQL object program file labels are not modified within a TMF transaction. This
means that if an error occurs while modifying the file label of an object program file,
the label could be left in an inconsistent state.

The MODIFY LABEL with REPLACE NODENUMBER command is one of a set of
commands that uses the MODIFY DICTIONARY utility. The other related
commands are MODIFY LABEL with REPLACE VOLUME (to replace volume
name in file label), MODIFY CATALOG with REPLACE VOLUME (to replace
volume name in catalog), MODIFY CATALOG with REPLACE NODENAME (to
replace node name in catalog), and MODIFY REGISTER Command
(to register
user-defined catalogs in the local system catalog).

To minimize unnecessary searching, make your target-spec clause as specific
as possible. For example, if SQL objects reside only on subvolumes whose names