DSNR057I csect-name RESOURCE INFORMATION: DBID X'dbid', PSID X'psid', PART X'part#'
Explanation
This message is produced periodically during the recovery phase of restart if Db2 detects that the restart processor has remained suspended across a two minute interval on an IRLM request. If Db2 is suspended for an IRLM lock in a data sharing environment, Db2 queries IRLM to determine what Db2 subsystem holds the lock. This message indicates that the locked resource is a type which is held on a database object. The dbid contains the DBID and the psid contains the PSID in the case of a table space or ISOBID in the case of an index space. If the object is a partition of a partitioned pageset, then the part# contains the partition number, otherwise it is zero.
System action
Db2 restart continues.
Operator response
Notify the system programmer.
System programmer response
If the message repeats every two minutes and Db2 restart does not appear to be progressing, then an agent running on the Db2 subsystem identified in message DSNR056I could be holding on to a lock for an extended period of time, that is associated with the DBID, PSID, PART identified in this message. You might be able to use the database object identification information in this message to identify the specific object which is encountering the problem. One way to check what object is encountering the problem is to query the Db2 catalog to find the database name and pageset name, and then to use the DISPLAY DATABASE CLAIMERS or DISPLAY DATABASE LOCKS commands to identify the agent that is holding the lock. If an agent can be identified, you can cancel the agent to release the lock.