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-7
SQL/MX Metadata Tables
Figure 8-2. SQL/MX Metadata Tables (page 1 of 3)
VST005.vsd
CATSYS
PK CAT_NAME
CAT_UID
REPLICATION_RULE
LOCAL_SMD_VOLUME
LOCAL_USER_SCHEMA_COUNT
CAT_OWNER
CAT_REFERENCES
PK CAT_UID
PK NODE_NAME
SMD_VOLUME
REPLICATION_RULE
SCHEMATA
PK CAT_UID
PK SCHEMA_NAME
SCHEMA_UID
SCHEMA_OWNER
SCHEMA_VERSION
SCHEMA_SUBVOLUME
CURRENT_OPERATION
SOURCE_VERSION
TARGET_VERSION
SCHEMA_REPLICAS
PK SCHEMA_UID
PK NODE_NAME
SYSTEM_SCHEMA
User Metadata Tables
HISTOGRAMS
PK TABLE_UID
PK HISTOGRAM_ID
PK COL_POSITION
COLUMN_NUMBER
COLCOUNT
INTERVAL_COUNT
ROWCOUNT
TOTAL_UEC
STATS_TIME
LOW_VALUE
HIGH_VALUE
READ_TIME
READ_COUNT
SAMPLE_SECS
COL_SECS
SAMPLE_PERCENT
CV
REASON
V1
V2
V3
V4
V5
V6
HISTOGRAM_INTERVALS
PK TABLE_UID
PK HISTOGRAM_ID
PK INTERVAL_NUMBER
INTERVAL_ROWCOUNT
INTERVAL_UEC
INTERVAL_BOUNDARY
STD_DEV_OF_FREQ
V1
V2
V3
V4
V5
V6
MXCS_SCHEMA
ASSOC2DS
PK ASSOC_ID
PK DS_ID
AUTOMATION
CURRENT_STATUS
DEFAULT_TYPE
LAST_STATUS_CHANGE
LAST_UPDATED
DATASOURCES
PK DS_ID
MAX_SRVR_CNT
AVAIL_SRVR_CNT
INIT_SRVR_CNT
START_AHEAD
SRVR_IDLE_TIMEOUT
CONN_IDLE_TIMEOUT
REFRESH_RATE
LAST_UPDATED
ENVIRONMENTVALUES
PK ENV_ID
PK VARIABLE_SEQUENCE
PK VARIABLE_TYPE
VARIABLE_VALUE
LAST_UPDATED
NAME2ID
PK OBJ_ID
OBJ_TYPE
OBJ_NAME
VARIABLE_VALUE
LAST_UPDATED
RESOURCEPOLICIES
PK RES_ID
ATTRIBUTE_NAME
LIMIT_VALUE
ACTION_ID
SETTABLE
LAST_UPDATED
SYSTEM_DEFAULTS_SCHEMA
SYSTEM_DEFAULTS
PK SUBSYSTEM
PK ATTRIBUTE
ATTR_VALUE
ATTR_COMMENT
* This schema also contains the
User Metadata Tables.
SYSTEM_SQLJ_SCHEMA
* This schema only contains the stored
procedure named VALIDATEROUTINE.
* This schema also contains the
User Metadata Tables.
* This schema also contains the
User Metadata Tables.
SYSTEM_SECURITY_SCHEMA
* The tables and attributes of this schema
are described later.