00C20254

Explanation
 Db2 is unable
to acquire or upgrade a physical lock (P-lock) because of an incompatible
retained lock held by one or more other Db2 subsystems
in the Db2 data sharing group.
Retained locks are locks that persist across Db2 abnormal terminations.

System action
 SQLCODE -904 is returned to the user. This reason
code and the resource name are returned in the cursor table (CT) and
made available to the user in the SQLCA.

System programmer response
 Use
the -DISPLAY DATABASE command to display the Db2 member names owning the retained locks. You
must restart those subsystems to remove the 'resource unavailable'
condition. To show the status of the DBMS and IRLM subsystems, you
can use the following command:  F irlmproc,STATUS,ALLD