SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
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 in
the system catalog NONSTOP_SQLMX_nodename.
There is one system catalog per node where NonStop SQL/MX has been initialized.
This table lists the metadata tables in the system schema:
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 catalog, schema or object is identified by a
unique ID (UID). A UID is a 64-bit number generated and assigned to the catalog,
schema, or object at the time of creation. A catalog UID is unique within the set of
nodes where that catalog is visible. A schema UID is unique among the set of schemas
in the same catalog. An object UID is unique among the set of objects in the same
catalog.
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 Release 3.2.
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 reference information for catalogs visible from
node
SCHEMATA Table
on
page 10-10
Schemas in catalog visible from node
SCHEMA_REPLICAS Table
on
page 10-11
Replica information for schemas with definitions on node
1. The ALL_UIDS table is present in version 1200 system schema only.