2 IBM DB2 Database Metrics

This chapter provides descriptions for all IBM DB2 Database metric categories, and tables list and describe associated metrics for each category. The tables also provide user actions if any of the metrics for a particular category support user actions. Shaded rows represent key columns for a particular category.

Connections

Connections metrics provide the connection details for the database at the Agent level and at the Database Manager level. Connections metrics consist of the following categories:

Agent Collection Statistics
Connected Applications Statistics

Agent Connection Statistics Metrics

The metrics in this category return the Agent connection statistics, including the configured values and the current parameter values at the Database Manager snapshot level.

Default Collection Interval — Every 15 minutes

Table 2-1 Agent Connection Statistics Metrics

Metric	Description and User Action
Agent Created Due to Empty Pool	Number of Agents created due to an empty pool.
Agent Creation Rate	Creation rate for Agents in the last interval, which equals: (agents_created_empty_pool-agents_created_empty_pool)/ __interval Increase the value of the configuration parameter agents_created_empty_pool.
Agent Creation to Assignment Ratio	Creation to assignment ratio, which equals: (agents_created_empty_pool /agents_from_pool) Increase the value of the configuration parameter agents_from_pool.
Agent Limit	Number of Agents the Database Manager can create.
Agent Waiting Top	Maximum number of Agents that have ever waited.
Agents Assignment Rate	Assignment rate for Agents in the last interval, which equals: (agents_from_pool-agents_from_pool) /__interval Increase the value of the configuration parameter agents_from_pool.
Agents From Pool	Number of Agents from the pool.
Agents Registered	Number of registered Agents.
Agents Waiting on Token	Number of Agents waiting on a token.
Coordination Agent Limit	Maximum number of coordination Agents the Database Manager can create.
Idle Agents	Number of idle Agents.
Maximum Agents Registered	Maximum number of registered Agents.
Maximum Coordination Agents	Maximum number of coordination Agents the database has created.

Connected Applications Statistics Metrics

The metrics in this category return the current connection information at both the database and Database Manager snapshot level, including the number of active connections.

Default Collection Interval — Every 15 minutes

Table 2-2 Connected Applications Statistics Metrics

Metric	Description
Database Name (key column)	Name of the database
Remote Connections	Current number of connections initiated from remote clients to the instance of the database manager that is being monitored.
Local Connections	Number of local applications currently connected to a database within the database instance being monitored.
Remote Connections in Execution	Number of remote applications currently connected to a database and are currently processing a unit of work within the database manager instance being monitored.
Local Connections in Execution	Number of local applications currently connected to a database that are currently processing a unit of work within the database manager instance being monitored.
Connects Since Database Activation	Number of connections to the database since the first connect, activate, or last reset (coordinator Agents).
Applications Connected Currently	Number of applications currently connected to the database.
Applications Executing in the Database	Number of applications currently connected to the database, and for which the database manager is currently processing a request.

Database Manager Configuration Information

Database Manager Configuration Information metrics describe a set of Database Manager configuration parameters. These values are of two types: in hard disk and in memory, which is the type presented here. Database Manager Configuration Information metrics consist of the following categories:

Capacity
Logging and Recovery
Connection
Partitioned Database Environment
Database Instance

Capacity Metrics

The metrics in this category return the Database Manager capacity configuration parameters that can impact the throughput on your system.

Table Name — MGMT_EMX_IBMDB2_DBMCAP
View Name — MGMT_EMX_IBMDB2_DBMCAP_VIEW

Default Collection Interval — Every 24 hours

Table 2-3 Capacity Metrics

Metric	Description
Application Support Layer Size	The application support layer heap represents a communication buffer between the local application and its associated Agent.
Database System Monitor Heap Size	Determines the amount of memory, in pages, to allocate for database monitor data.
Audit Buffer Size	Specifies the size of the buffer used when auditing the database.
Maximum Java Interpreter Heap Size	Determines the maximum size of the heap used by the Java interpreter started to service Java DB2 stored procedures and UDFs.
Maximum Total Files Open	Defines the maximum number of files that can be opened by all Agents and other threads executing in a single database manager instance.
Priority of Agents	Controls the priority the operating system scheduler gives to all Agents and other database manager instance processes and threads.
Maximum Number of Agents	Indicates the maximum number of database manager Agents, whether coordinator Agents or sub-Agents, available at any given time to accept application requests.
Maximum Number of Concurrent Agents	Maximum number of database manager Agents that can concurrently execute a database manager transaction.
Agent Pool Size	Determines the maximum size of the idle Agent pool.
Initial Number of Agents in Pool	Determines the initial number of idle Agents created in the Agentpool at DB2START time.
Sort Heap Threshold	The size of the shared sort memory is statically predetermined at the time of the first connection to a database based on the value of sheapthreas.

Connection Metrics

The metrics in this category return the parameters that provide information about using DB2 in a client/server environment.

Table Name — MGMT_EMX_IBMDB2_DBMCON
View Name — MGMT_EMX_IBMDB2_DBMCON_VIEW

Default Collection Interval — Every 24 hours

Table 2-4 Connection Metrics

Metric	Description
TCP/IP Service Name	Contains the name of the TCP/IP port that a database server uses to communicate to the client.
Search Discovery Communications Protocols	From an administration server perspective, this metric defines the search discovery managers started when DB2ADMIN starts.

Database Instance Metrics

The metrics in this category return the parameters that provide information about Database Manager instances.

Table Name — MGMT_EMX_IBMDB2_DBMDBINST
View Name — MGMT_EMX_IBMDB2_DBMDBINST_VIEW

Default Collection Interval — Every 24 hours

Table 2-5 Database Instance Metrics

Metric	Description
Diagnostic Error Capture Level	Determines the type of diagnostic errors recorded in the db2diag.log.
Diagnostic Directory Data Path	Enables you to specify the fully qualified path for DB2 diagnostic information.
Notify Level Raw	Specifies the type of administration notification messages written to the administration notification log.
Default Database System Monitor Switches	Unique metric that enables you to set several switches, each of which are internally represented by a bit of the metric.
Communications Bandwidth	Value calculated for the communications bandwidth in MB per second.
CPU Speed Raw	The CPU speed, in milliseconds per instruction, used by the SQL optimizer to estimate the cost of performing certain operations.
Maximum Number of Concurrently Active Databases	Specifies the number of local databases that can be concurrently active.
System Administration Authority Group Name	Defines the group name with SYSADM authority for the database manager instance.
Notify Level	If notifylevel_raw equals: 0 — No messages 1 — Fatal or unrecoverable errors 2 — All Immediate action required messages 3 — All Important information (no immediate action required) Otherwise, All Informational messages.
CPU Speed	CPU speed in MIPs, which equals: 1/(cpuspeed_raw*1000)

