The objective of this scenario is to use the DB2 monitoring text report to identify and isolate a lock wait problem.
In this problem, slow application request(s) are spending more time waiting for locks. This is due to more requests contending for the same few rows in a particular table.
This scenario illustrates the use of monitoring information to troubleshoot a slowdown in response time reported on a production system.
DB2 provides many monitoring tools to diagnose different types of problems. The scenario illustrated here uses a DB2 module called MONREPORT to monitor information and troubleshoot a response time slowdown on a production system. The MONREPORT module provides a set of procedures for retrieving a variety of monitoring data and generating text reports.
At the end of this scenario, there is enough information available about the problem to fix it.
NOTE: This tutorial requires DB2 9.7 Fix pack 1 to be installed.
The Purchase item application is slowed down due to time spent waiting for locks on the INVENTORY
table to be released.
Troubleshooting this problem involves getting these questions answered:
db2sampl
EXECUTE
privileges on SYSIBMADM.MONREPORT
module. For example, use the following command to grant EXECUTE
privilege to user 'testuser'
:GRANT EXECUTE ON MODULE SYSIBMADM.MONREPORT TO USER testuser