00C900BF

Explanation

Db2 is unable to obtain a lock because IRLM detected an 'out of record list' storage condition. The record list is that part of the coupling facility lock structure that contains the 'modify locks' (those locks that would be retained in case of a failure).

System action

SQLCODE -904 is returned to the user with this reason code. This reason code and the resource name are returned in the cursor table (CT) and made available to the user in the SQLCA. If it is active, an IFCID 0021 trace record is written and might contain additional diagnostic information.

System programmer response

If this becomes a prevalent problem, you will need to redistribute the coupling facility lock structure storage resource to make more room for the record list. You can do this in one of two ways:
  • Issue a rebuild.
  • Dynamically change the lock structure size.