SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Managing an SQL/MX Distributed Database

HP NonStop SQL/MX Installation and Management Guide—544536-007

13-20

Creating, Registering, and Unregistering Catalog

References

•

Distributing SQL/MX Database Objects on page 13-20

For instructions on creating a distributed SQL/MP database, see the SQL/MP

Installation and Management Guide.

Creating, Registering, and Unregistering Catalog References

After a catalog has been created on the local node, use the REGISTER CATALOG

command to register the empty catalog reference on remote nodes and the

UNREGISTER CATALOG to remove an empty catalog reference from a node.

Example—Creating a Catalog

The CREATE CATALOG statement creates a new catalog on the designated node:

CREATE CATALOG samdbcat LOCATION \nodex.$data47;

Example—Registering a Catalog on a Remote Node

The REGISTER CATALOG command causes a catalog, which is visible on the local

node, to be registered on a remote node. It creates an empty catalog reference on the

target node, and the automatic catalog reference is updated to reflect that.

Example—Unregistering a Catalog From a Node

The UNREGISTER CATALOG command causes an empty catalog reference to be

removed from the specified node. As a result, the catalog is no longer visible on that

node.

UNREGISTER CATALOG samdbcat FROM \nodey.$data47;

Distributing SQL/MX Database Objects

SQL/MX objects can be distributed individually or distributed as partitions of tables or

indexes.

Objects can be distributed at creation time by the CREATE statement or at a later time

by using the MODIFY utility. You use the GRANT command to assign access privileges

for objects to specified users. These access privileges extend to remote nodes

provided the users have remote network access to those nodes.

You can use the LOCATION clause in a DDL statement to specify different nodes or

disks on which to create an object.