SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)
HP NonStop SQL/MX Installation and Management Guide—523723-004
13-1
13
Managing an SQL/MX Distributed
Database
SQL/MX databases can be distributed over disk volumes on a single system (node) or
in a network of nodes. Likewise, application programs that access NonStop SQL/MX
can be distributed across processors in a single node or in a network.
When managing a database distributed across volumes or nodes, you can usually use
the same SQL statements you would use with a nondistributed database. The major
exceptions are statements used only in distributed environments (REGISTER
CATALOG) and statements whose syntax is influenced by distribution (for example, the
LOCATION clause in CREATE TABLE). When accessing a distributed SQLMX object,
some SQL/MX statements allow you to use distinct file names or partition names that
refer to individual partitions of the object. For most statements, however, an object
name refers to the entire object rather than to the individual partition.
The distribution issues discussed in this section are divided into the general areas of
locally distributed databases (distributed over two or more disk volumes on the same
node) and network-distributed databases.
This section addresses these topics:
•
Managing a Locally Distributed SQL/MX Database on page 13-1
•
Managing a Network-Distributed SQL/MX Database on page 13-2
•
Creating a Distributed SQL/MX Database on page 13-19
•
Altering Distributed Objects on page 13-21
•
Dropping Distributed Objects on page 13-22
•
Enhancing Performance for a Distributed Database on page 13-22
•
Changing Network Environments on page 13-23
•
Managing Mixed Releases of NonStop SQL/MX on page 13-25
For information about managing an SQL/MP distributed database, see the SQL/MP
Installation and Management Guide.
Managing a Locally Distributed SQL/MX
Database
An SQL/MX database is locally distributed if tables or indexes are partitioned over two
or more disk volumes on one node. The goals for managing a locally distributed
database are: