Viewing the threads associated with a specific resource

This topic describes how to view the threads associated with a specific resource.

To view the threads associated with a specific resource:
  1. Open the Locking Conflicts window is in one of the following ways:
    • In the System Overview window, select the DB2® subsystem in the folders pane and then click the Locking Conflicts toolbar button (Locking 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 > Locking Conflicts on the menu bar or Monitor > Locking Conflicts on the pop-up menu.

    This window lists all resources involved in a locking situation.

  2. In the Locking Conflicts window, double-click the resource, or click the resource for which you want to view the associated threads and then click Selected > Threads in Lock Conflicts.

    The Threads in Lock Conflicts window for the selected resource type is displayed.

    This window contains detailed information about the selected resource and a list of the associated threads. The resource information changes with the selected resource. The threads are grouped by the thread holding the lock (Holder) and the threads waiting for the resource to be freed (Waiter).

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