TABSCHEMA |
VARCHAR(128) |
table_schema - Table schema name |
TABNAME |
VARCHAR(128) |
table_name - Table name |
MEMBER |
SMALLINT |
member- Database member |
TAB_TYPE |
VARCHAR(14) |
table_type - Table type |
TAB_FILE_ID |
BIGINT |
table_file_id - Table file ID |
DATA_PARTITION_ID |
INTEGER |
data_partition_id - Data partition
identifier |
TBSP_ID |
BIGINT |
tablespace_id - Table space identification |
INDEX_TBSP_ID |
BIGINT |
index_tbsp_id - Index table space ID |
LONG_TBSP_ID |
BIGINT |
long_tbsp_id - Long table space ID |
TABLE_SCANS |
BIGINT |
table_scans - Table scans |
ROWS_READ |
BIGINT |
rows_read - Rows read |
ROWS_INSERTED |
BIGINT |
rows_inserted - Rows inserted |
ROWS_UPDATED |
BIGINT |
rows_updated - Rows updated |
ROWS_DELETED |
BIGINT |
rows_deleted - Rows deleted |
OVERFLOW_ACCESSES |
BIGINT |
overflow_accesses - Accesses to overflowed
records |
OVERFLOW_CREATES |
BIGINT |
overflow_creates - Overflow creates |
PAGE_REORGS |
BIGINT |
page_reorgs - Page reorganizations
|
DATA_OBJECT_L_PAGES |
BIGINT |
data_object_l_pages - Logical data
object pages |
LOB_OBJECT_L_PAGES |
BIGINT |
lob_object_l_pages - Logical LOB object
pages |
LONG_OBJECT_L_PAGES |
BIGINT |
long_object_l_pages - Logical Long
object pages |
INDEX_OBJECT_L_PAGES |
BIGINT |
index_object_l_pages - Logical index
object pages |
XDA_OBJECT_L_PAGES |
BIGINT |
xda_object_l_pages - Logical XDA object
pages |
DBPARTITIONNUM |
SMALLINT |
dbpartitionnum - Database partition
number |
NO_CHANGE_UPDATES |
BIGINT |
no_change_updates - Number of no change
row updates |
LOCK_WAIT_TIME |
BIGINT |
lock_wait_time - Time waited on locks |
LOCK_WAIT_TIME_GLOBAL |
BIGINT |
lock_wait_time_global - Lock wait time
global |
LOCK_WAITS |
BIGINT |
lock_waits - Lock waits |
LOCK_WAITS_GLOBAL |
BIGINT |
lock_waits_global - Lock waits global |
LOCK_ESCALS |
BIGINT |
lock_escals - Number of lock escalations |
LOCK_ESCALS_GLOBAL |
BIGINT |
lock_escals_global - Number of global
lock escalations |
DATA_SHARING_STATE |
VARCHAR(19) |
data_sharing_state - Data sharing state
monitor element |
DATA_SHARING_STATE_CHANGE_TIME |
TIMESTAMP |
data_sharing_state_change_time - Data
sharing state change time monitor element |
DATA_SHARING_REMOTE_LOCKWAIT_COUNT |
BIGINT |
data_sharing_remote_lockwait_count
- Data sharing remote lock wait count monitor element |
DATA_SHARING_REMOTE_LOCKWAIT_TIME |
BIGINT |
data_sharing_remote_lockwait_time -
Data sharing remote lock wait time monitor element |
DIRECT_WRITES |
BIGINT |
direct_writes - Direct writes to database |
DIRECT_WRITE_REQS |
BIGINT |
direct_write_reqs - Direct write requests |
DIRECT_READS |
BIGINT |
direct_reads - Direct reads from database |
DIRECT_READ_REQS |
BIGINT |
direct_read_reqs - Direct read requests |
OBJECT_DATA_L_READS |
BIGINT |
object_data_l_reads - Buffer pool data
logical reads for a table |
OBJECT_DATA_P_READS |
BIGINT |
object_data_p_reads - Buffer pool data
physical reads for a table |
OBJECT_DATA_GBP_L_READS |
BIGINT |
object_data_gbp_l_reads - Group buffer
pool data logical reads for a table |
OBJECT_DATA_GBP_P_READS |
BIGINT |
object_data_gbp_p_reads - Group buffer
pool data physical reads for a table |
OBJECT_DATA_GBP_INVALID_PAGES |
BIGINT |
object_data_gbp_invalid_pages - Group
buffer pool invalid data pages for a table |
OBJECT_DATA_LBP_PAGES_FOUND |
BIGINT |
object_data_lbp_pages_found - Local
buffer pool found data pages for a table |
OBJECT_DATA_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
object_data_gbp_indep_pages_found_in_lbp
- Group buffer pool independent data pages found in local buffer pool |
OBJECT_XDA_L_READS |
BIGINT |
object_xda_l_reads - Buffer pool XDA
data logical reads for a table |
OBJECT_XDA_P_READS |
BIGINT |
object_xda_p_reads - Buffer pool XDA
data physical reads for a table |
OBJECT_XDA_GBP_L_READS |
BIGINT |
object_xda_gbp_l_reads - Group buffer
pool XDA data logical read requests for a table |
OBJECT_XDA_GBP_P_READS |
BIGINT |
object_xda_gbp_p_reads - Group buffer
pool XDA data physical read requests for a table |
OBJECT_XDA_GBP_INVALID_PAGES |
BIGINT |
object_xda_gbp_invalid_pages - Group
buffer pool invalid XDA data pages for a table |
OBJECT_XDA_LBP_PAGES_FOUND |
BIGINT |
object_xda_lbp_pages_found - Local
buffer pool XDA data pages found for a table |
OBJECT_XDA_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
object_xda_gbp_indep_pages_found_in_lbp
- Group buffer pool XDA independent pages found in local buffer pool |
NUM_PAGE_DICT_BUILT |
BIGINT |
num_page_dict_built - Number of page-level
compression dictionaries created or re-created |
STATS_ROWS_MODIFIED |
BIGINT |
stats_rows_modified - Rows modified
since last RUNSTATS |
RTS_ROWS_MODIFIED |
BIGINT |
rts_rows_modified - Rows modified since
last real time statistics |
COL_OBJECT_L_PAGES |
BIGINT |
col_object_l_pages - Column-organized
logical pages |
TAB_ORGANIZATION |
CHAR(1) |
tab_organization - Data organization
in table |
OBJECT_COL_L_READS |
BIGINT |
object_col_l_reads - Column-organized
logical reads |
OBJECT_COL_P_READS |
BIGINT |
object_col_p_reads - Column-organized
physical reads |
OBJECT_COL_GBP_L_READS |
BIGINT |
object_col_gbp_l_reads - Group buffer
pool column-organized logical reads |
OBJECT_COL_GBP_P_READS |
BIGINT |
object_col_gbp_p_reads - Group buffer
pool column-organized physical reads |
OBJECT_COL_GBP_INVALID_PAGES |
BIGINT |
object_col_gbp_invalid_pages - Group
buffer pool column-organized invalid data pages |
OBJECT_COL_LBP_PAGES_FOUND |
BIGINT |
object_col_lbp_pages_found - Local
buffer pool column-organized pages found |
OBJECT_COL_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
object_col_gbp_indep_pages_found_in_lbp
- Group buffer pool column-organized index pages found in local buffer
pool |
NUM_COLUMNS_REFERENCED |
BIGINT |
num_columns_referenced - Number of
columns referenced |
SECTION_EXEC_WITH_COL_REFERENCES |
BIGINT |
section_exec_with_col_references -
Section execution with column-organized references |
OBJECT_DATA_CACHING_TIER_L_READS |
BIGINT |
object_data_caching_tier_l_reads - Total logical reads
of data pages from the caching tier monitor element Note: This monitor element is currently only available for the Db2
Warehouse and Db2 Warehouse on Cloud products.
|
OBJECT_DATA_CACHING_TIER_PAGES_FOUND |
BIGINT |
object_data_caching_tier_pages_found - Table data pages
found in caching tier monitor element |
OBJECT_DATA_CACHING_TIER_GBP_INVALID_PAGES |
BIGINT |
Reserved for future use. |
OBJECT_DATA_CACHING_TIER_GBP_INDEP_PAGES_FOUND |
BIGINT |
Reserved for future use. |
OBJECT_XDA_CACHING_TIER_L_READS |
BIGINT |
object_xda_caching_tier_l_reads - Total logical reads
of XDA data pages from the caching tier monitor element Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
|
OBJECT_XDA_CACHING_TIER_PAGES_FOUND |
BIGINT |
object_xda_caching_tier_pages_found - Table XDA data
pages found in caching tier monitor element |
OBJECT_XDA_CACHING_TIER_GBP_INVALID_PAGES |
BIGINT |
Reserved for future use. |
OBJECT_XDA_CACHING_TIER_GBP_INDEP_PAGES_FOUND |
BIGINT |
Reserved for future use. |
OBJECT_COL_CACHING_TIER_L_READS |
BIGINT |
object_col_caching_tier_l_reads - Total logical reads
of column-organized pages from the caching tier monitor element
Note: This monitor element is currently only available for
the Db2 Warehouse and Db2 Warehouse on Cloud
products.
|
OBJECT_COL_CACHING_TIER_PAGES_FOUND |
BIGINT |
object_col_caching_tier_pages_found - Table
column-organized pages found in caching tier monitor element |
OBJECT_COL_CACHING_TIER_GBP_INVALID_PAGES |
BIGINT |
Reserved for future use. |
OBJECT_COL_CACHING_TIER_GBP_INDEP_PAGES_FOUND |
BIGINT |
Reserved for future use. |
EXT_TABLE_RECV_WAIT_TIME |
BIGINT |
ext_table_recv_wait_time - Total agent wait time for external table readers monitor element |
EXT_TABLE_RECVS_TOTAL |
BIGINT |
ext_table_recvs_total - Total row batches received from external table readers monitor element |
EXT_TABLE_RECV_VOLUME |
BIGINT |
ext_table_recv_volume - Total data received from external table readers monitor element |
EXT_TABLE_READ_VOLUME |
BIGINT |
ext_table_read_volume - Total data read by external table readers monitor element |
EXT_TABLE_SEND_WAIT_TIME |
BIGINT |
ext_table_send_wait_time - Total agent wait time for external table writers monitor element |
EXT_TABLE_SENDS_TOTAL |
BIGINT |
ext_table_sends_total - Total row batches sent to external table writers monitor element |
EXT_TABLE_SEND_VOLUME |
BIGINT |
ext_table_send_volume - Total data sent to external table writers monitor element |
EXT_TABLE_WRITE_VOLUME |
BIGINT |
ext_table_write_volume - Total data written by external table writers monitor element |
TENANT_ID |
BIGINT |
tenant_id - Tenant identifier monitor element
|
CACHING_TIER_DIRECT_READS |
BIGINT |
caching_tier_direct_reads - Direct reads from caching
tier monitor element Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud
products.
|
CACHING_TIER_DIRECT_READ_REQS |
BIGINT |
caching_tier_direct_read_reqs - Cache direct read
requests monitor element Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud
products.
|
CACHING_TIER_DIRECT_READ_TIME |
BIGINT |
caching_tier_direct_read_time - Cache direct read time
monitor element Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
|
CACHING_TIER_PAGE_READ_TIME |
BIGINT |
caching_tier_page_read_time - Cache page read time
monitor element Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
|