00C20257

Explanation

Db2 is unable to obtain a physical lock (P-lock) because of an 'out of record list storage' condition that IRLM detected. The record list is that part of the coupling facility lock structure that IRLM uses to record '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.

System programmer response

Allocate a larger coupling facility lock structure by using the MVS SETXCF,REBUILD command. Make sure that the active MVS CFRM policy specifies a larger structure size for the IRLM coupling facility lock structure before you initiate the rebuild. You can use the MVS SETXCF,STOP,POLICY and SETXCF,START,POLICY commands to change the active MVS CFRM policy. If lock size is not already at the current POLICY maximum size, you can increase lock size with the SETXCF START, ALTER, STRNAME=lock_structure, SIZE=new_size command.