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 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.
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 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 |
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
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 |
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Package cache | pkgcache_stmt_args | ACTIVITY METRICS BASE |
Usage
SELECT XMLPARSE(DOCUMENT MAX_COORD_STMT_EXEC_TIME_ARGS)
FROM TABLE(MON_GET_PKG_CACHE_STMT(NULL, NULL, NULL, -2));
- 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 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 |
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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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.
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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.
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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.)
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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.)
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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.)
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- 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.)
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
DCS Database | dcs_dbase | Statement |
DCS Application | dcs_appl | Statement |
Data Transmission | stmt_transmissions | Statement |
- Usage
- Use this element to get a better idea of the database activity and network traffic at the database or application levels.
medium_priority_act_total - Total number of medium priority activities monitor element
Total count of the number of medium priority activities since the last reset.
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Activity | event_activitymetrics | ACTIVITY METRICS BASE |
Package cache statement eviction | pkgcache_metrics | ACTIVITY METRICS BASE |
Statistics | event_wlmetrics | REQUEST METRICS BASE |
Statistics | event_scmetrics | REQUEST METRICS BASE |
Unit of work | uow_metrics | REQUEST METRICS BASE |
Usage
Use this element to determine the number of medium priority activities since the last reset.
member - Database member monitor element
The numeric identifier for the database member from which the data was retrieved for this result record.
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Activities | event_activity | Always collected |
Statistics | event_scstats | Always collected |
Statistics | event_superclasstats | 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 database member is a database manager instance that runs database server software on a single host. A database member accepts and processes database requests from applications that are connected to it.
member_subset_id - Member subset ID monitor element
An integer which uniquely identifies a member subset.
Table function | Monitor element collection level |
---|---|
MON_GET_CONNECTION table function - Get connection metrics | Always collected |
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics | 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_SERVERLIST table function - get member priority details | Always collected |
Event type | Logical data grouping | Monitor switch |
---|---|---|
Unit of work | uow | Always collected |
Usage
-
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_address - Memory address monitor element
Memory address.
Table function | Monitor element collection level |
---|---|
MON_GET_LATCH table function - List all latches in the current member | Always collected |
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 Function | Monitor Element Collection Level |
---|---|
ENV_GET_SYSTEM_RESOURCES table function - Return system information | Always collected |
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_id - Memory pool identifier monitor element
Memory pool identifier
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_MEMORY_POOL table function - Get memory pool information | Always collected |
memory_pool_type - Memory pool name monitor element
The name of the memory pool.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_MEMORY_POOL - Get memory pool information | Always collected |
Usage
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_pool_used - Amount of memory pool in use monitor element
Amount of committed memory in use by this memory pool, in KB.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_MEMORY_POOL - Get memory pool information | Always collected |
memory_pool_used_hwm - Memory pool high water mark monitor element
The highest amount of memory assigned to this pool since it was created, in KB.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_MEMORY_POOL table function - Get memory set information | Always collected |
memory_set_committed - Memory currently committed monitor element
The amount of memory currently committed to this memory set, in KB.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_MEMORY_SET table function - Get memory set information | Always collected |
Usage
Committed memory is memory that is backed by RAM, or paging space, or both on the system.
memory_set_id - Memory set identifier monitor element
A numeric identifier that maps to a specific memory set type.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_MEMORY_SET table function - Get memory set information | Always collected |
memory_set_size - Memory set size monitor element
Maximum memory commitment limit, in KB.
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 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
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 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_set_used_hwm - Memory set high water mark monitor element
The highest amount of memory assigned to memory pools from this set since the memory set was created, in KB.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_MEMORY_SET table function - Get memory set information | Always collected |
memory_swap_free - Total free swap space monitor element
The total amount of unused swap space on this host, in MB.
Table Function | Monitor Element Collection Level |
---|---|
ENV_GET_SYSTEM_RESOURCES table function - Return system information | Always collected |
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 Function | Monitor Element Collection Level |
---|---|
ENV_GET_SYSTEM_RESOURCES table function - Return system information | Always collected |
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 Function | Monitor Element Collection Level |
---|---|
ENV_GET_SYSTEM_RESOURCES table function - Return system information | Always collected |
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.
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Statistics | event_scmetrics | REQUEST METRICS BASE |
Statistics | event_superclassmetrics | 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.
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
- | - | Always collected |
Usage
- 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 Function | Monitor Element Collection Level |
---|---|
EVMON_UPGRADE_TABLES | Always collected |
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.
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.
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 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 |
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_superclassmetrics | Always collected |
Statistics | event_scstats | Always collected |
Statistics | event_superclassstats | Always collected |
Statistics | event_wcstats | Always collected |
Statistics | event_wlmetrics | Always collected |
Statistics | event_wlstats | Always collected |
Unit of Work | uow | Always collected |