SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-3
SQL/MX Metadata Schemas and Tables
SQL/MX Metadata Schemas and Tables
System Schema Tables: Schema SYSTEM_SCHEMA
System metadata to resolve object names is stored in schema SYSTEM_SCHEMA of
catalog NONSTOP_SQLMX_nodename on the Data Access Manager volume
specified as the system metadata volume during installation.
There is one system catalog per node where NonStop SQL/MX has been initialized.
This table lists system schema tables in
NONSTOP_SQLMX_nodename.SYSTEM_SCHEMA for each node*:
Definition Schema Tables: Schema
DEFINITION_SCHEMA_VERSION_vernum
Additional system metadata for each object is stored in schema
DEFINITION_SCHEMA_VERSION_
vernum in the catalog that contains the object.
NonStop SQL/MX automatically creates this schema and all its tables when you
execute the first CREATE SCHEMA statement for that catalog.
Within system metadata tables, each object or partition is identified by a unique ID
(UID). A UID is a 64-bit number, unique within the node, generated and assigned to the
object or partition at the time it is created.
Note. See the diagrammatic representation of the SQL/MX metadata tables in the SQL/MX
Installation and Management Guide that is applicable for SQL/MX R 3.0.
1
ALL_UIDS Table on page 10-8 UIDs for all objects that have metadata on node
CATSYS Table
on page 10-9 Catalogs visible from node
CAT_REFERENCES Table
on
page 10-9
Catalog replicas for catalogs visible from node
2
SCHEMATA Table on
page 10-10
Schemas that have definitions on node
SCHEMA_REPLICAS Table
on
page 10-11
Replicas for schemas with definitions on node
*In addition, UMD tables exist here.
1. The ALL_UIDS table is present in schema version 1200 only.
2. The SCHEMATA table is updated in SQL/MX R 3.0.