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-7
SQL/MX Metadata Tables
SYSTEM_SQLJ
_SCHEMA
None None
MXCS_SCHEMA ASSOC2DS ASSOC_ID
DS_ID
AUTOMATION
CURRENT_STATUS
DEFAULT_TYPE
LAST_STATUS_CHANGE
LAST_UPDATED
DATASOURCES DS_ID
MAX_SRVR_CNT
AVAIL_SRVR_CNT
INIT_SRVR_CNT
START_AHEAD
SRVR_IDLE_TIMEOUT
CONN_IDLE_TIMEOUT
REFRESH_RATE
LAST_UPDATED
ENVIRONMENTVALUES ENV_ID
VARIABLE_SEQUENCE
VARIABLE_TYPE
VARIABLE_VALUE
LAST_UPDATED
NAME2ID OBJ_ID
OBJ_TYPE
OBJ_NAME
LAST_UPDATED
RESOURCEPOLICIES RES_ID
ATTRIBUTE_NAME
LIMIT_VALUE
ACTION_ID
SETTABLE
LAST_UPDATED
User Metadata
Tables
HISTOGRAMS TABLE_UID
HISTOGRAM_ID
COL_POSITION
COLUMN_NUMBER
COLCOUNT
INTERVAL_COUNT
ROWCOUNT
TOTAL_UEC
STATS_TIME
LOW_VALUE
HIGH_VALUE
Table 8-1. SQL/MX Metadata Tables (page 2 of 8)
Schema Table Columns (Clustering Keys in Bold)