Logging and Recovery Metrics

The metrics in this category save the logging and recovery information. Recovering your environment can be very important to prevent the loss of critical data. A number of parameters are available to help you manage your environment and to ensure that you can adequately recover your data or transactions.

Table Name — MGMT_EMX_IBMDB2_DBMLOGREC
View Name — MGMT_EMX_IBMDB2_DBMLOGREC_VIEW

Default Collection Interval — Every 24 hours

Table 2-6 Logging and Recovery Metrics

Metric	Description
Transaction Manager Database Name	Identifies the name of the transaction manager (TM) database for each DB2 instance.
Transaction Resync Interval	Specifies the time interval in seconds for which a transaction manager (TM), resource manager (RM), or sync point manager (SPM) should retry the recovery of any outstanding transactions in doubt found in the TM, RM, or SPM.
Sync Point Manager Name	Identifies the name of the sync point manager (SPM) instance to the database manager.
Sync Point Manager Log File Size	Identifies the sync point manager (SPM) log file size in 4 KB pages.
Sync Point Manager Resync Agent Limit	Identifies the number of Agents that can simultaneously perform resync operations.

Partitioned Database Environment Metrics

The metrics in this category return parameters about parallel operations and partitioned database environments.

Table Name — MGMT_EMX_IBMDB2_DBMPARENV
View Name — MGMT_EMX_IBMDB2_DBMPARENV_VIEW

Default Collection Interval — Every 24 hours

Table 2-7 Partitioned Database Environment Metrics

Metric	Description
Connection Elapsed Time	Specifies the number of seconds within which a TCP/IP connection is to be established between two database partition servers.
Number of FCM Buffers	Specifies the number of 4 KB buffers used for internal communications (messages) both among and within database servers.
Node Connection Retries	max_connretries specifies the number of connection retries that can be made to a database partition server.
Maximum Time Difference Among Nodes	Each database partition server has its own system clock. This metric specifies the maximum time difference, in minutes, that is permitted among the database partition servers listed in the node configuration file.
Start and Stop Timeout	Applicable only in a partitioned database environment.

Health Indicators/Alarms

Health Indicators/Alarms metrics return the health information and current values for all the snapshot levels of containers, tablespaces, databases and the Database Manager. Health Indicators/Alarms metrics consist of the following categories:

Container Health Indicator
Container Health Information
Database Health Indicator
Database Health Information
Database Collection Health Indicator
DBM Health Indicator
DBM Health Information
Tablespaces Health Indicator
Tablespaces Health Indicator History

Container Health Indicator Metrics

The metrics in this category return health indicator information for tablespace containers from a health snapshot of tablespaces in a database.

Default Collection Interval — Every 30 minutes

Table 2-8 Container Health Indicator Metrics

Metric	Description and User Action
Container Name	Name of the container.
Health Indicator Alert State	State of the alert. If alert_state_raw equals: 1 — Normal 2 — Attention 3 — Warning 4 — Alarm A warning or alarm condition indicates that you should examine the Health Indicator Alert Type.
Health Indicator Alert State Raw	Severity of the alert.
Health Indicator Alert Type	Type of alert. If alert_state_raw equals: 3001 — Tablespace Container State 3002 — Tablespace Container Utilization
Health Indicator Identifier	Identifier for the alert.
Health Indicator Timestamp	Time when the alert was generated.
Health Indicator Value	Value for the alert.
Node Number	Node at which the alert was generated.
Snapshot Timestamp	Time when the query was executed.
Additional Information	Additional information present in the Container Health Indicator metrics.

Container Health Information Metrics

The metrics in this category return container information from a health snapshot of a database.

Default Collection Interval — Every 30 minutes

Table 2-9 Container Health Information Metrics

Metric	Description and User Action
Container Name (key column)	Name of the container.
Tablespace Name (key column)	Name of the tablespace to which the container belongs.
Node Number	Node at which the container resides.
Rolled Up Alert State	If alert_state_raw equals: 1 — Normal 2 — Attention 3 — Warning 4 — Alarm
Rolled Up Alert State Raw	Severity of the alert.
Snapshot Timestamp	Time when the query was executed.

Database Collection Health Indicator Metrics

The metrics in this category return container information from a health snapshot of a database.

Default Collection Interval — Every 30 minutes

Table 2-10 Database Collection Health Indicator Metrics

Metric	Description and User Action
Database Name (key column)	Name of the database.
Health Indicator Detail	Description of the object.
Health Indicator ID	Identifier for the alert.
Health Indicator Object Name	Name of the object.
Health Indicator Object State Detail	Type of alert state. A warning or alarm condition indicates that the Health Indicator Alert Type should be examined.
Health Indicator Object State	Severity of the alert.
Health Indicator Timestamp	Time when the alert was generated.
Snapshot Timestamp	Time when the query was executed.

Database Health Indicator Metrics

The metrics in this category return health indicator information from a health snapshot of a database.

Default Collection Interval — Every 30 minutes

Table 2-11 Database Health Indicator Metrics

Metric	Description and User Action
Database Name (key column)	Name of the database.
Health Indicator Alert State Raw	Severity of the alert.
Health Indicator Alert State	If alert_state_raw equals: 1 — Normal 2 — Attention 3 — Warning 4 — Alarm A warning or alarm condition indicates that the Health Indicator Alert Type should be examined.
Health Indicator Alert Type	If alert_state_raw equals: 3001 — Tablespace Container State 3002 — Tablespace Container Utilization
Health Indicator ID	Identifier for the alert.
Health Indicator Timestamp	Time when the alert was generated.
Health Indicator Value	Value for the alert.
Snapshot Timestamp	Time when the query was executed.
Additional Information	Additional information present in the Database Health Indicator metrics.

