SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

M-19

MODIFY LABEL

The MODIFY LABEL command has two options that can be specified as the

replace-spec:



MODIFY LABEL with REPLACE NODENUMBER



MODIFY LABEL with REPLACE VOLUME

MODIFY LABEL with REPLACE NODENUMBER

The MODIFY LABEL with REPLACE NODENUMBER command modifies node

numbers stored in file labels of SQL objects and SQL object programs on the local

node. The file label of an SQL object or object program contains names in internal

network form and therefore always contains one or more node numbers.

This command is intended for use when physically moving a disk from one node to

another node, or when system loading a node with a new node name or number.

These changes are not automatically reflected in the catalogs and file labels. When

this happens, the internal consistency of the database is lost; catalogs (and objects

they describe) cannot be accessed. The MODIFY commands (LABEL, CATALOG, and

information.

SQL objects include SQL catalog tables, user-defined tables, table partitions, indexes,

index partitions, views, and collations.