PARTITION_KEY |
INTEGER |
partition_key - Partitioning key monitor element |
APPLICATION_ID |
VARCHAR(128) |
appl_id - Application ID monitor element |
MEMBER |
SMALLINT |
member - Database
member |
UOW_ID |
INTEGER |
uow_id - Unit of
work ID |
WLM_QUEUE_TIME_TOTAL |
BIGINT |
wlm_queue_time_total
- Workload manager total queue time |
WLM_QUEUE_ASSIGNMENTS_TOTAL |
BIGINT |
wlm_queue_assignments_total
- Workload manager total queue assignments |
FCM_TQ_RECV_WAIT_TIME |
BIGINT |
fcm_tq_recv_wait_time
- FCM table queue received wait time |
FCM_MESSAGE_RECV_WAIT_TIME |
BIGINT |
fcm_message_recv_wait_time
- FCM message received wait time |
FCM_TQ_SEND_WAIT_TIME |
BIGINT |
fcm_tq_send_wait_time
- FCM table queue send wait time |
FCM_MESSAGE_SEND_WAIT_TIME |
BIGINT |
fcm_message_send_wait_time
- FCM message send wait time |
AGENT_WAIT_TIME |
BIGINT |
agent_wait_time -
Agent wait time |
AGENT_WAITS_TOTAL |
BIGINT |
agent_waits_total
- Total agent waits |
LOCK_WAIT_TIME |
BIGINT |
lock_wait_time -
Time waited on locks |
LOCK_WAITS |
BIGINT |
lock_waits - Lock
waits |
DIRECT_READ_TIME |
BIGINT |
direct_read_time
- Direct read time |
DIRECT_READ_REQS |
BIGINT |
direct_read_reqs
- Direct read requests |
DIRECT_WRITE_TIME |
BIGINT |
direct_write_time
- Direct write time |
DIRECT_WRITE_REQS |
BIGINT |
direct_write_reqs
- Direct write requests |
LOG_BUFFER_WAIT_TIME |
BIGINT |
log_buffer_wait_time
- Log buffer wait time |
NUM_LOG_BUFFER_FULL |
BIGINT |
num_log_buffer_full
- Number of full log buffers |
LOG_DISK_WAIT_TIME |
BIGINT |
log_disk_wait_time
- Log disk wait time |
LOG_DISK_WAITS_TOTAL |
BIGINT |
log_disk_waits_total
- Total log disk waits |
TCPIP_RECV_WAIT_TIME |
BIGINT |
tcpip_recv_wait_time
- TCP/IP received wait time |
TCPIP_RECVS_TOTAL |
BIGINT |
tcpip_recvs_total
- TCP/IP receives total |
CLIENT_IDLE_WAIT_TIME |
BIGINT |
client_idle_wait_time
- Client idle wait time |
IPC_RECV_WAIT_TIME |
BIGINT |
ipc_recv_wait_time
- Interprocess communication received wait time |
IPC_RECVS_TOTAL |
BIGINT |
ipc_recvs_total -
Interprocess communication receives total |
IPC_SEND_WAIT_TIME |
BIGINT |
ipc_send_wait_time
- Interprocess communication send wait time |
IPC_SENDS_TOTAL |
BIGINT |
ipc_sends_total -
Interprocess communication send total |
TCPIP_SEND_WAIT_TIME |
BIGINT |
tcpip_send_wait_time
- TCP/IP send wait time |
TCPIP_SENDS_TOTAL |
BIGINT |
tcpip_sends_total
- TCP/IP sends total |
POOL_WRITE_TIME |
BIGINT |
pool_write_time -
Total buffer pool physical write time |
POOL_READ_TIME |
BIGINT |
pool_read_time -
Total buffer pool physical read time |
AUDIT_FILE_WRITE_WAIT_TIME |
BIGINT |
audit_file_write_wait_time
- Audit file write wait time |
AUDIT_FILE_WRITES_TOTAL |
BIGINT |
audit_file_writes_total
- Total audit files written |
AUDIT_SUBSYSTEM_WAIT_TIME |
BIGINT |
audit_subsystem_wait_time
- Audit subsystem wait time |
AUDIT_SUBSYSTEM_WAITS_TOTAL |
BIGINT |
audit_subsystem_waits_total
- Total audit subsystem waits |
DIAGLOG_WRITE_WAIT_TIME |
BIGINT |
diaglog_write_wait_time
- Diagnostic log file write wait time |
DIAGLOG_WRITES_TOTAL |
BIGINT |
diaglog_writes_total
- Total diagnostic log file writes |
FCM_SEND_WAIT_TIME |
BIGINT |
fcm_send_wait_time
- FCM send wait time |
FCM_RECV_WAIT_TIME |
BIGINT |
fcm_recv_wait_time
- FCM received wait time |
TOTAL_WAIT_TIME |
BIGINT |
total_wait_time -
Total wait time |
RQSTS_COMPLETED_TOTAL |
BIGINT |
rqsts_completed_total
- Total requests completed |
TOTAL_RQST_TIME |
BIGINT |
total_rqst_time -
Total request time |
APP_RQSTS_COMPLETED_TOTAL |
BIGINT |
app_rqsts_completed_total
- Total application requests completed |
TOTAL_APP_RQST_TIME |
BIGINT |
total_app_rqst_time
- Total application request time |
TOTAL_SECTION_SORT_PROC_TIME |
BIGINT |
total_section_sort_proc_time
- Total section sort processing time |
TOTAL_SECTION_SORTS |
BIGINT |
total_section_sorts
- Total section sorts |
TOTAL_SECTION_SORT_TIME |
BIGINT |
total_section_sort_time
- Total section sort time |
ROWS_READ |
BIGINT |
rows_read - Rows
read |
ROWS_MODIFIED |
BIGINT |
rows_modified - Rows
modified |
POOL_DATA_L_READS |
BIGINT |
pool_data_l_reads
- Buffer pool data logical reads |
POOL_INDEX_L_READS |
BIGINT |
pool_index_l_reads
- Buffer pool index logical reads |
POOL_TEMP_DATA_L_READS |
BIGINT |
pool_temp_data_l_reads
- Buffer pool temporary data logical reads |
POOL_TEMP_INDEX_L_READS |
BIGINT |
pool_temp_index_l_reads
- Buffer pool temporary index logical reads |
POOL_XDA_L_READS |
BIGINT |
pool_xda_l_reads
- Buffer pool XDA data logical reads |
POOL_TEMP_XDA_L_READS |
BIGINT |
pool_temp_xda_l_reads
- Buffer pool temporary XDA data logical reads |
TOTAL_CPU_TIME |
BIGINT |
total_cpu_time -
Total CPU time |
ACT_COMPLETED_TOTAL |
BIGINT |
act_completed_total
- Total completed activities |
POOL_DATA_P_READS |
BIGINT |
pool_data_p_reads
- Buffer pool data physical reads |
POOL_TEMP_DATA_P_READS |
BIGINT |
pool_temp_data_p_reads
- Buffer pool temporary data physical reads |
POOL_XDA_P_READS |
BIGINT |
pool_xda_p_reads
- Buffer pool XDA data physical reads |
POOL_TEMP_XDA_P_READS |
BIGINT |
pool_temp_xda_p_reads
- Buffer pool temporary XDA data physical reads |
POOL_INDEX_P_READS |
BIGINT |
pool_index_p_reads
- Buffer pool index physical reads |
POOL_TEMP_INDEX_P_READS |
BIGINT |
pool_temp_index_p_reads
- Buffer pool temporary index physical reads |
POOL_DATA_WRITES |
BIGINT |
pool_data_writes
- Buffer pool data writes |
POOL_XDA_WRITES |
BIGINT |
pool_xda_writes -
Buffer pool XDA data writes |
POOL_INDEX_WRITES |
BIGINT |
pool_index_writes
- Buffer pool index writes |
DIRECT_READS |
BIGINT |
direct_reads - Direct
reads from database |
DIRECT_WRITES |
BIGINT |
direct_writes - Direct
writes to database |
ROWS_RETURNED |
BIGINT |
rows_returned - Rows
returned |
DEADLOCKS |
BIGINT |
deadlocks - Deadlocks
detected |
LOCK_TIMEOUTS |
BIGINT |
lock_timeouts - Number
of lock timeouts |
LOCK_ESCALS |
BIGINT |
lock_escals - Number
of lock escalations |
FCM_SENDS_TOTAL |
BIGINT |
fcm_sends_total -
FCM sends total |
FCM_RECVS_TOTAL |
BIGINT |
fcm_recvs_total -
FCM receives total |
FCM_SEND_VOLUME |
BIGINT |
fcm_send_volume -
FCM send volume |
FCM_RECV_VOLUME |
BIGINT |
fcm_recv_volume -
FCM received volume |
FCM_MESSAGE_SENDS_TOTAL |
BIGINT |
fcm_message_sends_total
- Total FCM message sends |
FCM_MESSAGE_RECVS_TOTAL |
BIGINT |
fcm_message_recvs_total
- Total FCM message receives |
FCM_MESSAGE_SEND_VOLUME |
BIGINT |
fcm_message_send_volume
- FCM message send volume |
FCM_MESSAGE_RECV_VOLUME |
BIGINT |
fcm_message_recv_volume
- FCM message received volume |
FCM_TQ_SENDS_TOTAL |
BIGINT |
fcm_tq_sends_total
- FCM table queue send total |
FCM_TQ_RECVS_TOTAL |
BIGINT |
fcm_tq_recvs_total
- FCM table queue receives total |
FCM_TQ_SEND_VOLUME |
BIGINT |
fcm_tq_send_volume
- FCM table queue send volume |
FCM_TQ_RECV_VOLUME |
BIGINT |
fcm_tq_recv_volume
- FCM table queue received volume |
TQ_TOT_SEND_SPILLS |
BIGINT |
tq_tot_send_spills
- Total number of table queue buffers overflowed |
TCPIP_SEND_VOLUME |
BIGINT |
tcpip_send_volume
- TCP/IP send volume |
TCPIP_RECV_VOLUME |
BIGINT |
tcpip_recv_volume
- TCP/IP received volume |
IPC_SEND_VOLUME |
BIGINT |
ipc_send_volume -
Interprocess communication send volume |
IPC_RECV_VOLUME |
BIGINT |
ipc_recv_volume -
Interprocess communication received volume |
POST_THRESHOLD_SORTS |
BIGINT |
post_threshold_sorts
- Post threshold sorts |
POST_SHRTHRESHOLD_SORTS |
BIGINT |
post_shrthreshold_sorts
- Post shared threshold sorts |
SORT_OVERFLOWS |
BIGINT |
sort_overflows -
Sort overflows |
AUDIT_EVENTS_TOTAL |
BIGINT |
audit_events_total
- Total audit events |
ACT_REJECTED_TOTAL |
BIGINT |
act_rejected_total
- Total rejected activities |
ACT_ABORTED_TOTAL |
BIGINT |
act_aborted_total
- Total aborted activities |
TOTAL_SORTS |
BIGINT |
total_sorts - Total
sorts |
TOTAL_ROUTINE_TIME |
BIGINT |
total_routine_time
- Total routine time |
TOTAL_COMPILE_PROC_TIME |
BIGINT |
total_compile_proc_time
- Total compile processing time |
TOTAL_COMPILATIONS |
BIGINT |
total_compilations
- Total compilations |
TOTAL_COMPILE_TIME |
BIGINT |
total_compile_time
- Total compile time |
TOTAL_IMPLICIT_COMPILATIONS |
BIGINT |
total_implicit_compilations
- Total implicit complications |
TOTAL_IMPLICIT_COMPILE_TIME |
BIGINT |
total_implicit_compile_time
- Total implicit compile time |
TOTAL_RUNSTATS_PROC_TIME |
BIGINT |
total_runstats_proc_time
- Total runtime statistics processing time |
TOTAL_RUNSTATS |
BIGINT |
total_runstats -
Total runtime statistics |
TOTAL_RUNSTATS_TIME |
BIGINT |
total_runstats_time
- Total runtime statistics time |
TOTAL_REORG_PROC_TIME |
BIGINT |
total_reorg_proc_time
- Total reorganization processing time |
TOTAL_REORGS |
BIGINT |
total_reorgs - Total
reorganizations |
TOTAL_REORG_TIME |
BIGINT |
total_reorg_time
- Total reorganization time |
TOTAL_LOAD_PROC_TIME |
BIGINT |
total_load_proc_time
- Total load processing time |
TOTAL_LOADS |
BIGINT |
total_loads - Total
loads |
TOTAL_LOAD_TIME |
BIGINT |
total_load_time -
Total load time |
TOTAL_SECTION_PROC_TIME |
BIGINT |
total_section_proc_time
- Total section processing time |
TOTAL_APP_SECTION_EXECUTIONS |
BIGINT |
total_app_section_executions
- Total application section executions |
TOTAL_SECTION_TIME |
BIGINT |
total_section_time
- Total section time |
TOTAL_COMMIT_PROC_TIME |
BIGINT |
total_commit_proc_time
- Total commits processing time |
TOTAL_APP_COMMITS |
BIGINT |
total_app_commits
- Total application commits |
TOTAL_COMMIT_TIME |
BIGINT |
total_commit_time
- Total commit time |
TOTAL_ROLLBACK_PROC_TIME |
BIGINT |
total_rollback_proc_time
- Total rollback processing time |
TOTAL_APP_ROLLBACKS |
BIGINT |
total_app_rollbacks
- Total application rollbacks |
TOTAL_ROLLBACK_TIME |
BIGINT |
total_rollback_time
- Total rollback time |
TOTAL_ROUTINE_USER_CODE_TIME |
BIGINT |
total_routine_user_code_time
- Total routine user code time |
THRESH_VIOLATIONS |
BIGINT |
thresh_violations
- Number of threshold violations |
NUM_LW_THRESH_EXCEEDED |
BIGINT |
num_lw_thresh_exceeded
- Number of lock wait thresholds exceeded |
TOTAL_ROUTINE_INVOCATIONS |
BIGINT |
total_routine_invocations
- Total routine invocations |
INT_COMMITS |
BIGINT |
int_commits - Internal
commits |
INT_ROLLBACKS |
BIGINT |
int_rollbacks - Internal
rollbacks |
CAT_CACHE_INSERTS |
BIGINT |
cat_cache_inserts
- Catalog cache inserts |
CAT_CACHE_LOOKUPS |
BIGINT |
cat_cache_lookups
- Catalog cache lookups |
PKG_CACHE_INSERTS |
BIGINT |
pkg_cache_inserts
- Package cache inserts |
PKG_CACHE_LOOKUPS |
BIGINT |
pkg_cache_lookups
- Package cache lookups |
ACT_RQSTS_TOTAL |
BIGINT |
act_rqsts_total -
Total activity requests |
TOTAL_ACT_WAIT_TIME |
BIGINT |
total_act_wait_time
- Total activity wait time |
TOTAL_ACT_TIME |
BIGINT |
total_act_time -
Total activity time |
LOCK_WAIT_TIME_GLOBAL |
BIGINT |
lock_wait_time_global
- Lock wait time global |
LOCK_WAITS_GLOBAL |
BIGINT |
lock_waits_global
- Lock waits global |
RECLAIM_WAIT_TIME |
BIGINT |
reclaim_wait_time
- Reclaim wait time |
SPACEMAPPAGE_RECLAIM_WAIT_TIME |
BIGINT |
spacemappage_reclaim_wait_time
- Space map page reclaim wait time |
LOCK_TIMEOUTS_GLOBAL |
BIGINT |
lock_timeouts_global
- Lock timeouts global |
LOCK_ESCALS_MAXLOCKS |
BIGINT |
lock_escals_maxlocks
- Number of maxlocks lock escalations |
LOCK_ESCALS_LOCKLIST |
BIGINT |
lock_escals_locklist
- Number of locklist lock escalations |
LOCK_ESCALS_GLOBAL |
BIGINT |
lock_escals_global
- Number of global lock escalations |
CF_WAIT_TIME |
BIGINT |
cf_wait_time - cluster
caching facility wait time |
CF_WAITS |
BIGINT |
cf_waits - Number
of cluster caching facility DB2 pureScale
server waits |
POOL_DATA_GBP_L_READS |
BIGINT |
pool_data_gbp_l_reads
- Group buffer pool data logical reads |
POOL_DATA_GBP_P_READS |
BIGINT |
pool_data_gbp_p_reads
- Group buffer pool data physical reads |
POOL_DATA_LBP_PAGES_FOUND |
BIGINT |
pool_data_lbp_pages_found
- Local buffer pool found data pages |
POOL_DATA_GBP_INVALID_PAGES |
BIGINT |
pool_data_gbp_invalid_pages
- Group buffer pool invalid data pages |
POOL_INDEX_GBP_L_READS |
BIGINT |
pool_index_gbp_l_reads
- Group buffer pool index logical reads |
POOL_INDEX_GBP_P_READS |
BIGINT |
pool_index_gbp_p_reads
- Group buffer pool index physical reads |
POOL_INDEX_LBP_PAGES_FOUND |
BIGINT |
pool_index_lbp_pages_found
- Local buffer pool index pages found |
POOL_INDEX_GBP_INVALID_PAGES |
BIGINT |
pool_index_gbp_invalid_pages
- Group buffer pool invalid index pages |
POOL_XDA_GBP_L_READS |
BIGINT |
pool_xda_gbp_l_reads
- Group buffer pool XDA data logical read requests |
POOL_XDA_GBP_P_READS |
BIGINT |
pool_xda_gbp_p_reads
- Group buffer pool XDA data physical read requests |
POOL_XDA_LBP_PAGES_FOUND |
BIGINT |
pool_xda_lbp_pages_found
- Local buffer pool XDA data pages found |
POOL_XDA_GBP_INVALID_PAGES |
BIGINT |
pool_xda_gbp_invalid_pages
- Group buffer pool invalid XDA data pages |
EVMON_WAIT_TIME |
BIGINT |
evmon_wait_time -
Event monitor wait time |
EVMON_WAITS_TOTAL |
BIGINT |
evmon_waits_total
- Event monitor total waits |
TOTAL_EXTENDED_LATCH_WAIT_TIME |
BIGINT |
total_extended_latch_wait_time
- Total extended latch wait time |
TOTAL_EXTENDED_LATCH_WAITS |
BIGINT |
total_extended_latch_waits
- Total extended latch waits |
TOTAL_STATS_FABRICATIONS |
BIGINT |
total_stats_fabrications
- Total statistics fabrications |
TOTAL_STATS_FABRICATION_TIME |
BIGINT |
total_stats_fabrication_time
- Total statistics fabrication time |
TOTAL_SYNC_RUNSTATS_PROC_TIME |
BIGINT |
total_sync_runstats_proc_time
- Total synchronous RUNSTATS processing time |
TOTAL_SYNC_RUNSTATS |
BIGINT |
total_sync_runstats
- Total synchronous RUNSTATS activities |
TOTAL_SYNC_RUNSTATS_TIME |
BIGINT |
total_sync_runstats_time
- Total synchronous RUNSTATS time |
TOTAL_DISP_RUN_QUEUE_TIME |
BIGINT |
total_disp_run_queue_time
- Total dispatcher run queue time |
POOL_QUEUED_ASYNC_DATA_REQS |
BIGINT |
pool_queued_async_data_reqs
- Data prefetch requests |
POOL_QUEUED_ASYNC_INDEX_REQS |
BIGINT |
pool_queued_async_index_reqs
- Index prefetch requests |
POOL_QUEUED_ASYNC_XDA_REQS |
BIGINT |
pool_queued_async_xda_reqs
- XDA prefetch requests |
POOL_QUEUED_ASYNC_OTHER_REQS |
BIGINT |
pool_queued_async_other_reqs
- Non-prefetch requests |
POOL_QUEUED_ASYNC_DATA_PAGES |
BIGINT |
pool_queued_async_data_pages
- Data pages prefetch requests |
POOL_QUEUED_ASYNC_INDEX_PAGES |
BIGINT |
pool_queued_async_index_pages
- Index pages prefetch requests |
POOL_QUEUED_ASYNC_XDA_PAGES |
BIGINT |
pool_queued_async_xda_pages
- XDA pages prefetch requests |
POOL_FAILED_ASYNC_DATA_REQS |
BIGINT |
pool_failed_async_data_reqs
- Failed data prefetch requests |
POOL_FAILED_ASYNC_INDEX_REQS |
BIGINT |
pool_failed_async_index_reqs
- Failed index prefetch requests |
POOL_FAILED_ASYNC_XDA_REQS |
BIGINT |
pool_failed_async_xda_reqs
- Failed XDA prefetch requests |
POOL_FAILED_ASYNC_OTHER_REQS |
BIGINT |
pool_failed_async_other_reqs
- Failed non-prefetch requests |
APP_ACT_COMPLETED_TOTAL |
BIGINT |
app_act_completed_total
- Total successful external coordinator activities |
APP_ACT_ABORTED_TOTAL |
BIGINT |
app_act_aborted_total
- Total failed external coordinator activities |
APP_ACT_REJECTED_TOTAL |
BIGINT |
app_act_rejected_total
- Total rejected external coordinator activities |
TOTAL_PEDS |
BIGINT |
total_peds - Total
partial early distincts |
DISABLED_PEDS |
BIGINT |
disabled_peds - Disabled partial early distincts monitor element |
POST_THRESHOLD_PEDS |
BIGINT |
post_threshold_peds
- Partial early distincts threshold |
TOTAL_PEAS |
BIGINT |
total_peas - Total
partial early aggregations |
POST_THRESHOLD_PEAS |
BIGINT |
post_threshold_peas
- Partial early aggregation threshold |
TQ_SORT_HEAP_REQUESTS |
BIGINT |
tq_sort_heap_requests
- Table queue sort heap requests |
TQ_SORT_HEAP_REJECTIONS |
BIGINT |
tq_sort_heap_rejections
- Table queue sort heap rejections |
TOTAL_CONNECT_REQUESTS |
BIGINT |
total_connect_requests
- Connection or switch user requests |
TOTAL_CONNECT_REQUEST_TIME |
BIGINT |
total_connect_request_time
- Total connection or switch user request time |
TOTAL_CONNECT_AUTHENTICATIONS |
BIGINT |
total_connect_authentications
- Connections or switch user authentications performed |
PREFETCH_WAIT_TIME |
BIGINT |
prefetch_wait_time
- Time waited for prefetch |
PREFETCH_WAITS |
BIGINT |
prefetch_waits -
Prefetcher wait count |
POOL_DATA_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor element |
POOL_INDEX_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor element |
POOL_XDA_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor element |