Database Health Information Metrics

The metrics in this category return information from a health snapshot of a database.

Default Collection Interval — Every 30 minutes

Table 2-12 Database Health Information Metrics

Metric	Description and User Action
Database Name (key column)	Name of the database.
Database Path	Physical path of the database.
Database Location	Location of the database. If db_location_raw equals: 0 — Local 1 — Remote
Database Location Raw	Location of the database with respect to the DBM.
Health Indicator Alert State	If alert_state_raw equals: 1 — Normal 2 — Attention 3 — Warning 4 — Alarm A warning or alarm condition indicates there are one or more alerts on the database.
Health Indicator Alert State Raw	Severity of the alert.
Input Database Alias	Alias name for the database.
Server Platform	Platform where the database is installed.
Snapshot Timestamp	Time when the query was executed.

DBM Health Indicator Metrics

The metrics in this category return health indicator information from a health snapshot of the DB2 Database Manager.

Default Collection Interval — Every 30 minutes

Table 2-13 DBM Health Indicator Metrics

Metric	Description and User Action
Database Name (key column)	Name of the database.
Health Indicator Alert State Raw	Severity of the alert.
Health Indicator Alert Type	If alert_state_raw equals: 3001 — Tablespace Container State 3002 — Tablespace Container Utilization
Health Indicator Alert State	If alert_state_raw equals: 1 — Normal 2 — Attention 3 — Warning 4 — Alarm A warning or alarm condition indicates that the Health Indicator Alert Type should be examined.
Health Indicator ID	Identifier for the alert.
Health Indicator Timestamp	Time when the alert was generated.
Health Indicator Value	Value for the alert.
Server Instance Name	Host name where DB2 is installed.
Snapshot Timestamp	Time when the query was executed.
Additional Information	Additional information present in the DBM Health Indicator metrics.

DBM Health Information Metrics

The metrics in this category return information from a health snapshot of the DB2 Database Manager.

Default Collection Interval — Every 30 minutes

Table 2-14 DBM Health Information Metrics

Metric	Description and User Action
Server Instance Name (key column)	Host name where DB2 is installed.
Database Start Up Time	Time DB2 was last started.
Database Last Reset Time	Time DB2 was last reset.
Number of Nodes in DB2 Instance	Number of nodes in the DB2 instance.
Rolled Up Alert State Raw	Host name where DB2 is installed.
Rolled Up Alert State	If alert_state_raw equals: 1 — Normal 2 — Attention 3 — Warning 4 — Alarm A warning or alarm condition indicates there are one or more alerts on the DBM.
Server Instance Name	Host name where DB2 is installed.
Snapshot Timestamp	Time when the query was executed.

Tablespaces Health Indicator

The metrics in this category return health indicator information for tablespaces from a health snapshot of tablespaces in a database.

Default Collection Interval — Every 30 minutes

Table 2-15 Tablespaces Health Indicator Metrics

Metric	Description and User Action
Tablespace Name (key column)	Name of the tablespace.
Health Indicator Alert State Raw	Severity of the alert.
Health Indicator Alert State	If alert_state_raw equals: 1 — Normal 2 — Attention 3 — Warning 4 — Alarm
Health Indicator Alert Type	If alert_state_raw equals: 3001 — Tablespace Container State 3002 — Tablespace Container Utilization
Health Indicator ID	Identifier for the alert.
Health Indicator Timestamp	Time when the alert was generated.
Health Indicator Value	Value for the alert.
Snapshot Timestamp	Time when the query was executed.
Additional Information	Additional information present in the Tablespace Health Indicator metrics.

Tablespaces Health Indicator History

The metrics in this category return health indicator information for tablespaces from a health snapshot of tablespaces in a database.

Default Collection Interval — Every 30 minutes

Table 2-16 Tablespaces Health Indicator History Metrics

Metric	Description and User Action
Tablespace Name (key column)	Name of the tablespace.
Rolled Up Alert State Raw	Severity of the alert.
Rolled Up Alert State	If alert_state_raw equals: 1 — Normal 2 — Attention 3 — Warning 4 — Alarm
Snapshot Timestamp	Time when the query was executed.

Monitoring Information

Monitoring Information metrics capture the monitoring information for the database, including general monitoring information, monitored values of the Agent, and monitored values of the database. Monitoring Information metrics consist of the following categories:

General Information
Agent Monitoring
Database Monitoring
Database Backup

Agent Monitoring Metrics

The metrics in this category return information about Agents from an application snapshot.

Default Collection Interval — Every 15 minutes

Table 2-17 Agent Monitoring Metrics

