Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC82198 Status: Closed

WITH MULTI-ROW INSERT, AFTER AN APPLICATION ENDS CHAINING AND IT FAILS, THE
NEXT SQLFETCH GETS ERROR CLI0115E

product:
DB2 CONNECT / DB2CONNCT / 970 - DB2
Problem description:
After a CLI (Call Level Interface) application sets the 
attribute SQL_ATTR_CHAINING_END for a statement handle (to end 
Multi-Row Insert chaining) and it fails for any reason, the next 
call to SQLFetch for any statement handle by the same CLI 
application then fails with the error: 
"[IBM][CLI Driver] CLI0115E  Invalid cursor state. 
SQLSTATE=24000". 
 
The error happens only if the attribute SQL_COLUMNWISE_MRI_ON is 
set (which activates the Multi-Row Insert feature). Therefore 
the error only happens when the database server is DB2 on z/OS. 
 
The DB2 on z/OS database server gets error DSNL032I with 
REASON=00D35B13
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of DB2 for Linux, UNIX and Windows who run             * 
* applications that use the CLI (Call Level Interface) API     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* .                                                            * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
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

Solution
Problem was first fixed in Version 9.7 Fix Pack 6. 
At a minimum, this fix should be applied on the client.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC84563 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.03.2012
15.06.2012
15.06.2012
Problem solved at the following versions (IBM BugInfos)
9.7.FP6
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.6 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.