Introduction


DB2 9.7 provides many SQL interfaces for monitoring. It also provides textual monitoring reports that give an overview of the system. This tutorial will focus on the SQL interfaces for monitoring.

This tutorial will troubleshoot an SQL compilation problem in an application. This scenario illustrates the use of monitoring information to troubleshoot a slowdown in response times that has been reported on a production system. This scenario starts when the database administrator receives a report of a slowdown problem. At the end of this scenario, there is enough known about the problem to work on fixing it.

Problem to diagnose


The following problem is used in this example: The SALES_CHECKOUTAPPLICATION is slowed down due to spending more time in SQL compilation processing.

Troubleshooting this problem is considered complete once the database administrator has found the answers to the following questions:



Tutorial flow