Metric	Description and User Action
Agent CPU Utilization (%)	Total CPU utilization, which is equal to: Agent_total_cpu_time-_Agent_total_cpu_time )/1000)/__interval)*100
Agent Identifier	Unique ID for each Agent.
Agent System CPU Time	Total system time used by DBM for processing by the Agent if it is an application-level snapshot, or by a statement if it is at the statement level.
Agent User CPU Time	Total user time used by DBM for processing by the Agent if it is an application-level snapshot, or by a statement if it is at the statement level.
Application Average Lock Wait Time (ms)	The average waiting time for locks, which equals: lock_wait_time / lock_wait If the average lock wait time is high, you should look for applications that hold many locks, or have lock escalations, with a focus on tuning your applications to improve concurrency, if appropriate. If escalations are causing a high average lock wait time, the values of one or both of the locklist and maxlocks configuration parameters may be too low.
Application Commit SQL Statements Rate	Commit SQL statements reading rate, which equals: commit_sql_stmts - _commit_sql_stmts/ __interval You can set the desired value for the warning and critical thresholds to monitor any adverse conditions.
Application Dynamic SQL Statements Rate	Dynamic SQL statements reading rate, which equals: dynamic_sql_stmts - _dynamic_sql_stmts/ __interval You can set the desired value for the warning and critical thresholds to monitor any adverse conditions.
Application Failed SQL Statements Rate	Failed SQL statements reading rate, which equals: failed_sql_stmts - _failed_sql_stmts/ __interval You can set the desired value for the warning and critical thresholds to monitor any adverse conditions.
Application Identifier	Unique ID for each application.
Application Idle Time	Time spent idle for an application.
Application Name	Name of the application.
Application Rollback SQL Statements Rate	Rollback SQL statements reading rate, which equals: rollback_sql_stmts - _rollback_sql_stmts/ __interval You can set the desired value for the warning and critical thresholds to monitor any adverse conditions.
Application Row Reading Rate	Rows reading rate in the last interval, which equals: rows_read - rows_read)/__interval You can set the desired value for the warning and critical thresholds to monitor any adverse conditions.
Application Row Writing Rate	Rows writing rate in the last interval, which equals: rows_written - rows_written)/__interval You can set the desired value for the warning and critical thresholds to monitor any adverse conditions.
Application Static SQL Statements Rate	Static SQL statements reading rate, which equals: static_sql_stmts - _static_sql_stmts/ __interval You can set the desired value for the warning and critical thresholds to monitor any adverse conditions.
Application Priority	Priority of Agents working for this application.
Application Status	Status of the application corresponding to the value of application_status_raw.
Authorization ID	Authorization ID of the user who invoked the application being monitored. On a DDCS gateway node, this is the user's authorization ID on the host.
Average Sort Time per Sort	Average sort time per sort for the statement, which equals: stmt_sorts/total_sort_time
Client Database Alias	Alias of the database provided by the application to connect to the database.
Client Node Number	client_nname in the database manager configuration file at the client node.
Commit SQL Statements	Number of commit SQL statements.
Coordinator Agent Process Identifier	Process ID (UNIX systems) or thread ID (Windows systems) of the coordinator Agent for the application.
Current Agents Waiting on Locks	Number of applications waiting for a lock held by other applications.
Dynamic SQL Statements	Number of dynamic SQL statements.
Exclusive Lock Escalations	Number of exclusive lock escalations.
Execution Elapsed Time	Sum of the host execution times (in milliseconds) for all the statements that were executed for a particular application.
Execution Identifier	ID that the user specified when logging in to the operating system. This ID is distinct from the Authorization ID, which the user specifies when connecting to the database.
Failed SQL Statements	Number of failed SQL statements.
Host CPU Usage Per Sec (%)	Ratio of CPU time utilized in the last interval, which equals: elapsed_exec_time_ms - elapsed_exec_time_ms / __interval You can set the desired value for the warning and critical thresholds to monitor any adverse conditions.
Lock Timeouts	Number of lock timeouts for the application.
Lock Escalations	Number of lock escalations.
Number of Deadlocks	Total number of deadlocks that have occurred.
Number of Lock Waits	Number of times the application waited for locks.
Number of Locks Currently Held	Number of locks currently held by an application.
Number of Rows Read	Total number of rows read.
Number of Rows Written	Total number of rows written.
Number of Sorts	Number of sorts performed by the statement.
Prefetch Wait Time	IO wait time.
Rows Read	Number of rows read.
Rows Written	Number of rows written.
Rollback SQL Statements	Number of rollback SQL statements.
Start Time	Start time of the statement.
Statement Operation	Statement operation value.
Statement System CPU Time	Total system time used by DBM for processing by the Agent/statement.
Statement User CPU Time	Total user time used by DBM for processing by the Agent/statement.
Statement Text	Whole query or the statement executed.
Statement Type	Number of requests to perform a direct write of one or more sectors of data.
Statement User CPU Time	Total user time DBM used for processing by the Agent/statement.
Static SQL Statements	Number of static SQL statements.
Time Waited on Locks	Total time the application waited for locks.
Total Sorts	Total number of sorts.
Total Sort Time (ms)	Total time used for sorting.
Total CPU Time	Total CPU time, which equals: stmt_usr_cpu_time + stmt_sys_cpu_time
Total CPU Time Used by Agent	Total CPU time, which equals: agent_usr_cpu_time + agent_sys_cpu_time

Database Monitoring Metrics

The metrics in this category return snapshot information from the database and detail_log logical data groups.

Default Collection Interval — Every 15 minutes

Table 2-18 Database Monitoring Metrics

Metric	Description
Database Name (key column)	Real name of the database for which information is collected or to which the application is connected. This is the name the database was given when created.
Allocated Database Size (Bytes)	Capacity of the database. (Not available in partitioned databases.)
Application Average Lock Wait Time (ms)	Average waiting time for locks, which equals: lock_wait_time/lock_wait High wait for an application can mean that the application is degrading performance.
Commit SQL Statements	Number of applications waiting for a lock on an object in the database. Number of commit SQL statements.
Current Agents Waiting on Locks	Number of applications waiting for a lock on an object in the database.
Database Commit SQL Statements Rate	Commit SQL statement reading rate, which equals: commit_sql_stmts - _commit_sql_stmts/ __interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Database Connection Time	Last time the database was connected.
Database Disconnection Time	Last disconnection time for the database.
Database Dynamic SQL Statements Rate	Dynamic SQL statement reading rate, which equals: dynamic_sql_stmts - _dynamic_sql_stmts/ __interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Database Failed SQL Statements Rate	Failed SQL statement reading rate, which equals: failed_sql_stmts - _failed_sql_stmts/ __interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Database Location	Location of the database. Local — if db_location_raw = 0 Remote — if db_location_raw = 1
Database Location Raw	Location of the database (local or remote).
Database Path	Physical disk location of the database.
Database Rollback SQL Statements Rate	Rollback SQL statement reading rate, which equals: rollback_sql_stmts - _rollback_sql_stmts/ __interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Database Size	Size of the database in bytes.
Database Space Utilization (%)	Total percentage space utilization in the database, which equals: (db_size/db_capacity) *100
Database Static SQL Statements Rate	Static SQL statement reading rate, which equals: static_sql_stmts - _static_sql_stmts/ __interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Database Status	Status of the database.
Deadlocks Rate	Rate of deadlocks, which equals: (deadlocks-_deadlocks)/_interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Dynamic SQL Statements	Number of dynamic SQL statements.
Exclusive Lock Escalation Rate	Rate of exclusive lock escalations, which equals: (x_lock_escals-_x_lock_escals)/__interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Exclusive Lock Escalations	Number of exclusive lock escalations.
Failed SQL Statements	Number of failed SQL statements.
Instance ID	Name of the database manager instance for which the snapshot was taken.
Internal Deadlock Rollback Rate	Rate of internal deadlock rollbacks, which equals: (int_deadlock_rollbacks-_int_deadlock_rollbacks) /__interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Lock Escalations	Number of lock timeouts for the application.
Lock Escalation Rate	Rate of lock escalations, which equals: (lock_escals-_lock_escals)/__interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Lock Timeouts	Number of lock escalations.
Locks Timeout Rate	Rate of lock timeouts. The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Number of Current Locks Held	Number of locks currently held by an application.
Number of Currently Active Connections	Total number of active connections in the database.
Number of Currently Connected Applications	Total number of currently connected applications.
Number of Deadlocks	Total number of deadlocks that have occurred.
Number of Internal Rollbacks	Total number of internal deadlock rollbacks.
Number of Lock Waits	Number of times the application waited for locks.
Percentage Applications Waiting on Locks	Ratio of applications waiting on locks, which equals: (locks_waiting /appls_cur_cons)*100 If a large number of applications are waiting on locks, this indicates a possible performance degradation.
Rollback SQL Statements	Number of rollback SQL statements.
Static SQL Statements	Number of static SQL statements.
Time Waited on Locks	Total time the application waited for locks.
Total Locklist Memory in Use	Total lock list memory in use.

Database Backup Metrics

The metrics in this category provide information regarding the last database backup.

Default Collection Interval — Every 2 hours

Table 2-19 Database Backup Metrics

Metric	Description
Database Name (key column)	Real name of the database for which information is collected or to which the application is connected. This is the name the database was given when created.
Instance ID	Name of the database manager instance for which the snapshot was taken.
Database Last Backup	Last backup of the database.

General Information Metrics

The metrics in this category provide basic information about the status of the databases and some of the important configuration values.

Default Collection Interval — Every 15 minutes

Table 2-20 General Information Metrics

Metric	Description and User Action
DB2 Start Time	Date and time that the database manager was started using the db2start command.
DB Status Value	Status of the DB2 instance.
Agents Registered	Number of Agents registered in the DBM instance that is being monitored.
Communication Private Memory	Amount of communication private memory.
Sort Heap Allocated	Amount of memory allocated to sort heap.
Sort Heap Threshold	Maximum number of private memory pages to be used for private sorts, or the maximum number of shared memory pages to be used for shared sorts. If the sort is a private sort, this parameter affects Agent private memory. If the sort is a shared sort, this parameter affects the database shared memory. Each sort has a separate sort heap that is allocated as needed by the Database Manager. This sort heap is the area where data is sorted. If directed by the optimizer, a smaller sort heap than the one specified by this metric is allocated using information provided by the optimizer.
DB2 Status	Status of the DB2 instance. If DB2 status equals: 0 — Active 1 — Quiesce Pending 2 — Quiesced
Sort Heap Utilization	Sort heap utilization, which equals: sort_heap_allocated / sortheap_threshold *100 Increase the value of the configuration parameter, sheapthres.

Performance

Performance metrics provide information regarding the performance at various snapshot levels. Performance metrics consist of the following categories:

Memory Manager
Sort Heap
Bufferpool Database Performance
Bufferpool Performance
Cache Statistics
Agent Performance
Log IO Performance
Non-Buffered IO Activity

Agent Performance Metrics

The metrics in this category provide performance metrics for the Agent at the application snapshot level.

Default Collection Interval — Every 15 minutes

Table 2-21 Agent Performance Metrics

Metric	Description and User Action
Database Name (key column)	Real name of the database for which information is collected or to which the application is connected. This is the name the database was given when created.
Cleans for Steals	Number of times a page cleaner was invoked because a synchronous write was needed during the victim buffer replacement for the database.
Cleans for Threshold	Number of times a page cleaner was invoked because a buffer pool had reached the dirty page threshold criterion for the database.

Bufferpool Database Performance Metrics

The metrics in this category provide performance metrics for all the bufferpools in the database.

Default Collection Interval — Every 15 minutes

Table 2-22 Bufferpool Database Performance Metrics

Metric	Description and User Action
Database Name (key column)	Real name of the database for which information is collected or to which the application is connected. This is the name the database was given when created.
Average Data Write Rate	Pool data write rate, which equals: (pool_data_writes/pool_write_time)
Average Index Write Rate	Pool index write rate, which equals: (pool_index_writes/pool_write_time)
Average Page Read Rate	The rate equals: (pool_data_p_reads + pool_index_p_reads )/pool_read_time
Average Page Write Rate	The rate equals: (pool_data_writes + pool_index_writes)/pool_write_time
Database Buffer Pool Hit Ratio (%)	The ratio equals: (1-((pool_data_p_reads + pool_index_p_reads)/ (pool_index_l_reads + pool_index_l_reads )))*100 The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Logical Data Read Rate	The rate equals: (pool_data_l_reads /pool_read_time)
Logical Index Read Rate	The rate equals: (pool_index_l_reads /pool_read_time)
Physical Index Read Rate	The rate equals: (pool_index_p_reads/pool_read_time)
Physical Index Read Rate	The rate equals: pool_data_p_reads/pool_read_time
Pool Logical Data Reads	This count includes accesses to data that is already in the buffer pool when the database manager needs to process the page and read into the buffer pool before the database manager can process the page.
Pool Logical Index Reads	Number of logical read requests to get index pages into the buffer pool.
Pool Physical Data Reads	Number of read requests that required I/O to get data pages into the buffer pool.
Pool Physical Index Reads	Number of physical read requests to get index pages into the buffer pool.
Pool Asynchronous Data Reads	Number of data pages read asynchronously to the buffer pool by prefetchers.
Pool Asynchronous Data Writes	Number of times a buffer pool data page was physically written to disk by either an asynchronous page cleaner or a prefetcher.
Pool Asynchronous Index Reads	Number of index pages read asynchronously to the buffer poll by prefetchers.
Pool Asynchronous Index Writes	Number of times a buffer pool index page was physically written to disk by either an asynchronous page cleaner or a prefetcher.
Pool Asynchronous Read Time	Number of times a buffer pool data page was physically read from disk by an asynchronous page prefetcher.
Pool Asynchronous Write Time (ms)	Number of times a buffer pool index page was physically written to disk by either an asynchronous page cleaner or prefetcher.
Pool Data Writes	Number of times the buffer pool data page was physically written to the disk.
Pool Index Writes	Number of times the buffer pool index page was physically written to the disk.
Pool Logical Data Reads	This count includes accesses to data that is already in the buffer pool when the database manager needs to process the page and read into the buffer pool before the database manager can process the page.
Pool Logical Index Reads	Indicates the number of logical read requests to get index pages into the buffer pool.
Pool Physical Index Reads	Indicates the number of physical read requests to get index pages into the buffer pool.
Pool Physical Data Reads	Number of read requests that required I/O to get data pages into the buffer pool.
Pool Read Time (ms)	Provides the total amount of elapsed time spent processing read requests that caused data or index pages to be physically read from disk to buffer pool.
Pool Write Time (ms)	Total amount of time spent physically writing data or index pages from the buffer pool to disk.
Synchronous Data Read Rate	Total synchronous read rate, which equals: ((pool_read_time-pool_async_read_time == 0) ? 0 :((pool_data_p_ reads-pool_async_data_reads )/(pool_read_time-pool_async_read_ time)))
Synchronous Data Write Rate	Pool data synchronous write rate, which equals: ((pool_data_writes - pool_async_data_writes )/(pool_write_time-pool_async_write_time))
Synchronous Index Read Rate	Index synchronous read rate, which equals: (pool_data_p_reads-pool_async_index_reads )/(pool_read_time-pool_async_read_time)
Synchronous Index Write Rate	Index synchronous write rate, which equals: ((pool_index_writes - pool_async_index_writes )/(pool_write_time-pool_async_write_time))

