SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-42
Considerations—MODIFY REGISTER
Considerations—MODIFY REGISTER

You must be logged on as the super ID to run a MODIFY DICTIONARY command,
unless you specify the CHECKONLY option.

NonStop SQL/MP uses the TMF subsystem to protect the integrity of the database
during the MODIFY REGISTER operation. MODIFY commands are not allowed
inside a user-defined transaction.

The MODIFY REGISTER command is one of a set of commands that uses the
MODIFY DICTIONARY utility. The other related commands are MODIFY LABEL
with REPLACE NODENUMBER (to change node numbers in file labels) and
MODIFY CATALOG (to change node names in SQL catalogs).

MODIFY REGISTER does not mark SQL object programs as invalid in either the
catalog or in the object program file label.

MODIFY REGISTER does not change the redefinition timestamp in either the
catalog or the file label.

The MODIFY DICTIONARY utility does not handle remote nodes. If you specify a
remote catalog name, the MODIFY REGISTER command reports a nonfatal error.
Because of this, each node with dependent objects or partitioned objects must
have a version of NonStop SQL/MP that supports MODIFY commands.

The MODIFY REGISTER command registers a catalog in the system catalog.
However, there is no command that removes information about a catalog from the
system catalog. For example, suppose that a disk containing the catalog
$VOL1.CAT and the objects registered in it is moved from \SYSA to \SYSB. The
MODIFY DICTIONARY REGISTER option can be used to register the catalog in
the system catalog on \SYSB, but a licensed SQLCI2 process must be used to
remove the information about the $VOL1.CAT catalog from the system catalog on
\SYSA.

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.
Examples—MODIFY REGISTER

This example shows what is displayed for each catalog, if LISTALL is specified:
Registering catalog \SYS.$VOL.CAT1.
--- \SYS.$VOL.CAT1 was registered.
Registering catalog \SYS.$VOL.CAT2.
--- \SYS.$VOL.CAT2 was not registered.