Performance data generation and online monitoring
DB2® generates trace data about its own performance and events in Db2 subsystems However, Db2 does not provide any reporting facilities for analyzing this data. The Online Monitor provides you with the capability to view an active Db2 subsystem and identify performance problems online.
The Online Monitor displays subsystem-wide performance information, such as processor times, buffer pool usage, locking, log, and I/O activity. For an individual thread, the Online Monitor displays information such as the elapsed time, the time spent in Db2, the time it was suspended, the read and write activity involved, the locks obtained, and the SQL statements executed.
- Determine total Db2 system performance and efficiency
- Measure an application’s performance and resource use
- Evaluate an application’s effect on other applications and the system
- Analyze and improve SQL statements
- Identify potential problems
- Determine tuning requirements for Db2.
When changes are made to an application or to the Db2 subsystem, the Online Monitor can help you determine the effects. This is very important for determining whether the changes increased or decreased performance.
When Db2 performance is not satisfactory, the Online Monitor can help you identify areas where tuning is required to optimize the performance of Db2. The Online Monitor can log Db2 activities and events and provide this information for later viewing to assist you in determining the cause of potential problems.
For a long-term view of Db2 performance, your needs are best served by the batch reporting capabilities.