SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-3
SQL/MX Metadata Catalogs
SQL/MX Metadata Catalogs
There is one system catalog per node where NonStop SQL/MX has been initialized. It
is stored in NONSTOP_SQLMX_nodename on the Data Access Manager volume
specified as the system metadata volume during installation.There are five schemas in
the system catalog:
•
DEFINITION_SCHEMA_VERSION_vernum.
•
MXCS_SCHEMA
•
SYSTEM_DEFAULTS_SCHEMA
•
SYSTEM_SCHEMA
•
SYSTEM_SQLJ_SCHEMA
You can create as many user catalogs as you wish on a node. Each will contain a
DEFINITION_SCHEMA_VERSION_vernum schema.
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.
ALL_UIDS Table on page 10-7 UIDs for all objects that have metadata on node
CATSYS Table
on page 10-8 Catalogs visible from node
CAT_REFERENCES Table
on
page 10-8
Catalog replicas for catalogs visible from node
SCHEMATA Table
on page 10-9 Schemas that have definitions on node
SCHEMA_REPLICAS Table
on
page 10-9
Replicas for schemas with definitions on node
*In addition, UMD tables exist here.