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.

The tutorial illustrates the use of monitoring information to troubleshoot a slowdown in response times that has been reported on a production system. At the end of this scenario, there is enough known about the problem to work on fixing it.

NOTE : The tutorial demonstrates, the uses of monitoring table function through customized TE views. For more details on TE views and how to generate them, refer to the tutorial leveraging TE views.

Problem to diagnose


The tutorial uses a query which performs too many table scan operation, to troubleshoot the query slowdown problem.

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



Step by step approach to troubleshoot the problem