M

machine_identification - Host hardware identification monitor element

A string that describes the processor architecture. For example, x86 64 bit. The value returned for this identifier is determined by the operating system running on the host.

Table 1. Table Function Monitoring Information
Table Function Monitor Element Collection Level
ENV_GET_SYSTEM_RESOURCES table function - Return system information Always collected

max_agent_overflows - Maximum Agent Overflows monitor element

The number of times a request to create a new agent was received when the Maximum Number of Agents (maxagents) configuration parameter had already been reached.

Note: The max_agent_overflows monitor element is deprecated starting with DB2® Version 9.5. Using this monitor element will not generate an error. However, it does not return a valid value. This monitor element is no longer recommended and might be removed in a future release.
Table 2. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database Manager db2 Basic

Usage

If agent creation requests are still being received when the maxagents configuration parameter has been reached, this might indicate too high a workload for this node.

max_coord_stmt_exec_time - Maximum coordinator statement execution time monitor element

The maximum coordinator execution time of a single run of the statement, in milliseconds. This value will be zero at non-coordinator nodes or if the statement has not been executed.

Table 3. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries (reported in DETAILS XML document) ACTIVITY METRICS BASE
Table 4. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Package cache pkgcache ACTIVITY METRICS BASE

max_coord_stmt_exec_time_args - Maximum coordinator statement execution time arguments monitor element

An XML document that represents the input arguments provided to the statement that was running when the maximum execution time of a single run of the statement (max_coord_stmt_exec_time) took place on the coordinator member. This column is NULL if the statement has not yet run or if the statement has no input arguments. This document contains a parent element named max_coord_stmt_exec_time_args, which consists of one or more elements with the name max_coord_stmt_exec_time_arg. See Figure 1 for an example of the structure of the XML document.
Table 5. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries (reported in DETAILS XML document) ACTIVITY METRICS BASE
Table 6. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Package cache pkgcache_stmt_args ACTIVITY METRICS BASE

Usage

You can view the content of this document with the XMLPARSE scalar function. For example:You can view the content of this document with the XMLPARSE scalar function. For example:
SELECT XMLPARSE(DOCUMENT MAX_COORD_STMT_EXEC_TIME_ARGS) 
  FROM TABLE(MON_GET_PKG_CACHE_STMT(NULL, NULL, NULL, -2));
Figure 1 shows an example of the contents of XML document returned by the preceding statement.
Figure 1. Sample content of max_coord_stmt_exec_time_args . In this example, the document shows that 15 arguments were passed to the statement.
<?xml version="1.0" encoding="ISO-8859-1" ?> 
 <max_coord_stmt_exec_time_args 
  xmlns="http://www.ibm.com/xmlns/prod/db2/mon" release="10010000">
   <max_coord_stmt_exec_time_arg>
      <stmt_value_index>1</stmt_value_index> 
      <stmt_value_isreopt id="0">no</stmt_value_isreopt> 
      <stmt_value_isnull id="0">no</stmt_value_isnull> 
      <stmt_value_type>INTEGER</stmt_value_type> 
      <stmt_value_data>5</stmt_value_data> 
   </max_coord_stmt_exec_time_arg>
   <max_coord_stmt_exec_time_arg>
      <stmt_value_index>2</stmt_value_index> 
      <stmt_value_isreopt id="0">no</stmt_value_isreopt> 
       <stmt_value_isnull id="0">no</stmt_value_isnull> 
       <stmt_value_type>VARCHAR</stmt_value_type> 
       <stmt_value_data>78</stmt_value_data> 
   </max_coord_stmt_exec_time_arg>
   <max_coord_stmt_exec_time_arg>
      <stmt_value_index>3</stmt_value_index> 
      <stmt_value_isreopt id="0">no</stmt_value_isreopt> 
       <stmt_value_isnull id="0">no</stmt_value_isnull> 
      <stmt_value_type>VARCHAR</stmt_value_type> 
      <stmt_value_data>john</stmt_value_data> 
   </max_coord_stmt_exec_time_arg>
   <max_coord_stmt_exec_time_arg>
      <stmt_value_index>4</stmt_value_index> 
      <stmt_value_isreopt id="0">no</stmt_value_isreopt> 
       <stmt_value_isnull id="0">no</stmt_value_isnull> 
      <stmt_value_type>VARCHAR</stmt_value_type> 
      <stmt_value_data>x</stmt_value_data> 
   </max_coord_stmt_exec_time_arg>
   <max_coord_stmt_exec_time_arg>
     <stmt_value_index>5</stmt_value_index> 
     <stmt_value_isreopt id="0">no</stmt_value_isreopt> 
     <stmt_value_isnull id="0">no</stmt_value_isnull> 
     <stmt_value_type>DATE</stmt_value_type> 
     <stmt_value_data>2001-02-12</stmt_value_data> 

                        

   <max_coord_stmt_exec_time_arg>
      <stmt_value_index>15</stmt_value_index>
      <stmt_value_isreopt id="0">no</stmt_value_isreopt> 
      <stmt_value_isnull id="0">no</stmt_value_isnull> 
      <stmt_value_type>DECIMAL</stmt_value_type> 
      <stmt_value_data>+0002000.55</stmt_value_data> 
    </max_coord_stmt_exec_time_arg>
  </max_coord_stmt_exec_time_args>

