Db2 Error Codes 502
Contents |
Tag: Error: DB2 SQL Error: SQLCODE=-502 SQLSTATE=24502 DB2 SQL Errors Codes and Error Messages and Warnings from Error -500 to -502 February 11, 2015 SQLServerF1 Leave a comment Error: DB2 SQL Error: SQLCODE=-500, SQLSTATE=24501, SQLERRMC=TBSPACEID=, TABLEID=, COLNO=, DRIVER= THE IDENTIFIED CURSOR
Db2 Error Codes 551
WAS CLOSED WHEN THE CONNECTION WAS DESTROYED Explanation: The FETCH, UPDATE, DELETE, or CLOSE db2 error codes 204 statement identifies a closed cursor that was defined with the WITH HOLD option. The cursor was closed when the connection on which it
Db2 Error Codes 206
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 http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n502.html 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 http://www.sqlserverf1.com/tag/error-db2-sql-error-sqlcode-502-sqlstate24502/ 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. SQLSTATE: 24501 Error: DB2 SQL Error: SQLCODE=-501, SQLSTATE=24501, SQLERRMC=TBSPACEID=, TABLEID=, COLNO=, DRIVER= THE CURSOR IDENTIFIED IN A FETCH OR CLOSE STATEMENT IS NOT OPEN Explanation: The application program attempted either to fetch using a cursor or to close a cursor at a time when the specified cursor was not open. System action: The statement cannot be processed. Programmer response: Check for a previous SQL return code that might have closed the cursor. v Commit and rollback operations close cursors. v SQL return codes -404, -652, -679, -802, -901, -904, -909, -910, -911, -913, and -952 might force the cursor to close. After the cursor is closed, any fetches or close cursor statements will receive SQLCODE -501. If no previous SQL return codes have been issued, correct the logic of the application program to ensure that the cursor is open at the time the FETCH or CLOSE statement is processed. SQLSTATE: 24501 Error: DB2 SQL Error: SQLCODE=-502, SQLSTATE=24502, SQLERRMC=TBSPACEID=, TABLEID=, COLNO=, DRIVER= THE CURSOR IDENTIFIED IN AN OPEN STATEMENT IS ALREADY OPEN Explanation: The applicatio