SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-11
Examples—MODIFY CATALOG with REPLACE
NODENAME
Examples—MODIFY CATALOG with REPLACE NODENAME
These examples illustrate the use of the REPLACE clause.

In this example, the node name \TESS is replaced with the node name \FOXII if
the first three characters of the volume name are $DA:
REPLACE NODENAME \TESS ($DA*) WITH \FOXII

In this REPLACE clause, the node name \TESS is replaced with the node name
\FOXII if the volume name is either $SAM or $CAT or if the first three characters of
the volume name are $DA:
REPLACE NODENAME \TESS ($SAM,$CAT,$DA*) WITH \FOXII

In this REPLACE clause, the node name \TESS is replaced with the node name
\FOXII if the volume name is anything other than $SYSTEM:
REPLACE NODENAME \TESS ($* EXCLUDE $SYSTEM) WITH \FOXII

When you use the CHECKONLY option, note that the amount of information
written to the current OUT file depends on whether LISTALL or NO LISTALL is
specified. The MODIFY CATALOG with REPLACE NODENAME command
produces this display for each catalog when requested with the LISTALL option:
Checking catalog \SYS.$VOL.CAT1.
--- \SYS.$VOL.CAT1 was modified.
Checking catalog \SYS.$VOL.CAT2.
--- \SYS.$VOL.CAT2 was not modified.
This summary information is included whether you specify LISTALL or NO
LISTALL:
Summary Information:
nnn catalog(s) require modification.
nnn catalog(s) do not require modification.
MODIFY CATALOG with REPLACE VOLUME
The MODIFY CATALOG with REPLACE VOLUME command modifies volume names
in SQL/MP catalogs on the local node. A catalog can be a user-defined catalog or the
system catalog. This command is intended for use when physically moving a disk from
one node in your network to another node which has a similar disk volume name, or
when system loading a disk with a new disk volume name. When this happens,
changes are not automatically reflected in the catalogs and file labels. The internal
consistency of the database is lost; catalogs (and objects they describe) cannot be
accessed. The MODIFY commands (LABEL, CATALOG) enable you change the
database to reflect the new information.
Before requesting a MODIFY CATALOG with REPLACE VOLUME operation for a
catalog, check that the file labels of the catalog are accessible. If necessary, perform a
Note. The MODIFY CATALOG with REPLACE VOLUME command is supported on systems
running J06.04 and later J-series RVUs and H06.15 and later H-series RVUs only.