Resolving locking conflicts

When several threads try to access the same data at the same time, DB2® uses locks to control these concurrent attempts. A lock associates a DB2 resource with an application process in a way that affects how threads can access this resource.

You can view the threads involved in a locking situation where at least one thread is suspended. You can view the threads of a single DB2 subsystem or an entire data sharing group.

This section describes how to display the threads independently of the associated resource and to view only the threads associated with a specific resource.

Related information:
  • Some windows show the key performance counters in a table. One or more columns might be hidden. For information about how to view hidden counters, to hide counters that you are not interested in, or to change the order of the columns, refer to Customizing table columns.