SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
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*:
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
SCHEMATA Table
on
page 10-10
Schemas that have definitions on node
SCHEMA_REPLICAS Table
on
page 10-10
Replicas for schemas with definitions on node
*In addition, UMD tables exist here.