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 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
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. |
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 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
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
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. |
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
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. |
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) |
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. |
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 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
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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 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
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 |
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. |
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. |
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 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
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. |
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)) |
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. |
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. |
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. |
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. |
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. |
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. |
The metrics in this category provide information about the response of the IBM DB2 database in the instance.
Default Collection Interval — Every 5 minutes
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 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
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. |
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. |
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 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
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. |
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. |
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
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. |
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. |
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. |