Entries for the following data types are recorded in this XML document, however, the actual values for arguments of these types are not captured in the STMT_VALUE_DATA element:
  • BLOB
  • CLOB
  • REF
  • BOOLEAN
  • Structured data types
  • DATALINK
  • LONG VARGRAPHIC
  • LONG VARCHAR
  • XML tyoes
  • DBCLOB
  • ARRAY types
  • ROW types
  • ROWID
  • CURSOR variables

Input arguments are recorded beginning with the one that appears first in the statement, and continuing with each one in succession. The number of input parameters that can be recorded is constrained only by the upper limit on the size of the BLOB containing the XML document. In practical terms, it is unlikely the number input arguments captured would ever cause this limit to be reached.

The schema for the XML document that contains this element can be found in the path sqllib/misc/DB2EvmonPkgCache.xsd.

max_coord_stmt_exec_timestamp - Maximum coordinator statement execution timestamp monitor element

The time the statement that produced the max_coord_stmt_exec_time value began execution.

Table 7. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries (reported in DETAILS XML document) ACTIVITY METRICS BASE
Table 8. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Package cache pkgcache ACTIVITY METRICS BASE

max_data_received_1024 - Number of Statements with Outbound Bytes Received Between 513 and 1024 Bytes monitor element

This element represents the number of statements or chains with outbound bytes received between 513 and 1024 inclusive.

Element identifier
max_data_received_1024
Element type
counter
Table 9. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_received_128 - Number of Statements with Outbound Bytes Received Between 1 and 128 Bytes monitor element

This element represents the number of statements or chains with outbound bytes received between 1 and 128 inclusive.

Element identifier
max_data_received_128
Element type
counter
Table 10. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_received_16384 - Number of Statements with Outbound Bytes Received Between 8193 and 16384 Bytes monitor element

This element represents the number of statements or chains with outbound bytes received between 8193 and 16384 inclusive.

Element identifier
max_data_received_16384
Element type
counter
Table 11. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_received_2048 - Number of Statements with Outbound Bytes Received Between 1025 and 2048 Bytes monitor element

This element represents the number of statements or chains with outbound bytes received between 1025 and 2048 inclusive.

Element identifier
max_data_received_2048
Element type
counter
Table 12. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_received_256 - Number of Statements with Outbound Bytes Received Between 129 and 256 Bytes monitor element

This element represents the number of statements or chains with outbound bytes received between 129 and 256 inclusive.

Element identifier
max_data_received_256
Element type
counter
Table 13. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_received_31999 - Number of Statements with Outbound Bytes Received Between 16385 and 31999 Bytes monitor element

This element represents the number of statements or chains with outbound bytes received between 16385 and 31999 inclusive.

Table 14. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_received_4096 - Number of Statements with Outbound Bytes Received Between 2049 and 4096 Bytes monitor element

This element represents the number of statements or chains with outbound bytes received between 2049 and 4096 inclusive.

Element identifier
max_data_received_4096
Element type
counter
Table 15. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_received_512 - Number of Statements with Outbound Bytes Received Between 257 and 512 Bytes monitor element

This element represents the number of statements or chains with outbound bytes received between 257 and 512 inclusive.

Element identifier
max_data_received_512
Element type
counter
Table 16. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_received_64000 - Number of Statements with Outbound Bytes Received Between 32000 and 64000 Bytes monitor element

