Introduction

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.

Problem to diagnose

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:

Tutorial Flow:


Pre-requisite: