Viewing all threads involved in a locking situation

This topic describes how to view all threads for an entire DB2® subsystem or data sharing group.

To view all threads for an entire DB2 subsystem or data sharing group you can do one of the following:

• In the System Overview window, select the DB2 subsystem in the folders pane and then click the Threads in Lock Conflicts toolbar button ().
• You can also use the menu bar or pop-up menu: click the DB2 subsystem in the folders pane, then click Selected > Monitor > Threads in Lock Conflicts on the menu bar or Monitor > Threads in Lock Conflicts on the pop-up menu.

If you are not connected to the selected DB2 subsystem, you are prompted to log on.

The Threads in Lock Conflicts window shows all threads that are involved in a locking situation, independent of the resource with which they are associated. They are grouped by the thread that holds the lock (Holder) and the threads that wait for the resource to be freed (Waiter).

This window shows all threads involved in a locking situation, independent of the resource that they are associated with. They are grouped by the thread holding the lock (Holder) and the threads waiting for the resource to be freed (Waiter).

To view more details on a thread, double-click the thread, or click the thread and then click Selected > Thread Details.