This element represents the number of statements or chains with outbound bytes received between 32000 and 64000 inclusive.

Table 17. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_received_8192 - Number of Statements with Outbound Bytes Received Between 4097 and 8192 Bytes monitor element

This element represents the number of statements or chains with outbound bytes received between 4097 and 8192 inclusive.

Element identifier
max_data_received_8192
Element type
counter
Table 18. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_received_gt64000 - Number of Statements with Outbound Bytes Received Greater than 64000 Bytes monitor element

This element represents the number of statements or chains with outbound bytes received greater than 64000.

Element identifier
max_data_received_gt64000
Element type
counter
Table 19. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_sent_1024 - Number of Statements with Outbound Bytes Sent Between 513 and 1024 Bytes monitor element

This element represents the number of statements or chains with outbound bytes sent between 513 and 1024 inclusive.

Element identifier
max_data_sent_1024
Element type
counter
Table 20. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_sent_128 - Number of Statements with Outbound Bytes Sent Between 1 and 128 Bytes monitor element

This element represents the number of statements or chains with outbound bytes sent between 1 and 128 inclusive.

Element identifier
max_data_sent_128
Element type
counter
Table 21. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_sent_16384 - Number of Statements with Outbound Bytes Sent Between 8193 and 16384 Bytes monitor element

This element represents the number of statements or chains with outbound bytes sent between 8193 and 16384 inclusive.

Element identifier
max_data_sent_16384
Element type
counter
Table 22. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_sent_2048 - Number of Statements with Outbound Bytes Sent Between 1025 and 2048 Bytes monitor element

This element represents the number of statements or chains with outbound bytes sent between 1025 and 2048 inclusive.

Element identifier
max_data_sent_2048
Element type
counter
Table 23. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_sent_256 - Number of Statements with Outbound Bytes Sent Between 129 and 256 Bytes monitor element

This element represents the number of statements or chains with outbound bytes sent between 129 and 256 inclusive.

Element identifier
max_data_sent_256
Element type
counter
Table 24. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_sent_31999 - Number of Statements with Outbound Bytes Sent Between 16385 and 31999 Bytes monitor element

This element represents the number of statements or chains with outbound bytes sent between 16385 and 31999 inclusive.

Element identifier
max_data_sent_31999
Element type
counter
Table 25. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_sent_4096 - Number of Statements with Outbound Bytes Sent Between 2049 and 4096 Bytes monitor element

This element represents the number of statements or chains with outbound bytes sent between 2049 and 4096 inclusive.

Element identifier
max_data_sent_4096
Element type
counter
Table 26. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_sent_512 - Number of Statements with Outbound Bytes Sent Between 257 and 512 Bytes monitor element

This element represents the number of statements or chains with outbound bytes sent between 257 and 512 inclusive.

Element identifier
max_data_sent_512
Element type
counter
Table 27. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_sent_64000 - Number of Statements with Outbound Bytes Sent Between 32000 and 64000 Bytes monitor element

This element represents the number of statements or chains with outbound bytes sent between 32000 and 64000 inclusive.

Element identifier
max_data_sent_64000
Element type
counter
Table 28. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_sent_8192 - Number of Statements with Outbound Bytes Sent Between 4097 and 8192 Bytes monitor element

This element represents the number of statements or chains with outbound bytes sent between 4097 and 8192 inclusive.

Element identifier
max_data_sent_8192
Element type
counter
Table 29. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_data_sent_gt64000 - Number of Statements with Outbound Bytes Sent Greater than 64000 Bytes monitor element

This element represents the number of statements or chains with outbound bytes sent greater than 64000.

Element identifier
max_data_sent_gt64000
Element type
counter
Table 30. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_network_time_1_ms - Number of Statements with Network Time of up to 1 ms monitor element

This element represents the number of statements or chains whose network time was less or equal to 1 millisecond. (Network time is the difference between host response time and elapsed execution time for a statement or chain.)

Table 31. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_network_time_100_ms - Number of Statements with Network Time between 16 and 100 ms monitor element

This element represents the number of statements or chains whose network time was greater than 16 milliseconds but less or equal to 100 milliseconds. (Network time is the difference between host response time and elapsed execution time for a statement or chain.)

Table 32. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_network_time_16_ms - Number of Statements with Network Time between 4 and 16 ms monitor element

This element represents the number of statements or chains whose network time was greater than 4 milliseconds but less or equal to 16 milliseconds. (Network time is the difference between host response time and elapsed execution time for a statement or chain.)

Element identifier
max_network_time_16_ms
Element type
counter
Table 33. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_network_time_4_ms - Number of Statements with Network Time between 1 and 4 ms monitor element

This element represents the number of statements or chains whose network time was greater than 1 millisecond but less or equal to 4 milliseconds. (Network time is the difference between host response time and elapsed execution time for a statement or chain.)

Element identifier
max_network_time_4_ms
Element type
counter
Table 34. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_network_time_500_ms - Number of Statements with Network Time between 100 and 500 ms monitor element

This element represents the number of statements or chains whose network time was greater than 100 milliseconds but less or equal to 500 milliseconds. (Network time is the difference between host response time and elapsed execution time for a statement or chain.)

Table 35. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

max_network_time_gt500_ms - Number of Statements with Network Time greater than 500 ms monitor element

This element represents the number of statements or chains whose network time was greater than 500 milliseconds. (Network time is the difference between host response time and elapsed execution time for a statement or chain.)

Table 36. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Statement
DCS Application dcs_appl Statement
Data Transmission stmt_transmissions Statement
For snapshot monitoring, this counter can be reset.
Usage
Use this element to get a better idea of the database activity and network traffic at the database or application levels.

member - Database member monitor element

The numeric identifier for the database member from which the data was retrieved for this result record.

