Monitoring performance
Proactive performance monitoring is a key element of maintaining the health of your database management system.
- Monitoring system resources by using RMF
You can monitor system resources to detect constraints for processor, I/O, and storage resources. - Monitoring transaction manager throughput
You can use IMS™ or CICS® monitoring facilities to determine throughput, in terms of transactions processed, and transaction response times. - Monitoring I/O and storage
You can monitor to the use of real and virtual storage by DB2. - Monitoring catalog statistics
You can improve access path selection for SQL statements by monitoring the health of statistics for database objects. The health of these statistics is of critical importance for efficient access paths for SQL statements. - Monitoring concurrency and locks
You can monitor the use of locks to improve concurrency and prevent problems such as contention, suspensions, timeouts, or deadlocks. - Monitoring SQL performance
You can monitor the performance of the SQL statements that are run by your application programs. - Monitoring parallel operations
You can monitor the use of parallelism by DB2. - Monitoring DB2 in distributed environments
You can use DISPLAY commands and the trace facility to obtain information. DB2 can also return server-elapsed time to certain types of client applications. - Monitoring use of IBM specialty engines
You can use various facilities to monitor how DB2 uses IBM® Z Integrated Information Processor (zIIP) and IBM Z Application Assist Processor (zAAP). - Checking for invalid packages
You can create a query to check for plans and packages that have become invalid or inoperative. - Using profiles to monitor and optimize DB2 for z/OS subsystems
Profile tables enable you to monitor the use of system resources, control performance-related subsystem parameters in particular contexts on your DB2 subsystem. Each monitored context is defined by a set of criteria called a profile.
Parent topic: Monitoring and analyzing DB2 performance data
Related tasks: