SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-15
Considerations-MODIFY CATALOG with REPLACE
VOLUME
REPLACE clause. If ALL is specified, details are reported about all SQL catalog
tables specified in target-spec irrespective of a match being identified with regards
to volume name. MATCH is the default option.
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 volume 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 VOLUME
command before actually modifying the catalog tables.
Considerations-MODIFY CATALOG with REPLACE VOLUME

You must be logged on as the super ID to run a MODIFY CATALOG 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. MODIFY CATALOG with REPLACE VOLUME command is 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 VOLUME 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
VOLUME command are not backed out. Thus, for one set of catalog tables, either
the volume name will be changed in all the tables in the set or it will not be
changed in any of the tables in the set.

The MODIFY CATALOG 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 LABEL with REPLACE VOLUME
(to replace
volume name in file label), 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 executing 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
CATALOG with REPLACE VOLUME cannot be run first because it will try to
identify the CATALOG name from file label for record updation in catalog indexes.