Monitoring Metrics

You can use the IBM® Db2® Intelligence Center console for database monitoring and also effectively monitor your database performance by using one or more of the key performance indicators, which are known as metrics. The console provides the following metric types for monitoring the performance of your database.

Database Throughput

This metric monitors the query performance by measuring the number of statements that are processed and the number of rows that are read from the table. The statements contain the activities that are completed with errors and the activities completed successfully within a certain period. This count of rows read is not the number of rows that were returned to the calling application. Rather, it is the number of rows that were read to return the result set. Also, this count does not include any index accesses. This metric summary represents database throughput by quantifying the statements and rows that are read in two aspects: an average number per minute and time series for an average.

Database Resource Usage

This metric monitors the database resource usage by measuring the CPU usage, memory usage, logspace usage, and storage usage. This metric summary represents the database resource usage by two aspects: average/max/latest number and time series number.

Database Availability

This metric indicates whether the database is up or down. This metric summary represents the historical available time in percentage.

Database Responsiveness

This metric indicates whether the system is responding well to the incoming requests.

Database Contention

This metric indicates any contention between connections.

Database Time Spent

This metric indicates the percentage of time that is taken for database calls.

Units of Work

This metric indicates what transactions (units of work) are consuming the most resources in the data server.

Connections

Displays all kinds of network connections to the console.

Inflight Statements

Displays the SQL statement details for running processes.

Table Storage

Displays the storage usage data of each table or each schema.

Table Performance

Displays the performance data of each table or each schema.

Package Cache

Displays the SQL ran in the console.

WLM Workload Summary

Accumulates all metrics for requests that connections that are mapped to the identified workload objects submit.

WLM Services Class Summary

Represents the accumulation of all metrics for requests that are ran under the indicated service subclass.

Individual Execution

Displays the details of ran SQL statements as system activity.

Blocking and Waiting Connections

Displays the blocker and waiter pair in the console.

Locked Objects with Waiting Connections

Displays the detailed data of the locked process and information of the process that blocked it.

Partition Summary

Displays the information for each data partition that is used by a database.

Database Partitions

Displays charts for CPU , Sort , I/O for each database partition.

Stored Procedures

Displays the aggregated execution metrics for procedures, external procedures, compiled functions, external functions, compiled triggers, and anonymous blocks started since database activation.

Top Consumers

Displays the top consumers of the system resources.

Connection Summary

Displays a summary of all connections that are established to the console.

Operating System Time Spent

Displays the time that is spent for each activity that is performed by an operating system of the database.

Partition Skew

Displays the information for each data partition that is used by dpf database.

Locking Event Monitor

Displays the blocker and waiter pair in the system.

Buffer Pools

Displays the usage of Db2 Buffer Pools and Table Spaces. A directory server uses the Db2 buffer pools to store cached data and to improve database performance. A single database is associated with a buffer pool, and more than one table space can use it. Adequate buffer pool size is essential for good database performance because it reduces the disk I/O, which uses a considerable amount of time.

Utilities Event Monitors

Displays the all kinds of utilities that are used by the database system.

Connection Lock Statistics

Displays the locking activities in the console system.

Find Locked Objects

Displays the detailed information of locked operations.