11.6. Diagnosing Lock Problems
We have discussed how isolation levels affect the DB2 locking strategy. The various lock modes allow DB2 to provide diversified concurrent scenarios. For many applications the locking mechanism works transparently, but for others issues such as lock waits, deadlocks, and lock escalations can occur.
DB2 has a comprehensive set of tools that you can use to obtain information about locking. In the following sections we will look at some of the tools that are available and how they can be used to troubleshoot locking problems.
11.6.1. Using the list applications Command
The list applications command issued with the show detail clause shows the status of each application. Use this command as the first diagnostic step ...