DB2 SQL-Error: -500
SQLState: 24501
Short Description: THE IDENTIFIED CURSOR WAS CLOSED WHEN THE CONNECTION WAS DESTROYED
The FETCH, UPDATE, DELETE, or CLOSE statement identifies a closed cursor that was defined with the WITH HOLD option. The cursor was closed when the connection on which it was dependent was destroyed during a commit operation. The connection was destroyed because the application process placed it in the released state, or the application plan was bound with the DISCONNECT(AUTOMATIC) option. System action: The statement cannot be executed. Programmer response: The correction depends on the desired state of both the cursor and the connection, as follows: v If you want the cursor closed, change the application program so that the cursor is not referenced in the closed state. v If you want the cursor open and the connection was placed in the released state by the application program, change the program so that the connection is not placed in the released state until the cursor is explicitly closed. v If you want the cursor open and the connection was placed in the released state as a result of the DISCONNECT(AUTOMATIC) option, rebind the plan using DISCONNECT(CONDITIONAL). Correct the error in the application, rebind the plan, and resubmit the job.