SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—523723-004
8-5
SQL/MX Metadata Tables
SQL/MX Metadata Tables
Figure 8-1 shows the SQL/MX metadata table structure.
Some important concepts to note are:
•
SQL/MX metadata tables are quite different from SQL/MP catalogs.
•
Each node contains a single NONSTOP_SQLMX_nodename catalog. This catalog
contains metadata pertinent to the node as a whole. Figure 8-1 shows the
metadata schemas and catalogs in the NONSTOP_SQLMX_nodename catalog.
•
Typically, a node has additional user catalogs; Figure 8-1 does not show these
user catalogs. A user catalog also contains a
DEFINITION_SCHEMA_VERSION_1200 schema, along with the tables shown in
Figure 8-1. SQL/MX Metadata Table Structure
vst003.vsd
NONSTOP_SQLMX_nodename
Catalog
SYSTEM_DEFAULTS_SCHEMA
SYSTEM_SQLJ_SCHEMA
ALL_UIDS
CATSYS
CAT_REFERENCES
SCHEMATA
SCHEMA_REPLICAS
Schemas
Tables
SYSTEM_SCHEMA
SYSTEM DEFAULTS
MXCS_SCHEMA
ASSOC2DS
DATASOURCES
ENVIRONMENTVALUES
NAME2ID
RESOURCEPOLICIES
DEFINITION_SCHEMA_VERSION_1200
ACCESS_PATHS
ACCESS_PATH_COLS
CK_COL_USAGE
CK_TBL_USAGE
COLS
COL_PRIVILEGES
DDL_LOCKS
DDL_PARTITION_LOCKS
KEY_COL_USAGE
MODULES
MP_PARTITIONS
MV_GROUPS
MVS
MVS_COLS
MVS_JOIN_COLS
MVS_TABLE_INFO
MVS_USED
OBJECTS
PARTITIONS
REF_CONSTRAINTS
REPLICAS
RI_UNIQUE_USAGE
ROUTINES
TBL_CONSTRAINTS
TBL_PRIVILEGES
TEXT
TRIGGERS
TRIGGERS_CAT_USAGE
TRIGGER_USED
VWS
VW_COL_TBLS
VW_COL_TBL_COLS
VW_COL_USAGE
VW_TBL_USAGE
Note: User catalogs
are not shown.