SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-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_3100 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.