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