Table 37. Table Function Monitoring Information
Table Function Monitor Element Collection Level
ADMIN_GET_MEM_USAGE table function - Get total memory consumption for instance Always collected
AUDIT_ARCHIVE procedure and table function - Archive audit log file Always collected
DBCFG administrative view and DB_GET_CFG table function - Retrieve database configuration parameter information Always collected
ENV_GET_REG_VARIABLES table function - Retrieve DB2 registry settings in use Always collected
ENV_GET_DB2_EDU_SYSTEM_RESOURCES table function - Return DB2 engine dispatchable units system information Always collected
ENV_GET_DB2_SYSTEM_RESOURCES table function - Return DB2(r) system information Always collected
ENV_GET_NETWORK_RESOURCES table function - Return network information Always collected
ENV_GET_SYSTEM_RESOURCES table function - Return system information Always collected
MON_GET_ACTIVITY table function - Return a list of activities Always collected
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details Always collected
MON_GET_AGENT table function - List agents running in a service class Always collected
MON_GET_AUTO_MAINT_QUEUE table function - Get information about automatic maintenance jobs Always collected
MON_GET_AUTO_RUNSTATS_QUEUE table function - Retrieve information about objects queued for evaluation Always collected
MON_GET_BUFFERPOOL table function - Get buffer pool metrics Always collected
MON_GET_CF_WAIT_TIME table function - Get cluster caching facility command wait time Always collected
MON_GET_CONNECTION table function - Get connection metrics Always collected
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics Always collected
MON_GET_CONTAINER table function - Get table space container metrics Always collected
MON_GET_DATABASE table function - Get database level information Always collected
MON_GET_DATABASE_DETAILS table function - Get database information metrics Always collected
MON_GET_EXTENDED_LATCH_WAIT table function - Return information for latches Always collected
MON_GET_EXTENT_MOVEMENT_STATUS - Get extent movement progress status metrics Always collected
MON_GET_FCM - Get FCM metrics Always collected
MON_GET_FCM_CONNECTION_LIST - Get details for all FCM connections Always collected
MON_GET_GROUP_BUFFERPOOL table function - Get group buffer pool metrics Always collected
MON_GET_INDEX table function - Get index metrics Always collected
MON_GET_INDEX_USAGE_LIST table function - Returns information from an index usage list Always collected
MON_GET_INSTANCE table function - Get instance level information Always collected
MON_GET_LOCKS table function - list all locks in the currently connected database Always collected
MON_GET_MEMORY_POOL table function - Get memory pool information Always collected
MON_GET_MEMORY_SET table function - Get memory set information Always collected
MON_GET_PAGE_ACCESS_INFO table function - Get buffer pool page waiting information Always collected
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache Always collected
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries Always collected
MON_GET_QUEUE_STATS table function - Return threshold queue statistics MON_GET_QUEUE_STATS table function - Return threshold queue statistics Always collected
MON_GET_REBALANCE_STATUS table function - get rebalance progress for a table space Always collected
MON_GET_ROUTINE table function - get aggregated execution metrics for routines Always collected
MON_GET_ROUTINE_DETAILS table function - get aggregated execution metric details for routines Always collected
MON_GET_ROUTINE_EXEC_LIST table function - get list of statements executed by routine Always collected
MON_GET_RTS_RQST table function - Retrieve information about real-time statistics requests Always collected
MON_GET_SECTION_OBJECT table function - List objects accessed by a section Always collected
MON_GET_SERVERLIST table function - get member priority details Always collected
MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics Always collected
MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get detailed service subclass metrics Always collected
MON_GET_SERVICE_SUBCLASS_STATS table function - Return statistics of service subclasses MON_GET_SERVICE_SUBCLASS_STATS table function - Return statistics of service subclasses Always collected
MON_GET_SERVICE_SUPERCLASS_STATS table function - Return statistics of service superclasses MON_GET_SERVICE_SUPERCLASS_STATS table function - Return statistics of service superclasses Always collected
MON_GET_TABLE table function - Get table metrics Always collected
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list Always collected
MON_GET_TABLESPACE table function - Get table space metrics Always collected
MON_GET_TABLESPACE_QUIESCER table function - Get information about quiesced table spaces Always collected
MON_GET_TRANSACTION_LOG table function - Get log information Always collected
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics Always collected
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics Always collected
MON_GET_USAGE_LIST_STATUS table function - Returns the status on a usage list Always collected
MON_GET_UTILITY table function - Get utilities running on the database Always collected
MON_GET_WORKLOAD table function - Get workload metrics Always collected
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics Always collected
MON_GET_WORKLOAD_STATS table function - Return workload statistics Always collected
MON_SAMPLE_SERVICE_CLASS_METRICS - Get sample service class metrics Always collected
MON_SAMPLE_WORKLOAD_METRICS - Get sample Always collected
MON_GET_WORK_ACTION_SET_STATS table function - Return work action set statistics MON_GET_WORK_ACTION_SET_STATS table function - Return work action set statistics Always collected
PD_GET_DIAG_HIST table function - Return records from a given facility Always collected
PDLOGMSGS_LAST24HOURS administrative view and PD_GET_LOG_MSGS table function - Retrieve problem determination messages Always collected
WLM_GET_QUEUE_STATS table function - Return threshold queue statistics Always collected
WLM_GET_SERVICE_CLASS_AGENTS table function - list agents running in a service class Always collected
WLM_GET_SERVICE_CLASS_WORKLOAD _OCCURRENCES table function - list workload occurrences Always collected
WLM_GET_SERVICE_SUBCLASS_STATS table function - Return statistics of service subclasses Always collected
WLM_GET_SERVICE_SUPERCLASS_STATS table function - Return statistics of service superclasses Always collected
WLM_GET_WORK_ACTION_SET_STATS table function - Return work action set statistics Always collected
WLM_GET_WORKLOAD_OCCURRENCE _ACTIVITIES table function - Return a list of activities Always collected
WLM_GET_WORKLOAD_STATS table function - Return workload statistics Always collected
Table 38. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Activities event_activity Always collected
Statistics event_scstats Always collected
Statistics event_osmetrics Always collected
Statistics event_wlstats Always collected
Unit of work system_metrics Always collected
Package cache - Always collected
Locking - Always collected
Change history changesummary
dbdbmcfg
regvar
ddlstmtexec
txncompletion
evmonstart
utilstart
utillocation
utilstop
Always collected

Usage

A DB2 member is a database manager instance that runs DB2 server software on a single host, A DB2 member accepts and processes database requests from applications connected to it.

member_subset_id - Member subset ID monitor element

An integer which uniquely identifies a member subset.

Table 40. Event monitoring information
Event type Logical data grouping Monitor switch
     
Unit of work uow Always collected

Usage

Use this ID to uniquely identify the member subset to which this connection or unit of work belongs. Possible values for this element are:
0
A TCP/IP based connection assigned to the default user-created member subset
-1
The application is not assigned to a member subset
-2
IPC-based connections

memory_free - Amount of free physical memory monitor element

The total amount of physical memory on this host that is not allocated to a running process, in MB.

Table 41. Table Function Monitoring Information
Table Function Monitor Element Collection Level
ENV_GET_SYSTEM_RESOURCES table function - Return system information Always collected
Table 42. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_osmetrics Always collected-

Usage

This metric reports point in time information at statistics event monitor record generation.

memory_pool_type - Memory pool name monitor element

The name of the memory pool.

Table 44. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_MEMORY_POOL - Get memory pool information Always collected

Usage

Use the memory_pool_type element to identify the type of memory pool. The possible values returned by this monitor element are listed in Table 45.
Table 45. Possible values returned for memory_pool_type
Memory pool name* Description Additional information
APM Agent pool management (APM) heap Internal memory pool
APPL_SHARED Application shared heap Internal memory pool
APPLICATION Application heap See applheapsz - Application heap size configuration parameter .
APS APS heap Internal memory pool
BSU_CF Base service utility (BSU) CF heap Internal memory pool
BSU Base service utility (BSU) heap Internal memory pool
BP Buffer pool heap See CREATE BUFFERPOOL statement .
CAT_CACHE Catalog cache heap See catalogcache_sz - Catalog cache size configuration parameter .
CLIENT_CONTEXT Client context heap Internal memory pool
DATABASE_CF Database CF heap Internal memory pool
DATABASE Database heap See dbheap - Database heap configuration parameter .
DEBUG Debug heap Internal memory pool
DROP_INDEX Drop index heap Internal memory pool
EDU Engine dispatchable unit (EDU) heap Internal memory pool
FCMBP Fast communications manager (FCM) buffer heap See fcm_num_buffers - Number of FCM buffers configuration parameter .
FCM_CHANNEL FCM channel heap See fcm_num_channels - Number of FCM channels configuration parameter
FCM_CONTROL FCM control heap Internal memory pool
FCM_LOCAL FCM local heap Internal memory pool
FCM_SESSION FCM session heap Internal memory pool
FEDERATED Federated heap Internal memory pool
KERNEL_CONTROL Kernel control block heap Internal memory pool
KERNEL Kernel heap Internal memory pool
LOCK_MGR Lock manager heap See locklist - Maximum storage for lock list configuration parameter .
MISC Miscellaneous heap See DB2_FMP_COMM_HEAPSZ registry variable .
MONITOR Monitor heap See mon_heap_sz - Database system monitor heap size configuration parameter .
OPTPROF_PARSER OptProf XML parser heap Internal memory pool
OSS_TRACKER OSS resource tracking heap Internal memory pool
PERSISTENT_PRIVATE Persistent private heap Internal memory pool
PACKAGE_CACHE Package cache heap See pckcachesz - Package cache size configuration parameter .
PRIVATE Private Internal memory pool
RESYNC Resync heap Internal memory pool
SORT Private sort heap See sortheap - Sort heap size configuration parameter .
SHARED_SORT Shared sort heap See sheapthres_shr - Sort heap threshold for shared sorts configuration parameter .
SQL_COMPILER SQL compiler heap Internal memory pool
STATEMENT Statement heap See stmtheap - Statement heap size configuration parameter .
STATISTICS Statistics heap See stat_heap_sz - Statistics heap size configuration parameter .
USER_DATA User data heap Internal memory pool
UTILITY Utility heap See util_heap_sz - Utility heap size configuration parameter .
XMLCACHE XML cache heap Internal memory pool
XMLPARSER XML parser heap Internal memory pool

memory_set_size - Memory set size monitor element

Maximum memory commitment limit, in KB.

This value represents either a configured setting for a memory set or an internally calculated value for those memory sets that are managed automatically.
Table 50. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_MEMORY_SET table function - Get memory set information Always collected

memory_set_type - Memory set type monitor element

The type of memory set.

Table 51. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_MEMORY_POOL table function - Get memory pool information Always collected
MON_GET_MEMORY_SET table function - Get memory set information Always collected

Usage

The possible values returned for this monitor element are described in Table 52:
Table 52. Possible values for memory_set_type
Memory set type Description Scope
DBMS Database manager memory set Instance
FMP Fenced mode process memory set Instance
PRIVATE Private memory set Instance
DATABASE Database memory set Database
APPLICATION Application memory set Database
FCM Fast communication manager (FCM) memory set Instance, Host

memory_set_used - Memory in use by this set monitor element

