SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

Figure 2 SQL/MX Metadata Table Structure
• 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 2 (page 108) shows the metadata schemas
and catalogs in the NONSTOP_SQLMX_nodename catalog.
• Typically, a node has additional user catalogs; Figure 2 (page 108) does not show these user
catalogs. A user catalog also contains a DEFINITION_SCHEMA_VERSION_3200 schema,
along with the tables shown in Figure 2 (page 108) for that schema. User catalogs do not
contain the other metadata schemas shown in Figure 2 (page 108).
• There is one set of statistics tables per schema. These are not shown in Figure 2 (page 108).
Figure 3 (page 109) 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 more information about
each metadata table, see the SQL/MX Reference Manual.
108 Querying SQL/MX Metadata