Locking Conflicts

Select this main menu option for information about locking conflicts.

Locking Conflicts panel
This panel shows existing DB2 locking contentions. It provides information about the owners and waiters currently involved in locking conflicts.
Locks/Claims Owned by a Thread
This panel shows lock and claim information of a specific thread. Use this information to analyze locks and claims, for example, the number of locks owned, the type and level of the locks, and the object of the locks.
Thread Lock/Claim/Drain Activity
This panel provides a summary of lock related activity for an individual thread.
Thread activity: Locks/Claims causing a thread to wait
This panel shows information about the locks that cause a thread to wait. You can use this information to determine whether a selected thread is suspended and waiting because of a locking conflict.
Thread Global Lock Activity
This panel provides a summary of global locking activity for an individual thread.

Parent topic: Classic User Interface