Amount of memory from this set that has been assigned to memory pools, in KB.

Table 53. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_MEMORY_SET table function - Get memory set information Always collected

Usage

This element returns the memory assigned to pools. All memory assigned to pools is committed. Additional committed memory can be cached within a memory set to improve performance.

memory_swap_free - Total free swap space monitor element

The total amount of unused swap space on this host, in MB.

Table 55. Table Function Monitoring Information
Table Function Monitor Element Collection Level
ENV_GET_SYSTEM_RESOURCES table function - Return system information Always collected
Table 56. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_osmetrics Always collected

Usage

This metric reports point in time information at statistics event monitor record generation.

memory_swap_total - Total swap space monitor element

The total amount of swap space on this host, in MB.

Table 57. Table Function Monitoring Information
Table Function Monitor Element Collection Level
ENV_GET_SYSTEM_RESOURCES table function - Return system information Always collected
Table 58. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_osmetrics Always collected

Usage

This metric reports point in time information at statistics event monitor record generation.

memory_total - Total physical memory monitor element

The total amount of physical memory on this host, in MB.

Table 59. Table Function Monitoring Information
Table Function Monitor Element Collection Level
ENV_GET_SYSTEM_RESOURCES table function - Return system information Always collected
Table 60. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_osmetrics Always collected

Usage

This metric reports point in time information at statistics event monitor record generation.

merge_sql_stmts - Merge SQL statements executed monitor element

The number of MERGE statements that were executed.

Table 62. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Statistics event_scmetrics REQUEST METRICS BASE
Statistics event_wlmmetrics REQUEST METRICS BASE
Unit of work uow_metrics REQUEST METRICS BASE

message - Control Table Message monitor element

The nature of the timestamp in the MESSAGE_TIME column. This element is only used in the CONTROL table by write-to-table event monitors.

Table 63. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
- - Always collected

Usage

The following are possible values:
FIRST_CONNECT
The time of the first connect to the database after activation.
EVMON_START
The time the event monitor listed in the EVMONNAME column was started.
OVERFLOWS: n
Denotes that n records were discarded due to buffer overflow.

message_time - Timestamp Control Table Message monitor element

The timestamp corresponding to the event described in the MESSAGE column. This element is only used in the CONTROL table by write-to-table event monitors.

Table 64. Table Function Monitoring Information
Table Function Monitor Element Collection Level
EVMON_UPGRADE_TABLES Always collected
Table 65. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
- - Always collected

metrics - Metrics monitor element

An XML document containing some of the system monitor elements collected by the statistics event monitor.

Table 66. Event Monitoring Information
Event Type Logical Data Grouping Monitor Element Collection Level
Statistics EVENTS_SCSTATS Always collected
Statistics EVENT_WLSTATS Always collected

Usage

The schema for the XML documents returned is available in the file sqllib/misc/DB2MonCommon.xsd The top level element is system_metrics.

The XML documents associated with this monitor element and the details_xml monitor element contain the same system metrics, but there is an important difference. The metrics in this monitor element are calculated to show the change in value for the metric since the last time statistics were collected. while the metrics in details_xml generally start at 0 and continue to accumulate until the next database activation.

Using the logical data groups EVENT_SCMETRICS and EVENT_WLMETRICS, you can directly view the monitor elements contained in metrics as individual elements. For example, if your statistics event monitor writes to tables, you can access the metrics by using an SQL query to retrieve data from the new logical data groups, rather than of having to post-process or parse the metrics monitor element XML document.

Important: Starting with Version 10.1 Fix Pack 1, the details_xml monitor element is deprecated for the statistics event monitor and might be removed in a future release. If you use the XML metrics data returned in details_xml, start using this monitor element instead.

mon_interval_id - Monitor interval identifier monitor element

The value of the MON_INTERVAL_ID database global variable when a particular transaction is completed.

Table 67. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_INDEX_USAGE_LIST table function - Returns information from an index usage list Always collected
MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list Always collected
Table 68. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Activities event_activity Always collected
Statistics event_histogrambin Always collected
Statistics event_osmetrics Always collected
Statistics event_qstats Always collected
Statistics event_scmetrics Always collected
Statistics event_scstats Always collected
Statistics event_wcstats Always collected
Statistics event_wlmetrics Always collected
Statistics event_wlstats Always collected
Unit of Work uow Always collected