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

Managing an SQL/MX Distributed Database

HP NonStop SQL/MX Installation and Management Guide—523723-004

13-19

Creating a Distributed SQL/MX Database

nodes for all operations except the execution of statically compiled queries. This

configuration is not recommended.

Creating a Distributed SQL/MX Database

You create a distributed SQL/MX database by:

•

Creating, Registering, and Unregistering Catalog References on page 13-19

•

Distributing the SQL/MX Database Objects on page 13-19

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 the 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