SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-8
Considerations—MODIFY CATALOG with
REPLACE NODENAME
LISTALL is the default.
DETAIL [ MATCH | ALL ] REPORT [ TO EMS-Collector ]
[ ON ]
[ OFF ]
specifies that detail about the MODIFY CATALOG with REPLACE NODENAME
operation is to be sent in event messages to a valid EMS collector.
If MATCH is specified, detailed is reported about SQL catalog tables specified in
target-spec that contain node names that match the criteria specified in the
REPLACE clause. If ALL is specified, detailed is reported about all SQL catalog
tables specified in target-spec.
MATCH is the default.
For information on report options, see REPORT Option on page R-3.
CHECKONLY
specifies that the catalog tables specified in target-spec should be checked to
see if they contain node names that match the criteria specified in the REPLACE
clause. No catalog tables are changed. The CHECKONLY option enables you to
estimate the effect of running the MODIFY CATALOG with REPLACE NODENAME
command before actually modifying the catalog tables.
Considerations—MODIFY CATALOG with REPLACE NODENAME

You must be logged on as the super ID to run a MODIFY CATALOG with
REPLACE NODENAME 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. MODIFY CATALOG with REPLACE NODENAME commands
are not allowed inside a user-defined transaction.
One system-defined transaction is used for each set of catalog tables modified. If
an error occurs while MODIFY CATALOG with REPLACE NODENAME is
modifying a catalog table, the changes made to that catalog table and all other
tables in the same catalog are backed out. However, changes that have been
made to other catalogs during the same instance of the MODIFY CATALOG with
REPLACE NODENAME command are not backed out. Thus, for one set of catalog
tables, either the node name is changed in all the tables in the set or it is not
changed in any of the tables in the set.

The MODIFY CATALOG with REPLACE NODENAME Command is one of a set of
commands that uses the MODIFY DICTIONARY utility. The other related
commands are MODIFY CATALOG with REPLACE VOLUME (to replace volume
name in catalog), MODIFY LABEL with REPLACE NODENUMBER (to replace
node number in file labels), MODIFY LABEL with REPLACE VOLUME (to replace