DB2 FOR LUW / DB2FORLUW / 970 - DB2

After an application that uses the CLI (Call Level Interface) 
API has executed a DELETE or UPDATE statement with WHERE CURRENT 
OF <cursor-name> clause, applications might get errors such as 
SQL0313N when they later execute another SQL statement. 
 
That is because when a CLI application executes a DELETE or 
UPDATE statement with WHERE CURRENT OF <cursor-name> clause the 
CLI package section for a CLI statement handle that is still 
open might incorrectly be released and then the 
same CLI package section is reused for a different SQL 
statement.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of applications that use the CLI (Call Level           * 
* Interface) API to connect to DB2 for Linux, UNIX and Windows * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* .                                                            * 
****************************************************************

As a workaround you can set the isolation level for the CLI 
statement handle of the DELETE or UPDATE statement with  WHERE 
CURRENT of clause to be the same as of that of the SELECT ... 
FOR UPDATE ... statement that created cursor <cursor-name>. 
You can set the isolation level by setting the CLI statement 
handle attribute SQL_ATTR_TXN_ISOLATION.

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 9.7 Fix Pack 9 
At a minimum, this fix should be applied on the client.

As a workaround you can set the isolation level for the CLI 
statement handle of the DELETE or UPDATE statement with 
WHERE CURRENT of clause to be the same as of that of the SELECT 
...

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

13.09.2013
17.12.2013
17.12.2013

9.7.FP9