Bufferpool Performance Metrics

The metrics in this category provide performance metrics for the individual bufferpools in the database.

Default Collection Interval — Every 15 minutes

Table 2-23 Bufferpool Performance Metrics

Metric	Description and User Action
Buffer Pool Name (key column)	Name of the bufferpool.
Database Buffer Pool Hit Ratio (%)	Buffer pool hit ratio, which equals: (1-((pool_data_p_reads + pool_index_p_reads)/ (pool_index_l_reads + pool_index_l_reads )))*100) The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Database Name	Real name of the database for which information is collected or to which the application is connected. This is the name the database was given when created.
Database Alias	Alias for the database.
Database Path	Physical location of the database.
Pool Asynchronous Data Reads	Number of data pages read asynchronously to the buffer poll by prefetchers.
Pool Asynchronous Data Writes	Number of times a buffer pool data page was physically written to disk by either an asynchronous page cleaner or a prefetcher.
Pool Asynchronous Index Reads	Number of index pages read asynchronously to the buffer poll by prefetchers.
Pool Asynchronous Index Writes	Number of times a buffer pool index page was physically written to disk by either an asynchronous page cleaner or prefetcher.
Pool Asynchronous Read Time (ms)	Number of times a buffer pool data page was physically read from disk by an asynchronous page prefetcher.
Pool Asynchronous Write Time (ms)	Number of times a buffer pool index page was physically written to disk by either an asynchronous page cleaner or prefetcher.
Pool Data Writes	Number of times the buffer pool data page was physically written to the disk.
Pool Index Writes	Number of times the buffer pool index page was physically written to the disk.
Pool Logical Data Reads	This count includes accesses to data that is already in the buffer pool when the database manager needs to process the page and read into the buffer pool before the database manager can process the page.
Pool Logical Index Reads	Indicates the number of logical read requests to put index pages into the buffer pool.
Pool Physical Index Reads	Indicates the number of physical read requests to put index pages into the buffer pool.
Pool Physical Data Reads	Number of read requests that required I/O to put data pages into the buffer pool.
Pool Read Time (ms)	Provides the total amount of elapsed time spent processing read requests that caused data or index pages to be physically read from the disk to the buffer pool.
Pool Write Time (ms)	Total amount of time spent physically writing data or index pages from the buffer pool to the disk.

Cache Statistics Metrics

The metrics in this category provide performance information for the package and the catalog cache of the database.

Default Collection Interval — Every 15 minutes

Table 2-24 Cache Statistics Metrics

Metric	Description and User Action
Database Name (key column)	Real name of the database for which information is collected or to which the application is connected. This is the name the database was given when created.
Catalog Cache Hit Ratio (%)	Catalog cache hit ratio, which equals: 1-(cat_cache_inserts /cat_cache_lookups))*100 The hit ratio is a percentage indicating how well the catalog cache is helping to avoid actual accesses to the catalog on disk. A high ratio indicates it is successful in avoiding actual disk I/O accesses.
Catalog Cache Inserts	Number of inserts performed. The hit ratio is 1-(CCI/CCL).
Catalog Cache Lookups	Number of times the catalog cache was referenced to obtain table description information.
Catalog Cache Overflows	Number of times that the catalog cache overflowed the bounds of its allocated memory.
Package Cache Hit Ratio (%)	Package cache hit ratio, which equals: 1-(pkg_cache_inserts /pkg_cache_lookups))*100 The hit ratio is a percentage indicating how well the package cache is helping to avoid reloading packages and sections for static SQL from the system catalogs as well as helping to avoid recompiling dynamic SQL statements. A high ratio indicates it is successful in avoiding these activities.
Package Cache Inserts	Number of inserts performed. The hit ratio is 1-(PCI/PCL).
Package Cache Lookups	Number of times the package cache was referenced to obtain a section or a package.
Package Cache Max Used (Bytes)	Largest size reached by the package cache.
Package Cache Overflows	Number of times that the package cache overflowed the bounds of its allocated memory.

Log I/O Performance Metrics

The metrics in this category provide performance information for the log input and output including the number of reads and writes in the logs.

Default Collection Interval — Every 15 minutes

Table 2-25 Log I/O Performance Metrics

Metric	Description
Database Name (key column)	Real name of the database for which information is collected or to which the application is connected. This is the name the database was given when created.
Cleans Logging Threshold	Number of times a page cleaner was invoked because the logging space used had reached a predefined criterion for the database.
Log Reads	Number of log reads.
Log Writes	Number of log writes.

Memory Manager Metrics

The metrics in this category provide the values of the workspace provided and the locklist set in the database.

Default Collection Interval — Every 15 minutes

Table 2-26 Memory Manager Performance Metrics

Metric	Description
Database Name (key column)	Real name of the database for which information is collected or to which the application is connected. This is the name the database was given when created.
Private Workspace Max Used	Largest size that can be reached by private workspace.
Shared Workspace Max Used	Largest size that can be reached by shared workspace.
Total Locklist Memory in Use	Total amount of lock list memory that is in use.

Sort Heap Metrics

The metrics in this category display the various performance values associated with the sortheap.

Default Collection Interval — Every 15 minutes

Table 2-27 Sort Heap Performance Metrics

Metric	Description and User Action
Database Name (key column)	Real name of the database for which information is collected or to which the application is connected. This is the name the database was given when created.
Active Sorts	Number of sorts in the database that currently have an allocated sort heap.
Average Active Sorts Rate	Rate of active sorts in the last interval, which equals: (active_sorts-_active_sorts )/__interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Average Hash Join Overflow Rate	Rate of hash join overflow in the last interval, which equals: (hash_join_overflow-_hash_join_overflow) /__interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Average Hash Join Rate	Rate of hash joins in the last interval, which equals: (total_hash_joins-_total_hash_joins )/__interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Average Hash Join Small Overflow Rate	Rate of the small hash join overflow in the last interval, which equals: (hash_join_small_overflow-_hash_join_small_overflow )/__interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Average Hash Loops Rate	Rate of hash loops in the last interval, which equals: (total_hash_loops-_total_hash_loops)/ __interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Average Piped Sorts Rejected Rate	Rate of piped sorts rejection in the last interval, which equals: ((piped_sorts_requested-piped_sorts_accepted)-(_piped_sorts_requested-_piped_sorts_accepted)) /__interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Average Post Threshold Joins Rate	Rate of post threshold joins in the last interval, which equals: (post_threshold_ hash_joins-_post_threshold _hash_joins)/__interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Average Post Threshold Sorts Rate	Rate of post threshold sorts in the last interval, which equals: (post_threshold_sorts-_post_threshold_sorts ) /__interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Average Sort Heap Pages Used	Average sort heap space used, which equals: (sort_heap_allocated /active_sorts) The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Average Sort Time (ms)	Average time per sort, which equals: (total_sort_time/total_sorts) The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Average Sorts Overflow Rate	Rate of sort overflow in the last interval, which equals: (sort_overflow-_sort_overflow )/__interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Average Sorts Rate	Rate of sorts in the last interval, which equals: (total_sorts-_total_sorts )/__interval The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Piped Sorts Accepted	Number of piped sorts that have been accepted.
Piped Sorts Requested	Number of piped sorts that have been requested.
Post Threshold Hash Sorts	Total number of times that a hash join heap request was limited due to concurrent use of shared or private sort heap space.
Post Threshold Sorts	Number of sorts that have requested heaps after the sort heap threshold has been exceeded.
Sort Overflows	Total number of sorts than ran out of sort heap and may have required disk space for temporary storage.
Sorts Overflow Rate	Sorts overflow ratio, which equals: ((sort_overflow/total_sorts )*100) The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Total Hash Join Overflows	Number of times that hash join data exceeded the available sort heap space.
Total Hash Join Small Overflow	Number of times that hash join data exceeded the available sort heap space by less than 10%.
Total Hash Joins	Total number of hash joins executed.
Total Hash Loops	Total number of hash loops executed.
Total Sort Heap Allocated	Total number of allocated pages of sort heap space for all sorts at the level chosen and at the time the snapshot was taken.
Total Sorts	Number of sorts that have been executed.
Total Sort Time (ms)	Time spent in sorts.

Non-Buffered I/O Activity Metrics

The metrics in this category display the various performance values related to the non-buffered I/O activities that do not use the buffer pool.

Default Collection Interval — Every 15 minutes

Table 2-28 Non-Buffered I/O Activity Metrics

Metric	Description
Database Name (key column)	Real name of the database for which information is collected or to which the application is connected. This is the name the database was given when created.
Average Data Read Rate	Direct read rate, which equals: direct_reads/direct_read_time The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Average Data Write Rate	Direct write rate, which equals: direct_writes/direct_write_time The desired value can be set for the warning and critical thresholds to monitor any adverse conditions.
Direct Read Requests	Number of requests to perform a direct read of one of more sectors of data.
Direct Read Time (ms)	Elapsed time in milliseconds required to perform the direct reads.
Direct Reads	Number of read operations that do not use the buffer pool.
Direct Write Requests	Number of requests to perform a direct write of one or more sectors of data.
Direct Write Time (ms)	Elapsed time in milliseconds required to perform the direct writes.
Direct Writes	Number of write operations that do not use the buffer pool.

Response Metrics

The metrics in this category provide information about the response of the IBM DB2 database in the instance.

Default Collection Interval — Every 5 minutes

Table 2-29 Response Metrics

Metric	Description
Database Name	Name of the database.
DB Status	Status of the database: 0 — Active 1 — Quiesce pending 2 — Quiesced 3 — Roll forward
DB Status Value	Status value of the database.
DB2 Status	Status value of the DB2 instance.
DB2 Status Value	Status of the DB2 instance: 0 — Active 1 — Quiesce pending 2 — Quiesced
Name	Database host name.
Status	Status of the database. The database is up if the status is 0. Otherwise, it is down.

Storage Information

Storage Information metrics provide information about the storage objects, such as the tablespace and data files. Storage Information metrics consist of the following categories:

Log Storage
Tablespace
Data Files

Data Files Storage Metrics

The metrics in this category provide information about the file properties for the database data storage files.

Default Collection Interval — Every 2 hours

Table 2-30 Tablespace Storage Metrics

Metric	Description
Data File Identifier (key column)	Unique identifier for the data file.
Table Name	Name of the particular table in the database where the file resides.
Table Schema	Schema of the table in which the file resides.
Table Type	Type of table to which the file belongs.
Page Reorganizations	Number of page reorganizations.
Overflow Accesses	Number of overflow accesses.

Log Storage Metrics

The metrics in this category provide information about the log storage properties for the database.

Default Collection Interval — Every 30 minutes

Table 2-31 Log Storage Metrics

