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.
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: