SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—544536-007
8-7
SQL/MX Metadata Tables
Figure 8-2. SQL/MX Metadata Tables (page 1 of 4)
VST005.vsd
ALL_UIDS
PK OBJECT_UID
SCHEMA_UID
OBJECT_NAME
OBJECT_NAME_SPACE
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
HISTOGRAM_INTERVALS
PK TABLE_UID
PK HISTOGRAM_ID
PK INTERVAL_NUMBER
INTERVAL_ROWCOUNT
INTERVAL_UEC
INTERVAL_BOUNDARY
MVS_TABLE_INFO_UMD
PK BT_UID
LAST_DE_EPOCH
RECOMPUTE_EPOCH
IS_LAST_DE_COMPLETE
MIN_EPOCH
MVS_UMD
PK MV_UID
RECOMPUTE_DUR
REFRESH_DUR_1
REFRESH_DUR_2
REFRESH_DUR_3
REFRESH_DUR_N
MVS_USED_UMD
PK MV_UID
PK BT_UID
EPOCH
REFRESH_DUR
DELTA_SIZE
STAT_1
STAT_2
MULTI_TXN_TARGET_EPOCH
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
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.