SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-36
Considerations-MODIFY LABEL with REPLACE
VOLUME

Partitioned objects. Volume names in the file labels of partitions of tables and
indexes are not modified unless those partitions are specified in the MODIFY
LABEL with REPLACE VOLUME command.
For a partitioned SQL object, each volume that contains a partition of the
object must be specified separately. The MODIFY LABEL with REPLACE
VOLUME command does not automatically modify information about all
partitions of a partitioned object. You must be aware how the database is
distributed and partitioned. Document the MODIFY commands that need to be
run, and the nodes they need to be run on, before they are used. Prepare
scripts that runs the necessary MODIFY commands.
When you add a new dependent object to the database, update the scripts.
While the system is in a consistent state, you can use the DISPLAY USE OF
command to locate dependent objects. After MODIFY commands have been
run, you can use the VERIFY utility to verify that the database is in a consistent
state. While the system is in a consistent state, issue a SELECT from the
PARTNS partitions table to locate partitions. Prepare scripts that run the
necessary MODIFY commands. After the MODIFY commands are run, use the
VERIFY utility to verify that the database is in a consistent state.

The MODIFY LABEL with REPLACE VOLUME command does not mark SQL
object programs as invalid in either the catalog or the object program file label.

The MODIFY LABEL with REPLACE VOLUME command does not change the
redefinition timestamp in either the catalog or the file label.

DEFINE names can be used in programs to specify the names of catalogs,
tables, views, indexes, partitions, and other programs. The current DEFINE set
at the time the program is SQL compiled is saved in the object program file. If
objects or object programs specified by the DEFINEs are moved between the
time the program is SQL compiled and the time the program is run, the
DEFINEs must be changed to reflect the new location of the objects and object
programs. This instruction is true regardless of how the database was moved
or whether the MODIFY DICTIONARY utility was used to modify the node
names and numbers. The MODIFY DICTIONARY utility does not modify the
node names in the DEFINE set stored in the object program file.

After you have modified the DEFINEs, if automatic recompilation is enabled,
the programs are automatically recompiled using the new DEFINEs.

A catalog and the objects registered in it must be on the same node. However,
it is possible for an object to be on a different disk than its catalog. The
MODIFY DICTIONARY utility is not intended to correct the situation where a
disk containing objects is moved to a new node, but the disk containing the
associated catalog is not moved to the new node.