SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

M-5

MODIFY CATALOG with REPLACE NODENAME

The MODIFY CATALOG with REPLACE NODENAME command modifies node 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, or when system loading a node with a new node name

or number. 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, and

Before requesting a MODIFY CATALOG with REPLACE NODENAME operation for a

catalog, check that the file labels of the catalog are accessible. If necessary, perform a

MODIFY LABEL with REPLACE NODENUMBER operation on all catalog tables in the

catalog first, if necessary.

catalog-list-1 [ EXCLUDE catalog-list-2 ]

identifies one or more SQL catalogs to modify. The catalogs need not be registered

in the system catalog at the time the MODIFY CATALOG with REPLACE

NODENAME command is run.

MODIFY [DICTIONARY] CATALOG target-spec replace-spec

WITH node-name [ [,] option ] ... ;

target-spec is:

catalog-list-1 [ EXCLUDE catalog-list-2 ]

replace-spec is:

REPLACE NODENAME node-name [ ( volumeset [,volumeset]

[EXCLUDE volumeset [,volumeset] ] ) ]

option is:

[| ALLOWERRORS [ OFF | ON | number-of-errors ] |]

[| [ NO ] LISTALL |]

[| DETAIL [ MATCH | ALL ] REPORT [ TO EMS-Collector ]|]

[| [ ON ]|]

[| [ OFF ]|]

[| CHECKONLY |]

catalog-list-n (where n = 1,2) is:

{ catalogset }

{ ( catalogset [ , catalogset ] ... ) }