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-10
Using Catalog References in an SQL/MX Distributed
Database
•
The CATSYS table on \N1 contains one row for the catalog CAT1, including these
entries in the CAT_NAME and REPLICATION_RULE columns.
•
The SCHEMATA table on \N1 contains one row for each CAT1 schema, including
these entries in the SCHEMA_NAME column:
•
The CAT_REFERENCES table on \N1 contains three rows for the catalog CAT1,
one for the automatic catalog reference node and one for each empty manual
reference node. This includes these entries in the CAT_UID, NODE_NAME, and
REPLICATION_RULE columns:
CAT_UID contains the 17-digit UID for each catalog.
•
The SCHEMA_REPLICAS table on \N1 contains two rows for CAT1, one for each
of its two schemas. This includes these entries in the SCHEMA_UID and
NODE_NAME columns:
SCHEMA_UID contains the 17-digit UID for each schema.
System Schema Tables on Nodes \N2 and \N3
Nodes \N2 and \N3 each has an empty catalog reference for catalog CAT1. The
system schema tables on each of these nodes contain this information:
•
The CATSYS table on \N2 and \N3 contains one row for the catalog CAT1,
including these entries in the CAT_NAME and REPLICATION_RULE columns:
•
The SCHEMATA table on \N2 and \N3 contains the same information about CAT1
in its schemas that \N1 does.
CAT_NAME REPLICATION_RULE
CAT1 A (for automatic replication)
SCHEMA_NAME
SCH1
SCH2
CAT_UID NODE_NAME REPLICATION_RULE
12345678912345678 \N1 A
12345678912345678 \N2 M (for manual replication)
12345678912345678 \N3 M
SCHEMA_UID NODE_NAME
12345678912345678 \N1
23456789123456789 \N1
CAT_NAME REPLICATION_RULE
CAT1 M