Monitoring Metrics
You can use the IBM® Db2® Data Management Console console for database monitoring and also effectively monitor your database performance by using one or more of the key performance indicators, 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 processed and the number of rows read from the table. The statements contain the activities 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 in order to return the result set. Additionally, this count does not include any index accesses. This metric summary represents database throughput by quantifying the statements and rows 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, log space 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 whether there is 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 executed in console.
WLM Workload Summary
This metric represents the accumulation of all metrics for requests that were submitted by connections mapped to the identified workload objects.
WLM Services Class Summary
This metric represents the accumulation of all metrics for requests that have executed under the indicated service subclass.
Individual Execution
Displays the details of executed 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 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 invoked since database activation.
Top Consumers
Displays the top consumers of the system resources.
Connection Summary
Displays a summary of all connections established to the console.
Operating System Time Spent
Displays the time spent for each activity performed by an operating system of the database.
Partition Skew
Displays the information for each data partition used by dpf database.
Locking Event Monitor
Displays the blocker and waiter pair in 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 buffer pool is associated with a single database and can be used by more than one table space. 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 used by the database system.
Connection Lock Statistics
Displays the locking activities in console system.
Find Locked Objects
Displays the detailed information of locked operations.