APPLICATION_HANDLE |
BIGINT |
application_handle - Application handle monitor
element
|
DBPARTITIONNUM |
SMALLINT |
dbpartitionnum - Database partition
number monitor element |
COORD_PARTITION_NUM |
SMALLINT |
coord_partition_num - Coordinator partition
number monitor element |
LOCAL_START_TIME |
TIMESTAMP |
local_start_time - Local start time
monitor element |
UOW_ID |
INTEGER |
uow_id - Unit of work ID monitor element |
ACTIVITY_ID |
INTEGER |
activity_id - Activity ID monitor element |
PARENT_UOW_ID |
INTEGER |
parent_uow_id - Parent unit of work
ID monitor element |
PARENT_ACTIVITY_ID |
INTEGER |
parent_activity_id - Parent activity
ID monitor element |
ACTIVITY_STATE |
VARCHAR(32) |
activity_state - Activity state monitor
element
|
ACTIVITY_TYPE |
VARCHAR(32) |
activity_type - Activity type monitor elementPossible values are as follows:
- CALL
- DDL
- LOAD
- OTHER
- READ_DML
- WRITE_DML
Refer to Identify types of work with work classes for a description of the different types of SQL statements that are associated with
each activity type.
|
NESTING_LEVEL |
INTEGER |
nesting_level - Nesting level monitor
element |
INVOCATION_ID |
INTEGER |
invocation_id - Invocation ID monitor
element |
ROUTINE_ID |
INTEGER |
routine_id - Routine ID monitor element |
UTILITY_ID |
INTEGER |
utility_id - Utility ID monitor element |
SERVICE_CLASS_ID |
INTEGER |
service_class_id - Service class ID
monitor element |
DATABASE_WORK_ACTION_SET_ID |
INTEGER |
db_work_action_set_id - Database work
action set ID monitor elementOne of the following
values:
- If this activity has been categorized into a work class of database
scope, the value is the ID of the work class set of which this work
class is a member.
- If this activity has not been categorized into a work class of
database scope, the value is null.
|
DATABASE_WORK_CLASS_ID |
INTEGER |
db_work_class_id - Database work class
ID monitor elementOne of the following values:
- If this activity has been categorized into a work class of database
scope, the value is the ID of the work class.
- If this activity has not been categorized into a work class of
database scope, the value is null.
|
SERVICE_CLASS_WORK_ACTION_SET_ID |
INTEGER |
service_class_work_action_set_id -
Service class work action set ID monitor element monitor elementOne of the
following values:
- If this activity has been categorized into a work class of service
class scope, the value is the ID of the work action set associated
with the work class set to which the work class belongs.
- If this activity has not been categorized into a work class of
service class scope, the value is null.
|
SERVICE_CLASS_WORK_CLASS_ID |
INTEGER |
service_class_work_class_id - Service
class work class ID monitor element monitor elementOne of the following
values:
- If this activity has been categorized into a work class of service
class scope, the value is the ID of the work class assigned to this
activity.
- If this activity has not been categorized into a work class of
service class scope, the value is null.
|
EXECUTABLE_ID |
VARCHAR(32) FOR BIT DATA |
executable_id - Executable ID monitor
element |
TOTAL_CPU_TIME |
BIGINT |
total_cpu_time - Total CPU time
|
ROWS_READ |
BIGINT |
rows_read - Rows read
|
ROWS_RETURNED |
BIGINT |
rows_returned - Rows returned
|
QUERY_COST_ESTIMATE |
BIGINT |
query_cost_estimate - Query cost estimate
|
DIRECT_READS |
BIGINT |
direct_reads - Direct reads from database
|
DIRECT_WRITES |
BIGINT |
direct_writes - Direct writes to database
|
ENTRY_TIME |
TIMESTAMP |
entry_time - Entry time |
MEMBER |
SMALLINT |
member - Database member monitor element |
COORD_MEMBER |
SMALLINT |
coord_member - Coordinator member monitor
element |
PACKAGE_SCHEMA |
VARCHAR(128) |
package_schema - Package schema |
PACKAGE_NAME |
VARCHAR(128) |
package_name - Package name |
PACKAGE_VERSION_ID |
VARCHAR(64) |
package_version_id - Package version |
SECTION_NUMBER |
BIGINT |
section_number - Section number |
STMTNO |
INTEGER |
stmtno - Statement number monitor element |
APPL_ID |
VARCHAR(128) |
appl_id - Application ID monitor element |
CLIENT_ACCTNG |
VARCHAR(255) |
client_acctng - Client accounting string
monitor element |
CLIENT_APPLNAME |
VARCHAR(255) |
client_applname - Client application
name monitor element |
CLIENT_USERID |
VARCHAR(255) |
client_userid - Client user ID monitor
element |
CLIENT_WRKSTNNAME |
VARCHAR(255) |
client_wrkstnname - Client workstation
name monitor element |
EFFECTIVE_ISOLATION |
CHAR(2) |
effective_isolation - Effective isolation
monitor element |
EFFECTIVE_LOCK_TIMEOUT |
BIGINT |
effective_lock_timeout - Effective
lock timeout monitor element |
EFFECTIVE_QUERY_DEGREE |
BIGINT |
effective_query_degree - Effective
query degree monitor element |
ACTIVITYTOTALTIME_THRESHOLD_ID |
INTEGER |
activitytotaltime_threshold_id - Activity
total time threshold ID monitor element |
ACTIVITYTOTALTIME_THRESHOLD_VALUE |
BIGINT |
activitytotaltime_threshold_value -
Activity total time threshold value monitor element |
ACTIVITYTOTALTIME_THRESHOLD_ VIOLATED |
SMALLINT |
activitytotaltime_threshold_violated - Activity total time threshold
violated monitor element
|
AGGSQLTEMPSPACE_THRESHOLD_ID |
INTEGER |
aggsqltempspace_threshold_id - Aggregate
SQL temporary space threshold ID monitor element |
AGGSQLTEMPSPACE_THRESHOLD_VALUE |
BIGINT |
aggsqltempspace_threshold_value - AggSQL
temporary space threshold value monitor element |
AGGSQLTEMPSPACE_THRESHOLD_ VIOLATED |
SMALLINT |
aggsqltempspace_threshold_violated
- AggSQL temporary space threshold violated monitor element |
CONCURRENTDBCOORDACTIVITIES_ DB_THRESHOLD_ID |
INTEGER |
concurrentdbcoordactivities_db_threshold_id
- Concurrent database coordinator activities database threshold ID
monitor element |
CONCURRENTDBCOORDACTIVITIES_ DB_THRESHOLD_QUEUED |
SMALLINT |
concurrentdbcoordactivities_db_threshold_queued
- Concurrent database coordinator activities database threshold queued
monitor element |
CONCURRENTDBCOORDACTIVITIES_ DB_THRESHOLD_VALUE |
BIGINT |
concurrentdbcoordactivities_db_threshold_value
- Concurrent database coordinator activities database threshold value
monitor element |
CONCURRENTDBCOORDACTIVITIES_ DB_THRESHOLD_VIOLATED |
SMALLINT |
concurrentdbcoordactivities_db_threshold_violated
- Concurrent database coordinator activities database threshold violated
monitor element |
CONCURRENTDBCOORDACTIVITIES_ SUBCLASS_THRESHOLD_ID |
INTEGER |
concurrentdbcoordactivities_subclass_threshold_id
- Concurrent database coordinator activities service subclass threshold
ID monitor element |
CONCURRENTDBCOORDACTIVITIES_ SUBCLASS_THRESHOLD_QUEUED |
SMALLINT |
concurrentdbcoordactivities_subclass_threshold_queued
- Concurrent database coordinator activities service subclass threshold
queued monitor element |
CONCURRENTDBCOORDACTIVITIES_ SUBCLASS_THRESHOLD_VALUE |
BIGINT |
concurrentdbcoordactivities_subclass_threshold_value
- Concurrent database coordinator activities service subclass threshold
value monitor element |
CONCURRENTDBCOORDACTIVITIES_ SUBCLASS_THRESHOLD_VIOLATED |
SMALLINT |
concurrentdbcoordactivities_subclass_threshold_violated
- Concurrent database coordinator activities service subclass threshold
violated monitor element |
CONCURRENTDBCOORDACTIVITIES_ SUPERCLASS_THRESHOLD_ID |
INTEGER |
concurrentdbcoordactivities_superclass_threshold_id
- Concurrent database coordinator activities service superclass threshold
ID monitor element |
CONCURRENTDBCOORDACTIVITIES_ SUPERCLASS_THRESHOLD_QUEUED |
SMALLINT |
concurrentdbcoordactivities_superclass_threshold_queued
- Concurrent database coordinator activities service superclass threshold
queued monitor element |
CONCURRENTDBCOORDACTIVITIES_ SUPERCLASS_THRESHOLD_VALUE |
BIGINT |
concurrentdbcoordactivities_superclass_threshold_value
- Concurrent database coordinator activities service superclass threshold
value monitor element |
CONCURRENTDBCOORDACTIVITIES_ SUPERCLASS_THRESHOLD_VIOLATED |
SMALLINT |
concurrentdbcoordactivities_superclass_threshold_violated
- Concurrent database coordinator activities service superclass threshold
violated monitor element |
CONCURRENTDBCOORDACTIVITIES_ WL_WAS_THRESHOLD_ID |
INTEGER |
concurrentdbcoordactivities_wl_was_threshold_id
- Concurrent database coordinator activities workload work action
set threshold ID monitor element |
CONCURRENTDBCOORDACTIVITIES_ WL_WAS_THRESHOLD_QUEUED |
SMALLINT |
concurrentdbcoordactivities_wl_was_threshold_queued
- Concurrent database coordinator activities workload work action
set threshold queued monitor element |
CONCURRENTDBCOORDACTIVITIES_ WL_WAS_THRESHOLD_VALUE |
BIGINT |
concurrentdbcoordactivities_wl_was_threshold_value
- Concurrent database coordinator activities workload work action
set threshold value monitor element |
CONCURRENTDBCOORDACTIVITIES_ WL_WAS_THRESHOLD_VIOLATED |
SMALLINT |
concurrentdbcoordactivities_wl_was_threshold_violated
- Concurrent database coordinator activities workload work action
set threshold violated monitor element |
CONCURRENTDBCOORDACTIVITIES_ WORK_ACTION_SET_THRESHOLD_ID |
INTEGER |
concurrentdbcoordactivities_work_action_set_threshold_id
- Concurrent database coordinator activities work action set threshold
ID monitor element |
CONCURRENTDBCOORDACTIVITIES_ WORK_ACTION_SET_THRESHOLD_QUEUED |
SMALLINT |
concurrentdbcoordactivities_work_action_set_threshold_queued
- Concurrent database coordinator activities work action set threshold
queued monitor element |
CONCURRENTDBCOORDACTIVITIES_ WORK_ACTION_SET_THRESHOLD_VALUE |
BIGINT |
concurrentdbcoordactivities_work_action_set_threshold_value
- Concurrent database coordinator activities work action set threshold
value monitor element |
CONCURRENTDBCOORDACTIVITIES_ WORK_ACTION_SET_THRESHOLD_VIOLATED |
SMALLINT |
concurrentdbcoordactivities_work_action_set_threshold_violated
- Concurrent database coordinator activities work action set threshold
violated monitor element |
CONCURRENTWORKLOADACTIVITIES_ THRESHOLD_ID |
INTEGER |
concurrentworkloadactivities_threshold_id
- Concurrent workload activities threshold ID monitor element |
CONCURRENTWORKLOADACTIVITIES_ THRESHOLD_VALUE |
BIGINT |
concurrentworkloadactivities_threshold_value
- Concurrent workload activities threshold value monitor element |
CONCURRENTWORKLOADACTIVITIES_ THRESHOLD_VIOLATED |
SMALLINT |
concurrentworkloadactivities_threshold_violated
- Concurrent workload activities threshold violated monitor element |
CPUTIME_THRESHOLD_ID |
INTEGER |
cputime_threshold_id - CPU time threshold
ID monitor element |
CPUTIME_THRESHOLD_VALUE |
BIGINT |
cputime_threshold_value - CPU time
threshold value monitor element |
CPUTIME_THRESHOLD_VIOLATED |
SMALLINT |
cputime_threshold_violated - CPU time
threshold violated monitor element |
CPUTIMEINSC_THRESHOLD_ID |
INTEGER |
cputimeinsc_threshold_id - CPU time
in service class threshold ID monitor element |
CPUTIMEINSC_THRESHOLD_VALUE |
BIGINT |
cputimeinsc_threshold_value - CPU time
in service class threshold value monitor element |
CPUTIMEINSC_THRESHOLD_VIOLATED |
SMALLINT |
cputimeinsc_threshold_violated - CPU
time in service class threshold violated monitor element |
DATATAGINSC_THRESHOLD_ID |
INTEGER |
datataginsc_threshold_id - Data tag
in service class threshold (IN condition) ID monitor element |
DATATAGINSC_THRESHOLD_VALUE |
VARCHAR(32) |
datataginsc_threshold_value - Data
tag in service class threshold (IN condition) value monitor element |
DATATAGINSC_THRESHOLD_VIOLATED |
SMALLINT |
datataginsc_threshold_violated - Data
tag in service class threshold (IN condition) violated monitor element |
DATATAGNOTINSC_THRESHOLD_ID |
INTEGER |
datatagnotinsc_threshold_id - Data
tag in service class threshold (NOT IN condition) IDmonitor element |
DATATAGNOTINSC_THRESHOLD_VALUE |
VARCHAR(32) |
datatagnotinsc_threshold_value - Data
tag in service class threshold (NOT IN condition) value monitor element |
DATATAGNOTINSC_THRESHOLD_VIOLATED |
SMALLINT |
datatagnotinsc_threshold_violated -
Data tag in service class threshold (NOT IN condition) violated monitor
element |
ESTIMATEDSQLCOST_THRESHOLD_ID |
INTEGER |
estimatedsqlcost_threshold_id - Estimated
SQL cost threshold ID monitor element |
ESTIMATEDSQLCOST_THRESHOLD_VALUE |
BIGINT |
estimatedsqlcost_threshold_value -
Estimated SQL cost threshold value monitor element |
ESTIMATEDSQLCOST_THRESHOLD_VIOLATED |
SMALLINT |
estimatedsqlcost_threshold_violated
- Estimated SQL cost threshold violated monitor element |
LAST_REFERENCE_TIME |
TIMESTAMP |
last_reference_time - Last reference
time monitor element |
QUERY_DATA_TAG_LIST |
VARCHAR(32) |
query_data_tag_list - Estimated query
data tag list monitor element |
QUERY_ACTUAL_DEGREE |
INTEGER |
query_actual_degree - Actual runtime
degree of intrapartition parallelism monitor element |
SQLROWSREAD_THRESHOLD_ID |
INTEGER |
sqlrowsread_threshold_id - SQL rows
read threshold ID monitor element |
SQLROWSREAD_THRESHOLD_VALUE |
BIGINT |
sqlrowsread_threshold_value - SQL rows
read threshold value monitor element |
SQLROWSREAD_THRESHOLD_VIOLATED |
SMALLINT |
sqlrowsread_threshold_violated - SQL
rows read threshold violated monitor element |
SQLROWSREADINSC_THRESHOLD_ID |
INTEGER |
sqlrowsreadinsc_threshold_id - SQL
rows read in service class threshold ID monitor element |
SQLROWSREADINSC_THRESHOLD_VALUE |
BIGINT |
sqlrowsreadinsc_threshold_value - SQL
rows read in service class threshold value monitor element |
SQLROWSREADINSC_THRESHOLD_VIOLATED |
SMALLINT |
sqlrowsreadinsc_threshold_violated
- SQL rows read in service class threshold violated monitor element |
SQLROWSRETURNED_THRESHOLD_ID |
INTEGER |
sqlrowsreturned_threshold_id - SQL
rows read returned threshold ID monitor element |
SQLROWSRETURNED_THRESHOLD_VALUE |
BIGINT |
sqlrowsreturned_threshold_value - SQL
rows read returned threshold value monitor element |
SQLROWSRETURNED_THRESHOLD_VIOLATED |
SMALLINT |
sqlrowsreturned_threshold_violated
- SQL rows read returned threshold violated monitor element |
SQLTEMPSPACE_THRESHOLD_ID |
INTEGER |
sqltempspace_threshold_id - SQL temporary
space threshold ID monitor element |
SQLTEMPSPACE_THRESHOLD_VALUE |
BIGINT |
sqltempspace_threshold_value - SQL
temporary space threshold value monitor element |
SQLTEMPSPACE_THRESHOLD_VIOLATED |
SMALLINT |
sqltempspace_threshold_violated - SQL
temporary space threshold violated monitor element |
WL_WORK_ACTION_SET_ID |
INTEGER |
wl_work_action_set_id - Workload work
action set identifier monitor element |
WL_WORK_CLASS_ID |
INTEGER |
wl_work_class_id - Workload work class
identifier monitor element |
STMT_TEXT |
CLOB(2M) |
stmt_text - SQL statement text monitor
element |
EFF_STMT_TEXT |
CLOB(2M) |
eff_stmt_text - Effective statement
text monitor element |
IS_SYSTEM_APPL |
SMALLINT |
is_system_appl - Is System Application
monitor element |
NUM_AGENTS |
BIGINT |
num_agents - Number of Agents Working
on a Statement monitor element |
AGENTS_TOP |
BIGINT |
agents_top - Number of Agents Created
monitor element |
QUERY_CARD_ESTIMATE |
BIGINT |
query_card_estimate - Query Number
of Rows Estimate monitor element |
UTILITY_INVOCATION_ID |
VARCHAR(32) FOR BIT DATA |
utility_invocation_id - Utility invocation
ID monitor element |
STMT_PKG_CACHE_ID |
BIGINT |
stmt_pkgcache_id - Statement package
cache identifier monitor element |
INTRA_PARALLEL_STATE |
VARCHAR(3) |
intra_parallel_state - Current state
of intrapartition parallelism monitor element |
NUM_ROUTINES |
BIGINT |
num_routines - Number of routines monitor
element |
TOTAL_ACT_TIME |
BIGINT |
total_act_time - Total activity time
monitor element |
TOTAL_ACT_WAIT_TIME |
BIGINT |
total_act_wait_time - Total activity
wait time monitor element |
POOL_READ_TIME |
BIGINT |
pool_read_time - Total buffer pool
physical read time monitor element |
POOL_WRITE_TIME |
BIGINT |
pool_write_time - Total buffer pool
physical write time monitor element |
DIRECT_READ_TIME |
BIGINT |
direct_read_time - Direct read time
monitor element |
DIRECT_WRITE_TIME |
BIGINT |
direct_write_time - Direct write time
monitor element |
LOCK_WAIT_TIME |
BIGINT |
lock_wait_time - Time waited on locks
monitor element |
TOTAL_SECTION_SORT_TIME |
BIGINT |
total_section_sort_time - Total section
sort time monitor element |
TOTAL_SECTION_SORT_PROC_TIME |
BIGINT |
total_section_sort_proc_time - Total
section sort processing time monitor element |
TOTAL_SECTION_SORTS |
BIGINT |
total_section_sorts - Total section
sorts monitor element |
LOCK_ESCALS |
BIGINT |
lock_escals - Number of lock escalations
monitor element |
LOCK_WAITS |
BIGINT |
lock_waits - Lock waits monitor element |
ROWS_MODIFIED |
BIGINT |
rows_modified - Rows modified monitor
element |
DIRECT_READ_REQS |
BIGINT |
direct_read_reqs - Direct read requests
monitor element |
DIRECT_WRITE_REQS |
BIGINT |
direct_write_reqs - Direct write requests
monitor element |
POOL_DATA_L_READS |
BIGINT |
pool_data_l_reads - Buffer pool data
logical reads monitor element |
POOL_TEMP_DATA_L_READS |
BIGINT |
pool_temp_data_l_reads - Buffer pool
temporary data logical reads monitor element |
POOL_TEMP_DATA_CACHING_TIER_L_READS |
BIGINT |
pool_temp_data_caching_tier_l_reads - pool temporary
data page caching tier l reads monitor element Note: This monitor element is currently only available for the Db2
Warehouse and Db2 Warehouse on Cloud products.
|
POOL_TEMP_DATA_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_temp_data_caching_tier_pages_found - Buffer pool
temporary data pages found in caching tier monitor element Note: This monitor element is currently only available for the Db2 Warehouse and Db2 Warehouse on Cloud products.
|
POOL_XDA_L_READS |
BIGINT |
pool_xda_l_reads - Buffer pool XDA
data logical reads monitor element |
POOL_TEMP_XDA_L_READS |
BIGINT |
pool_temp_xda_l_reads - Buffer pool
temporary XDA data logical reads monitor element |
POOL_TEMP_XDA_CACHING_TIER_L_READS |
BIGINT |
pool_temp_xda_caching_tier_l_reads - pool XML data-type
page caching tier l reads monitor element Note: This monitor element is
currently only available for the Db2 Warehouse and Db2
Warehouse on Cloud products.
|
POOL_TEMP_XDA_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_temp_xda_caching_tier_pages_found - pool temporary
XML data-type tier pages found monitor element Note: This monitor element is currently only available for the Db2
Warehouse and Db2 Warehouse on Cloud products.
|
POOL_INDEX_L_READS |
BIGINT |
pool_index_l_reads - Buffer pool index
logical reads monitor element |
POOL_TEMP_INDEX_L_READS |
BIGINT |
pool_temp_index_l_reads - Buffer pool
temporary index logical reads monitor element |
POOL_TEMP_INDEX_CACHING_TIER_L_READS |
BIGINT |
pool_temp_index_caching_tier_l_reads - pool temporary
index-type page caching tier l reads monitor element Note: This monitor element is currently only available for the Db2
Warehouse and Db2 Warehouse on Cloud products.
|
POOL_TEMP_INDEX_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_temp_index_caching_tier_pages_found - pool
temporary index-type tier pages found monitor element Note: This monitor element is currently only available for the Db2
Warehouse and Db2 Warehouse on Cloud products.
|
POOL_DATA_P_READS |
BIGINT |
pool_data_p_reads - Buffer pool data
physical reads monitor element |
POOL_TEMP_DATA_P_READS |
BIGINT |
pool_temp_data_p_reads - Buffer pool
temporary data physical reads monitor element |
POOL_XDA_P_READS |
BIGINT |
pool_xda_p_reads - Buffer pool XDA
data physical reads monitor element |
POOL_TEMP_XDA_P_READS |
BIGINT |
pool_temp_xda_p_reads - Buffer pool
temporary XDA data physical reads monitor element |
POOL_INDEX_P_READS |
BIGINT |
pool_index_p_reads - Buffer pool index
physical reads monitor element |
POOL_TEMP_INDEX_P_READS |
BIGINT |
pool_temp_index_p_reads - Buffer pool
temporary index physical reads monitor element |
POOL_DATA_WRITES |
BIGINT |
pool_data_writes - Buffer pool data
writes monitor element |
POOL_XDA_WRITES |
BIGINT |
pool_xda_writes - Buffer pool XDA data
writes monitor element |
POOL_INDEX_WRITES |
BIGINT |
pool_index_writes - Buffer pool index
writes monitor element |
TOTAL_SORTS |
BIGINT |
total_sorts - Total sorts monitor element |
POST_THRESHOLD_SORTS |
BIGINT |
post_threshold_sorts - Post threshold
sorts monitor element |
POST_SHRTHRESHOLD_SORTS |
BIGINT |
post_shrthreshold_sorts - Post shared
threshold sorts monitor element |
SORT_OVERFLOWS |
BIGINT |
sort_overflows - Sort overflows monitor
element |
WLM_QUEUE_TIME_TOTAL |
BIGINT |
wlm_queue_time_total - Workload manager
total queue time monitor element |
WLM_QUEUE_ASSIGNMENTS_TOTAL |
BIGINT |
wlm_queue_assignments_total - Workload
manager total queue assignments monitor element |
DEADLOCKS |
BIGINT |
deadlocks - Deadlocks detected monitor
element |
FCM_RECV_VOLUME |
BIGINT |
fcm_recv_volume - FCM received volume
monitor element |
FCM_RECVS_TOTAL |
BIGINT |
fcm_recvs_total - FCM receives total
monitor element |
FCM_SEND_VOLUME |
BIGINT |
fcm_send_volume - FCM send volume monitor
element |
FCM_SENDS_TOTAL |
BIGINT |
fcm_sends_total - FCM sends total monitor
element |
FCM_RECV_WAIT_TIME |
BIGINT |
fcm_recv_wait_time - FCM received wait
time monitor element |
FCM_SEND_WAIT_TIME |
BIGINT |
fcm_send_wait_time - FCM send wait
time monitor element |
LOCK_TIMEOUTS |
BIGINT |
lock_timeouts - Number of lock timeouts
monitor element |
LOG_BUFFER_WAIT_TIME |
BIGINT |
log_buffer_wait_time - Log buffer wait
time monitor element |
NUM_LOG_BUFFER_FULL |
BIGINT |
num_log_buffer_full - Number of times
full log buffer caused agents to wait monitor element |
LOG_DISK_WAIT_TIME |
BIGINT |
log_disk_wait_time - Log disk wait
time monitor element |
LOG_DISK_WAITS_TOTAL |
BIGINT |
log_disk_waits_total - Total log disk
waits monitor element |
TOTAL_ROUTINE_TIME |
BIGINT |
total_routine_time - Total routine
time monitor element |
TOTAL_ROUTINE_INVOCATIONS |
BIGINT |
total_routine_invocations - Total routine
invocations monitor elements |
COORD_STMT_EXEC_TIME |
BIGINT |
coord_stmt_exec_time - Execution time
for statement by coordinator agent monitor element |
STMT_EXEC_TIME |
BIGINT |
stmt_exec_time - Statement execution
time monitor element |
TOTAL_SECTION_TIME |
BIGINT |
total_section_time - Total section
time monitor element |
TOTAL_SECTION_PROC_TIME |
BIGINT |
total_section_proc_time - Total section
processing time monitor element |
TOTAL_ROUTINE_NON_SECT_TIME |
BIGINT |
total_routine_non_sect_time - Non-section
routine execution time monitor elements |
TOTAL_ROUTINE_NON_SECT_PROC_TIME |
BIGINT |
total_routine_non_sect_proc_time -
Non-section processing time monitor element |
LOCK_WAITS_GLOBAL |
BIGINT |
lock_waits_global - Lock waits global
monitor element |
LOCK_WAIT_TIME_GLOBAL |
BIGINT |
lock_wait_time_global - Lock wait time
global monitor element |
LOCK_TIMEOUTS_GLOBAL |
BIGINT |
lock_timeouts_global - Lock timeouts
global monitor element |
LOCK_ESCALS_MAXLOCKS |
BIGINT |
lock_escals_maxlocks - Number of maxlocks
lock escalations monitor element |
LOCK_ESCALS_LOCKLIST |
BIGINT |
lock_escals_locklist - Number of locklist
lock escalations monitor element |
LOCK_ESCALS_GLOBAL |
BIGINT |
lock_escals_global - Number of global
lock escalations monitor element |
RECLAIM_WAIT_TIME |
BIGINT |
reclaim_wait_time - Reclaim wait time
monitor element |
SPACEMAPPAGE_RECLAIM_WAIT_TIME |
BIGINT |
spacemappage_reclaim_wait_time - Space
map page reclaim wait time monitor element |
CF_WAITS |
BIGINT |
cf_waits - Number of cluster caching
facility waits monitor element |
CF_WAIT_TIME |
BIGINT |
cf_wait_time - cluster caching facility
wait time monitor element |
POOL_DATA_GBP_L_READS |
BIGINT |
pool_data_gbp_l_reads - Group buffer
pool data logical reads monitor element |
POOL_DATA_GBP_P_READS |
BIGINT |
pool_data_gbp_p_reads - Group buffer
pool data physical reads monitor element |
POOL_DATA_LBP_PAGES_FOUND |
BIGINT |
pool_data_lbp_pages_found - Local buffer
pool found data pages monitor element |
POOL_DATA_GBP_INVALID_PAGES |
BIGINT |
pool_data_gbp_invalid_pages - Group
buffer pool invalid data pages monitor element |
POOL_INDEX_GBP_L_READS |
BIGINT |
pool_index_gbp_l_reads - Group buffer
pool index logical reads monitor element |
POOL_INDEX_GBP_P_READS |
BIGINT |
pool_index_gbp_p_reads - Group buffer
pool index physical reads monitor elements |
POOL_INDEX_LBP_PAGES_FOUND |
BIGINT |
pool_index_lbp_pages_found - Local
buffer pool index pages found monitor element |
POOL_INDEX_GBP_INVALID_PAGES |
BIGINT |
pool_index_gbp_invalid_pages - Group
buffer pool invalid index pages monitor element |
POOL_XDA_GBP_L_READS |
BIGINT |
pool_xda_gbp_l_reads - Group buffer
pool XDA data logical read requests monitor element |
POOL_XDA_GBP_P_READS |
BIGINT |
pool_xda_gbp_p_reads - Group buffer
pool XDA data physical read requests monitor element |
POOL_XDA_LBP_PAGES_FOUND |
BIGINT |
pool_xda_lbp_pages_found - Local buffer
pool XDA data pages found monitor element |
POOL_XDA_GBP_INVALID_PAGES |
BIGINT |
pool_xda_gbp_invalid_pages - Group
buffer pool invalid XDA data pages monitor element |
AUDIT_EVENTS_TOTAL |
BIGINT |
audit_events_total - Total audit events
monitor element |
AUDIT_FILE_WRITES_TOTAL |
BIGINT |
audit_file_writes_total - Total audit
files written monitor element |
AUDIT_FILE_WRITE_WAIT_TIME |
BIGINT |
audit_file_write_wait_time - Audit
file write wait time monitor element |
AUDIT_SUBSYSTEM_WAITS_TOTAL |
BIGINT |
audit_subsystem_waits_total - Total
audit subsystem waits monitor element |
AUDIT_SUBSYSTEM_WAIT_TIME |
BIGINT |
audit_subsystem_wait_time - Audit subsystem
wait time monitor element |
DIAGLOG_WRITES_TOTAL |
BIGINT |
diaglog_writes_total - Total diagnostic
log file writes monitor element |
DIAGLOG_WRITE_WAIT_TIME |
BIGINT |
diaglog_write_wait_time - Diagnostic
log file write wait time monitor element |
FCM_MESSAGE_RECVS_TOTAL |
BIGINT |
fcm_message_recvs_total - Total FCM
message receives monitor element |
FCM_MESSAGE_RECV_VOLUME |
BIGINT |
fcm_message_recv_volume - FCM message
received volume monitor element |
FCM_MESSAGE_RECV_WAIT_TIME |
BIGINT |
fcm_message_recv_wait_time - FCM message
received wait time monitor element |
FCM_MESSAGE_SENDS_TOTAL |
BIGINT |
fcm_message_sends_total - Total FCM
message sends monitor element |
FCM_MESSAGE_SEND_VOLUME |
BIGINT |
fcm_message_send_volume - FCM message
send volume monitor element |
FCM_MESSAGE_SEND_WAIT_TIME |
BIGINT |
fcm_message_send_wait_time - FCM message
send wait time monitor element |
FCM_TQ_RECVS_TOTAL |
BIGINT |
fcm_tq_recvs_total - FCM table queue
receives total monitor element |
FCM_TQ_RECV_VOLUME |
BIGINT |
fcm_tq_recv_volume - FCM table queue
received volume monitor element |
FCM_TQ_RECV_WAIT_TIME |
BIGINT |
fcm_tq_recv_wait_time - FCM table queue
received wait time monitor element |
FCM_TQ_SENDS_TOTAL |
BIGINT |
fcm_tq_sends_total - FCM table queue
send total monitor element |
FCM_TQ_SEND_VOLUME |
BIGINT |
fcm_tq_send_volume - FCM table queue
send volume monitor element |
FCM_TQ_SEND_WAIT_TIME |
BIGINT |
fcm_tq_send_wait_time - FCM table queue
send wait time monitor element |
NUM_LW_THRESH_EXCEEDED |
BIGINT |
num_lw_thresh_exceeded - Number of
lock wait thresholds exceeded monitor element |
THRESH_VIOLATIONS |
BIGINT |
thresh_violations - Number of threshold
violations monitor element |
TOTAL_APP_SECTION_EXECUTIONS |
BIGINT |
total_app_section_executions - Total
application section executions monitor element |
TOTAL_ROUTINE_USER_CODE_PROC_TIME |
BIGINT |
total_routine_user_code_proc_time -
Total routine user code processing time monitor element |
TOTAL_ROUTINE_USER_CODE_TIME |
BIGINT |
total_routine_user_code_time - Total
routine user code time monitor element |
TQ_TOT_SEND_SPILLS |
BIGINT |
tq_tot_send_spills - Total number of
table queue buffers overflowed monitor element |
EVMON_WAIT_TIME |
BIGINT |
evmon_wait_time - Event monitor wait
time monitor element |
EVMON_WAITS_TOTAL |
BIGINT |
evmon_waits_total - Event monitor total
waits monitor element |
TOTAL_EXTENDED_LATCH_WAIT_TIME |
BIGINT |
total_extended_latch_wait_time - Total
extended latch wait time monitor element |
TOTAL_EXTENDED_LATCH_WAITS |
BIGINT |
total_extended_latch_waits - Total
extended latch waits monitor element |
TOTAL_DISP_RUN_QUEUE_TIME |
BIGINT |
total_disp_run_queue_time - Total dispatcher
run queue time monitor element |
TOTAL_PEDS |
BIGINT |
total_peds - Total partial early distincts
monitor element |
DISABLED_PEDS |
BIGINT |
disabled_peds - Disabled partial early
distincts monitor element |
POST_THRESHOLD_PEDS |
BIGINT |
post_threshold_peds - Partial early
distincts threshold monitor element |
TOTAL_PEAS |
BIGINT |
total_peas - Total partial early aggregations
monitor element |
POST_THRESHOLD_PEAS |
BIGINT |
post_threshold_peas - Partial early
aggregation threshold monitor element |
TQ_SORT_HEAP_REQUESTS |
BIGINT |
tq_sort_heap_requests - Table queue
sort heap requests monitor element |
TQ_SORT_HEAP_REJECTIONS |
BIGINT |
tq_sort_heap_rejections - Table queue
sort heap rejections monitor element |
POOL_QUEUED_ASYNC_DATA_REQS |
BIGINT |
pool_queued_async_data_reqs - Data
prefetch requests monitor element |
POOL_QUEUED_ASYNC_INDEX_REQS |
BIGINT |
pool_queued_async_index_reqs - Index
prefetch requests monitor element |
POOL_QUEUED_ASYNC_XDA_REQS |
BIGINT |
pool_queued_async_xda_reqs - XDA prefetch
requests monitor element |
POOL_QUEUED_ASYNC_TEMP_DATA_REQS |
BIGINT |
pool_queued_async_temp_data_reqs -
Data prefetch requests for temporary table spaces monitor element |
POOL_QUEUED_ASYNC_TEMP_INDEX_REQS |
BIGINT |
pool_queued_async_temp_index_reqs -
Index prefetch requests for temporary table spaces monitor element |
POOL_QUEUED_ASYNC_TEMP_XDA_REQS |
BIGINT |
pool_queued_async_temp_xda_reqs - XDA
data prefetch requests for temporary table spaces monitor element |
POOL_QUEUED_ASYNC_OTHER_REQS |
BIGINT |
pool_queued_async_other_reqs - Other
requests handled by prefetchers monitor element |
POOL_QUEUED_ASYNC_DATA_PAGES |
BIGINT |
pool_queued_async_data_pages - Data
pages prefetch requests monitor element |
POOL_QUEUED_ASYNC_INDEX_PAGES |
BIGINT |
pool_queued_async_index_pages - Index
pages prefetch requests monitor element |
POOL_QUEUED_ASYNC_XDA_PAGES |
BIGINT |
pool_queued_async_xda_pages - XDA pages
prefetch requests monitor element |
POOL_QUEUED_ASYNC_TEMP_DATA_PAGES |
BIGINT |
pool_queued_async_temp_data_pages -
Data pages prefetch requests for temporary table spaces monitor element |
POOL_QUEUED_ASYNC_TEMP_INDEX_PAGES |
BIGINT |
pool_queued_async_temp_index_pages
- Index pages prefetch requests for temporary table spaces monitor
element |
POOL_QUEUED_ASYNC_TEMP_XDA_PAGES |
BIGINT |
pool_queued_async_temp_xda_pages -
XDA data pages prefetch requests for temporary table spaces monitor
element |
POOL_FAILED_ASYNC_DATA_REQS |
BIGINT |
pool_failed_async_data_reqs - Failed
data prefetch requests monitor element |
POOL_FAILED_ASYNC_INDEX_REQS |
BIGINT |
pool_failed_async_index_reqs - Failed
index prefetch requests monitor element |
POOL_FAILED_ASYNC_XDA_REQS |
BIGINT |
pool_failed_async_xda_reqs - Failed
XDA prefetch requests monitor element |
POOL_FAILED_ASYNC_TEMP_DATA_REQS |
BIGINT |
pool_failed_async_temp_data_reqs -
Failed data prefetch requests for temporary table spaces monitor element |
POOL_FAILED_ASYNC_TEMP_INDEX_REQS |
BIGINT |
pool_failed_async_temp_index_reqs -
Failed index prefetch requests for temporary table spaces monitor
element |
POOL_FAILED_ASYNC_TEMP_XDA_REQS |
BIGINT |
pool_failed_async_temp_xda_reqs - Failed
XDA prefetch requests for temporary table spaces monitor element |
POOL_FAILED_ASYNC_OTHER_REQS |
BIGINT |
pool_failed_async_other_reqs - Failed
non-prefetch requests monitor element |
PREFETCH_WAIT_TIME |
BIGINT |
prefetch_wait_time - Time waited for
prefetch monitor element |
PREFETCH_WAITS |
BIGINT |
prefetch_waits - Prefetcher wait count
monitor element |
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 |
IDA_SEND_WAIT_TIME |
BIGINT |
ida_send_wait_time - Time spent waiting
to send data monitor element |
IDA_SENDS_TOTAL |
BIGINT |
ida_sends_total - Number of times data
sent monitor element |
IDA_SEND_VOLUME |
BIGINT |
ida_send_volume - Total data volume
sent monitor element |
IDA_RECV_WAIT_TIME |
BIGINT |
ida_recv_wait_time - Time spent waiting
to receive data monitor element |
IDA_RECVS_TOTAL |
BIGINT |
ida_recvs_total - Number of times data
received monitor element |
IDA_RECV_VOLUME |
BIGINT |
ida_recv_volume - Total data volume
received monitor element |
ROWS_DELETED |
BIGINT |
rows_deleted - Rows deleted monitor
element |
ROWS_INSERTED |
BIGINT |
rows_inserted - Rows inserted monitor
element |
ROWS_UPDATED |
BIGINT |
rows_updated - Rows updated monitor
element |
TOTAL_HASH_JOINS |
BIGINT |
total_hash_joins - Total Hash Joins
monitor element |
TOTAL_HASH_LOOPS |
BIGINT |
total_hash_loops - Total Hash Loops
monitor element |
HASH_JOIN_OVERFLOWS |
BIGINT |
hash_join_overflows - Hash Join Overflows
monitor element |
HASH_JOIN_SMALL_OVERFLOWS |
BIGINT |
hash_join_small_overflows - Hash Join
Small Overflows monitor element |
POST_SHRTHRESHOLD_HASH_JOINS |
BIGINT |
post_shrthreshold_hash_joins - Post
threshold hash joins monitor element |
TOTAL_OLAP_FUNCS |
BIGINT |
total_olap_funcs - Total OLAP Functions
monitor element |
OLAP_FUNC_OVERFLOWS |
BIGINT |
olap_func_overflows - OLAP Function
Overflows monitor element |
INT_ROWS_DELETED |
BIGINT |
int_rows_deleted - Internal Rows Deleted
monitor element |
INT_ROWS_INSERTED |
BIGINT |
int_rows_inserted - Internal Rows Inserted
monitor element |
INT_ROWS_UPDATED |
BIGINT |
int_rows_updated - Internal Rows Updated
monitor element |
POOL_COL_L_READS |
BIGINT |
pool_col_l_reads - Buffer pool column-organized
logical reads monitor element |
POOL_TEMP_COL_L_READS |
BIGINT |
pool_temp_col_l_reads - Buffer pool
column-organized temporary logical reads monitor element |
POOL_TEMP_COL_CACHING_TIER_L_READS |
BIGINT |
pool_temp_col_caching_tier_l_reads - pool temporary
columnar-type page caching tier l reads monitor element Note: This monitor element is currently only available for the Db2
Warehouse and Db2 Warehouse on Cloud products.
|
POOL_TEMP_COL_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_temp_col_caching_tier_pages_found - pool temporary
columnar-type tier pages found monitor element Note: This monitor element is currently only available for the Db2
Warehouse and Db2 Warehouse on Cloud products.
|
POOL_COL_P_READS |
BIGINT |
pool_col_p_reads - Buffer pool column-organized
physical reads monitor element |
POOL_TEMP_COL_P_READS |
BIGINT |
pool_temp_col_p_reads - Buffer pool
column-organized temporary physical reads monitor element |
POOL_COL_LBP_PAGES_FOUND |
BIGINT |
pool_col_lbp_pages_found - Buffer pool
column-organized LBP pages found monitor element |
POOL_COL_WRITES |
BIGINT |
pool_col_writes - Buffer pool column-organized
writes monitor element |
POOL_COL_GBP_L_READS |
BIGINT |
pool_col_gbp_l_reads - Buffer pool
column-organized GBP logical reads monitor element |
POOL_COL_GBP_P_READS |
BIGINT |
pool_col_gbp_p_reads - Buffer pool
column-organized GBP physical reads monitor element |
POOL_COL_GBP_INVALID_PAGES |
BIGINT |
pool_col_gbp_invalid_pages - Buffer
pool column-organized GBP invalid data pages monitor element |
POOL_COL_GBP_INDEP_PAGES_FOUND_IN_LBP |
BIGINT |
pool_col_gbp_indep_pages_found_in_lbp
- Buffer pool column-organized GBP independent pages found in local
buffer pool monitor element |
POOL_QUEUED_ASYNC_COL_REQS |
BIGINT |
pool_queued_async_col_reqs - Column-organized
prefetch requests monitor element |
POOL_QUEUED_ASYNC_TEMP_COL_REQS |
BIGINT |
pool_queued_async_temp_col_reqs - Column-organized
temporary prefetch requests monitor element |
POOL_QUEUED_ASYNC_COL_PAGES |
BIGINT |
pool_queued_async_col_pages - Column-organized
page prefetch requests monitor element |
POOL_QUEUED_ASYNC_TEMP_COL_PAGES |
BIGINT |
pool_queued_async_temp_col_pages -
Column-organized page temporary prefetch requests monitor element |
POOL_FAILED_ASYNC_COL_REQS |
BIGINT |
pool_failed_async_col_reqs - Failed
column-organized prefetch requests monitor element |
POOL_FAILED_ASYNC_TEMP_COL_REQS |
BIGINT |
pool_failed_async_temp_col_reqs - Failed
column-organized temporary prefetch requests monitor element |
TOTAL_COL_TIME |
BIGINT |
total_col_time - Total column-organized
time monitor element |
TOTAL_COL_PROC_TIME |
BIGINT |
total_col_proc_time - Total column-organized
processing time monitor element |
TOTAL_COL_EXECUTIONS |
BIGINT |
total_col_executions - Total column-organized
executions monitor element |
COMM_EXIT_WAIT_TIME |
BIGINT |
comm_exit_wait_time - Communication
buffer exit wait time |
COMM_EXIT_WAITS |
BIGINT |
comm_exit_waits - Communication buffer
exit number of waits |
POST_THRESHOLD_HASH_JOINS |
BIGINT |
post_threshold_hash_joins - Hash Join
Threshold monitor element |
POOL_DATA_CACHING_TIER_L_READS |
BIGINT |
pool_data_caching_tier_l_reads - pool data-type page
caching tier l reads monitor element Note: This monitor element is
currently only available for the Db2 Warehouse and Db2
Warehouse on Cloud products.
|
POOL_INDEX_CACHING_TIER_L_READS |
BIGINT |
pool_index_caching_tier_l_reads - pool index-type page
caching tier l reads monitor element Note: This monitor element is
currently only available for the Db2 Warehouse and Db2
Warehouse on Cloud products.
|
POOL_XDA_CACHING_TIER_L_READS |
BIGINT |
pool_xda_caching_tier_l_reads - pool XML data-type page
caching tier l reads monitor element Note: This monitor element is
currently only available for the Db2 Warehouse and Db2
Warehouse on Cloud products.
|
POOL_COL_CACHING_TIER_L_READS |
BIGINT |
pool_col_caching_tier_l_reads - pool columnar-type page
caching tier l reads monitor element Note: This monitor element is
currently only available for the Db2 Warehouse and Db2
Warehouse on Cloud products.
|
POOL_DATA_CACHING_TIER_PAGE_WRITES |
BIGINT |
Reserved for future use. |
POOL_INDEX_CACHING_TIER_PAGE_WRITES |
BIGINT |
Reserved for future use. |
POOL_XDA_CACHING_TIER_PAGE_WRITES |
BIGINT |
Reserved for future use. |
POOL_COL_CACHING_TIER_PAGE_WRITES |
BIGINT |
Reserved for future use. |
POOL_DATA_CACHING_TIER_PAGE_UPDATES |
BIGINT |
Reserved for future use. |
POOL_INDEX_CACHING_TIER_PAGE_UPDATES |
BIGINT |
Reserved for future use. |
POOL_XDA_CACHING_TIER_PAGE_UPDATES |
BIGINT |
Reserved for future use. |
POOL_COL_CACHING_TIER_PAGE_UPDATES |
BIGINT |
Reserved for future use. |
POOL_CACHING_TIER_PAGE_READ_TIME |
BIGINT |
pool_caching_tier_page_read_time - pool caching tier page read time monitor element |
POOL_CACHING_TIER_PAGE_WRITE_TIME |
BIGINT |
Reserved for future use. |
POOL_DATA_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_data_caching_tier_pages_found - Buffer pool data
caching tier pages found monitor element Note: This monitor element is currently only available for the Db2
Warehouse and Db2 Warehouse on Cloud products.
|
POOL_INDEX_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_index_caching_tier_pages_found - Buffer pool index
caching tier pages found monitor element Note: This monitor element is currently only available for the Db2
Warehouse and Db2 Warehouse on Cloud products.
|
POOL_XDA_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_xda_caching_tier_pages_found - Buffer pool XML
data caching tier pages found monitor element Note: This monitor element is currently only available for the Db2
Warehouse and Db2 Warehouse on Cloud products.
|
POOL_COL_CACHING_TIER_PAGES_FOUND |
BIGINT |
pool_col_caching_tier_pages_found - Buffer pool
columnar-type caching tier pages found monitor element Note: This monitor element is currently only available for the Db2
Warehouse and Db2 Warehouse on Cloud products.
|
POOL_DATA_CACHING_TIER_GBP_INVALID_PAGES |
BIGINT |
Reserved for future use. |
POOL_INDEX_CACHING_TIER_GBP_INVALID_PAGES |
BIGINT |
Reserved for future use. |
POOL_XDA_CACHING_TIER_GBP_INVALID_PAGES |
BIGINT |
Reserved for future use. |
POOL_COL_CACHING_TIER_GBP_INVALID_PAGES |
BIGINT |
Reserved for future use. |
POOL_DATA_CACHING_TIER_GBP_INDEP_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_INDEX_CACHING_TIER_GBP_INDEP_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_XDA_CACHING_TIER_GBP_INDEP_PAGES_FOUND |
BIGINT |
Reserved for future use. |
POOL_COL_CACHING_TIER_GBP_INDEP_PAGES_FOUND |
BIGINT |
Reserved for future use. |
TOTAL_HASH_GRPBYS |
BIGINT |
total_hash_grpbys - Total hash group
by operations |
HASH_GRPBY_OVERFLOWS |
BIGINT |
hash_grpby_overflows - Hash group by
overflows |
POST_THRESHOLD_HASH_GRPBYS |
BIGINT |
post_threshold_hash_grpbys - Hash group
by threshold |
POST_THRESHOLD_OLAP_FUNCS |
BIGINT |
post_threshold_olap_funcs - OLAP function
threshold monitor element |
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 |
SEMANTIC_ENV_ID |
BIGINT |
semantic_env_id - Query semantic compilation
environment ID monitor element |
STMTID |
BIGINT |
stmtid - Query statement ID monitor
element |
PLANID |
BIGINT |
planid - Query plan ID monitor element |
POST_THRESHOLD_COL_VECTOR_CONSUMERS |
BIGINT |
post_threshold_col_vector_consumers
- Post threshold columnar_vector consumers |
TOTAL_COL_VECTOR_CONSUMERS |
BIGINT |
total_col_vector_consumers - Total
columnar_vector consumers |
ACTIVE_HASH_GRPBYS |
BIGINT |
active_hash_grpbys - Active hash GROUP
BY operations monitor element |
ACTIVE_HASH_GRPBYS_TOP |
BIGINT |
active_hash_grpbys_top - Active hash
Group By operations high watermark |
ACTIVE_HASH_JOINS |
BIGINT |
active_hash_joins - Active hash joins
monitor element |
ACTIVE_HASH_JOINS_TOP |
BIGINT |
active_hash_joins_top - Active hash
joins operations high watermark |
ACTIVE_OLAP_FUNCS |
BIGINT |
active_olap_funcs - Active OLAP Functions
monitor element |
ACTIVE_OLAP_FUNCS_TOP |
BIGINT |
active_olap_funcs_top - Active OLAP
functions operations high watermark |
ACTIVE_PEAS |
BIGINT |
active_peas - Active partial early
aggregations operations |
ACTIVE_PEAS_TOP |
BIGINT |
active_peas_top - Active partial early
aggregations operations high watermark |
ACTIVE_PEDS |
BIGINT |
active_peds - Active partial early
distinct operations |
ACTIVE_PEDS_TOP |
BIGINT |
active_peds_top - Active partial early
distinct operations high watermark |
ACTIVE_SORT_CONSUMERS |
BIGINT |
active_sort_consumers - Active sort
consumers |
ACTIVE_SORT_CONSUMERS_TOP |
BIGINT |
active_sort_consumers_top - Active
sort consumers high watermark |
ACTIVE_SORTS |
BIGINT |
active_sorts - Active Sorts monitor
element |
ACTIVE_SORTS_TOP |
BIGINT |
active_sorts_top - Active Sorts high
watermark |
ACTIVE_COL_VECTOR_CONSUMERS |
BIGINT |
active_col_vector_consumers - Active
columnar_vector consumers |
ACTIVE_COL_VECTOR_CONSUMERS_TOP |
BIGINT |
active_col_vector_consumers_top - Active
columnar_vector consumers high watermark |
SORT_CONSUMER_HEAP_TOP |
BIGINT |
sort_consumer_heap_top - Individual
private sort heap consumer high watermark |
SORT_CONSUMER_SHRHEAP_TOP |
BIGINT |
sort_consumer_shrheap_top - Individual
shared sort heap consumer high watermark |
SORT_HEAP_ALLOCATED |
BIGINT |
sort_heap_allocated - Total Sort Heap
Allocated monitor element |
SORT_HEAP_TOP |
BIGINT |
sort_heap_top - Sort private heap high
watermark monitor element |
SORT_SHRHEAP_ALLOCATED |
BIGINT |
sort_shrheap_allocated - Sort Share
Heap Currently Allocated monitor element |
SORT_SHRHEAP_TOP |
BIGINT |
sort_shrheap_top - Sort share heap
high watermark monitor element |
TOTAL_INDEX_BUILD_TIME |
BIGINT |
total_index_build_time - Total time
spent building indexes due to index creation |
TOTAL_INDEX_BUILD_PROC_TIME |
BIGINT |
total_index_build_proc_time - Total
non-wait time spent building indexes due to index creation |
TOTAL_INDEXES_BUILT |
BIGINT |
total_indexes_built - Total number
of indexes built |
FCM_TQ_RECV_WAITS_TOTAL |
BIGINT |
fcm_tq_recv_waits_total - Number of
times spent waiting to receive the next buffer monitor element |
FCM_MESSAGE_RECV_WAITS_TOTAL |
BIGINT |
fcm_message_recv_waits_total - Number
of times spent waiting for FCM reply message monitor element |
FCM_TQ_SEND_WAITS_TOTAL |
BIGINT |
fcm_tq_send_waits_total - Number of
times spent waiting to send the next buffer monitor element |
FCM_MESSAGE_SEND_WAITS_TOTAL |
BIGINT |
fcm_message_send_waits_total - Number
of times spent blocking on an FCM message send monitor element |
FCM_SEND_WAITS_TOTAL |
BIGINT |
fcm_send_waits_total - Number of times
spent blocking on an FCM send operation monitor element |
FCM_RECV_WAITS_TOTAL |
BIGINT |
fcm_recv_waits_total - Number of times
spent waiting to receive data through FCM monitor element |
ACTIVITYTOTALRUNTIME_THRESHOLD_ID |
INTEGER |
activitytotalruntime_threshold_id - Activity total runtime threshold
ID monitor element |
ACTIVITYTOTALRUNTIME_THRESHOLD_VALUE |
TIMESTAMP |
activitytotalruntime_threshold_value - Activity total runtime
threshold value monitor element |
ACTIVITYTOTALRUNTIME_THRESHOLD_VIOLATED |
SMALLINT |
activitytotalruntime_threshold_violated - Activity total runtime
threshold violated monitor element |
ACTIVITYTOTALRUNTIMEINALLSC_THRESHOLD_ID |
INTEGER |
activitytotalruntimeinallsc_threshold_id - Activity total runtime in
all service classes threshold ID monitor element |
ACTIVITYTOTALRUNTIMEINALLSC_THRESHOLD_VALUE |
TIMESTAMP |
activitytotalruntimeinallsc_threshold_value - Activity total runtime
in all service classes threshold value monitor element |
ACTIVITYTOTALRUNTIMEINALLSC_THRESHOLD_VIOLATED |
SMALLINT |
activitytotalruntimeinallsc_threshold_violated - Activity total
runtime in all service classes threshold violated monitor element |
ADM_BYPASSED |
SMALLINT |
adm_bypassed - Admission control bypassed monitor element |
COL_VECTOR_CONSUMER_OVERFLOWS |
BIGINT |
col_vector_consumer_overflows - Columnar vector consumer overflows monitor element. |
TOTAL_COL_SYNOPSIS_TIME |
BIGINT |
total_col_synopsis_time - Total column-organized synopsis table time monitor element |
TOTAL_COL_SYNOPSIS_PROC_TIME |
BIGINT |
total_col_synopsis_proc_time - Total column-organized synopsis table processing time monitor element |
TOTAL_COL_SYNOPSIS_EXECUTIONS |
BIGINT |
total_col_synopsis_executions - Total column-organized synopsis table executions monitor element |
COL_SYNOPSIS_ROWS_INSERTED |
BIGINT |
col_synopsis_rows_inserted - Column-organized synopsis table rows inserted monitor element |
ADM_OVERFLOWS |
BIGINT |
adm_overflows - Number of times an activity fit as an overflow
monitor element |
ADM_BYPASS_ACT_TOTAL |
BIGINT |
adm_bypass_act_total - Number of times admission control was bypassed
monitor element |
LOB_PREFETCH_WAIT_TIME |
BIGINT |
lob_prefetch_wait_time - LOB prefetch wait time monitor element |
LOB_PREFETCH_REQS |
BIGINT |
lob_prefetch_reqs - LOB prefetcher request count monitor element |
FED_ROWS_DELETED |
BIGINT |
fed_rows_deleted - Rows deleted by a federation system monitor element |
FED_ROWS_INSERTED |
BIGINT |
fed_rows_inserted - Rows inserted by a federation system monitor element |
FED_ROWS_UPDATED |
BIGINT |
fed_rows_updated - Rows updated by a federation system monitor element |
FED_ROWS_READ |
BIGINT |
fed_rows_read - Rows read by a federation system monitor element |
FED_WAIT_TIME |
BIGINT |
fed_wait_time - Time spent by a federation server monitor element |
FED_WAITS_TOTAL |
BIGINT |
fed_waits_total - Total number of execution times for a federation server monitor element |
ESTIMATED_SORT_SHRHEAP_TOP |
BIGINT |
estimated_sort_shrheap_top - Estimated shared sort heap consumption
monitor element
|
ESTIMATED_SORT_CONSUMERS_TOP |
BIGINT |
estimated_sort_consumers_top - Estimated concurrently executing sort
memory consumers monitor element
|
ESTIMATED_RUNTIME |
BIGINT |
estimated_runtime - Estimated execution time for a DML statement
monitor element monitor element
|
UTIL_HEAP_ALLOCATED |
BIGINT |
util_heap_allocated - Total utility heap allocated monitor
element |
ADM_RESOURCE_ACTUALS |
CHAR(1) |
adm_resource_actuals - Query uses WLM admission control resource
actuals |
APPLICATION_NAME |
VARCHAR(128) |
appl_name - Application name
|
WORKLOAD_ID |
INTEGER |
workload_id - Workload ID
|
SORTSHRHEAPUTIL_THRESHOLD_ID |
INTEGER |
sortshrheaputil_threshold_id - Shared sortheap utilization threshold
ID |
SORTSHRHEAPUTIL_THRESHOLD_VALUE |
BIGINT |
sortshrheaputil_threshold_value - Shared sortheap utilization threshold
value |
SORTSHRHEAPUTIL_THRESHOLD_VIOLATED |
SMALLINT |
sortshrheaputil_threshold_violated - Shared sortheap utilization
threshold violated |
SESSION_PRIORITY |
VARCHAR (10) |
session_priority - Session priority monitor element |
TENANT_ID |
BIGINT |
tenant_id - Tenant identifier monitor element
|
TENANT_NAME |
VARCHAR(128) |
tenant_name - Tenant name monitor element
|
ACT_SORTMEM_LIMIT_PAGES |
BIGINT |
act_sortmem_limit_pages - Activity sort memory limit monitor element (4k pages) |
ACT_SORTMEM_LIMIT_PCT |
SMALLINT |
act_sortmem_limit_pct - Activity sort
memory limit (percentage) 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.
|