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.