SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—640325-001
8-6
SQL/MX Metadata Tables
•
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_3000 schema, along with the tables shown in
Figure 8-1 for that schema. User catalogs do not contain the other metadata
schemas shown in Figure 8-1.
•
There is one set of statistics tables per schema. These are not shown in
Figure 8-1.
Figure 8-2 lists the SQL/MX metadata tables located in the system catalog, including
the primary keys for each table.
Use this table as a reference for the examples later in this section. For detailed
information about each metadata table, see the SQL/MX Reference Manual.