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.