Metric	Description and User Action
Database Name (key column)	Real name of the database for which information is collected or to which the application is connected. This is the name the database was given when created.
Allocated Secondary Log Size	Allocated size of the secondary log.
Log Space Utilization	Space utilization of log files.
Total Log Available	Total number of pages available for logging.
Total Log Space Used	Total number of pages used for logging.

Tablespace Storage Metrics

The metrics in this category provide information about the individual tablespace properties for all database tablespaces.

Default Collection Interval — Every 15 minutes

Table 2-32 Tablespace Storage Metrics

Metric	Description
Tablespace Identifier (key column)	Identifier for the tablespace.
Tablespace Name (key column)	Name of the tablespace.
Bufferpool Identifier	Bufferpool identifier for the tablespace.
Extent Size	Extent size for the tablespace.
Number of Containers	Number of containers.
Number of Ranges	Number of ranges.
Page Size	Page size for the tablespace.
Prefetch Size	Prefetch size for the tablespace.
Tablespace Free Pages	Number of pages in a tablespace that will become free if all pending transactions are committed or rolled back, and new space is requested for an object.
Tablespace State	State of the tablespace.
Tablespace Total Pages	Total number of pages in a tablespace.
Tablespace Type	Type of tablespace.
Tablespace Usable Pages	Total number of pages in a tablespace minus overhead pages.
Tablespace Used Pages	Total number of pages currently used (not free) in a tablespace.
Tablespace Utilization (%)	Tablespace utilization in percentage.

System Configuration Information

System Configuration Information metrics collect the information related to the database software. Each installation of the database software provides an instance to store the data. System Configuration Information metrics consist of the following categories:

Database System Information
Product Information
Partition Information
Instance Information
Registry Settings

Database System Information Metrics

The metrics in this category provide information about the various system configuration metrics for the database system, including the name and operating system properties.

Table Name — MGMT_EMX_IBMDB2_DBSYS
View Name — MGMT_EMX_IBMDB2_DBSYS_VIEW

Default Collection Interval — Every 24 hours

Table 2-33 Database System Information Metrics

Metric	Description
Server Name	Name of the database server.
OS Name	Name of the operating system.
OS Version	Version of the operating system.
OS Release	Release of the operating system.
Total Number of CPUs	Total number of CPUs for the operating system on which the database is installed.
Total Number of Configured CPUs	Total number of configured CPUs on which the database is installed.
Total Memory (mb)	Amount of memory.

Instance Information Metrics

The metrics in this category return the parameters that provide information about database instances.

Table Name — MGMT_EMX_IBMDB2_DBINST
View Name — MGMT_EMX_IBMDB2_DBINST_VIEW

Default Collection Interval — Every 24 hours

Table 2-34 Instance Information Metrics

Metric	Description
Instance Name (key column)	Name of the instance.
Number of DB Partitions	Number of database partitions.
Bit Size of Current Instance	Bit size of the current instance (32 or 64).
Release Number	Internal release number, as returned by the db2level command; 9 for example, 03030106.
Service Level	Service level, as returned by the db2level command; for example, DB2 v8.1.1.80.
Build Level	Build level, as returned by the db2level command; for example, n041021.
Program Temporary Fix	Program temporary fix (PTF) identifier, as returned by the db2level command; for example, U498350.
Fix Pack Number	FixPak number, as returned by the db2level command.

Product Information Metrics

The metrics in this category provide information about the installed IBM DB2 database product.

Table Name — MGMT_EMX_IBMDB2_DBPRO
View Name — MGMT_EMX_IBMDB2_DBPRO_VIEW

Default Collection Interval — Every 24 hours

Table 2-35 Product Information Metrics

Metric	Description
Database Path	Installation path of the database.
Product	Installed product.
Version	Version of the installed product.

Partition Information Metrics

The metrics in this category return parameters about parallel operations and partitioned database environments.

Table Name — MGMT_EMX_IBMDB2_DBPART
View Name — MGMT_EMX_IBMDB2_DBPART_VIEW

Default Collection Interval — Every 24 hours

Table 2-36 Partition Information Metrics

Metric	Description
Partition Number (key column)	Partition number where the database is installed.
Host Name	Host name of the machine where the db2 database software is installed.
Port Number	TCP/IP port number to communicate with the database.
Switch Name	Name of the switch where the database is connected.

Registry Settings Metrics

The metrics in this category provide information about the various registry parameters for the database.

Table Name — MGMT_EMX_IBMDB2_DBREGSET
View Name — MGMT_EMX_IBMDB2_DBREGSET_VIEW

Default Collection Interval — Every 24 hours

Table 2-37 Registry Settings Metrics

Metric	Description
Database Registry Variable (key column)	Name of the DB2 registry variable.
Database Registry Value	Current setting of the DB2 registry variable.
Is Aggregate	Indicates whether or not the DB2 registry variable is an aggregate variable. Possible return values are 0 if it is not an aggregate variable, and 1 if it is an aggregate variable.
Aggregate Type	Name of the aggregate if the DB2 registry variable is currently getting its value from a configured aggregate. If the registry variable is not being set through an aggregate, or is set through an aggregate but has been overridden, the value of AGGREGATE_NAME is NULL.
Level Value	Level at which the DB2 registry variable acquires its value. Possible return values and the corresponding levels that they represent are I, G, N, or E.
Level	Values are: Instance — If level1_raw = I Global — If level1_raw = G Database Partition — If level1_raw = N Otherwise, the value is Environment.

DB2 Diag Log File Monitoring Metrics

The metrics in this category provide information about the IBM DB2 database Diagnostic Log file.

Note:

This metric category is supported only for local monitoring, that is, when the IBM DB2 database on a host is monitored by an Oracle Management Agent that is running on the same host.

Default Collection Interval — Every 5 minutes

Table 2-38 DB2 Diag Log File Monitoring Metrics

Metric	Description
Log File Match Count	Nmber of times a pattern was found in the log file.
Server	Name of the server where IBM DB2 is running.
Instance	Name of the IBM DB2 instance.
DB	Name of the IBM DB2 database.
Function	Name of the function present in the last log entry.
Last Occurrence Time Stamp	Time of the last log entry that shares a common function name with other entries that satisfy a particular pattern.
Message	Message present in the log file.