DB2 FOR LUW / DB2FORLUW / 970 - DB2

Embedded SQL applications that have multiple cursors open to 
select varying numbers of LOB or XML columns could crash when 
closing the cursors or if there are still open cursors, at 
application exit. 
 
Stack traces will be similar to: 
 
... 
<signal/exception> 
csmUnmarkCDB 
csmFreeLobCDB 
csmClearDataInfoList 
csmFreeCCB 
csmClose 
sqlacall 
... 
 
Or: 
 
... 
<signal/exception> 
csmClearDataInfoList. (or csmFreeCCB) 
csmCursorBlaster 
sqleUCdisconnect 
sqleUCtermAllCtx 
sqleterm 
sqle_ctx_exit_function 
sqle_myexitlist_function 
sqleExitApplicationEnvironment 
...

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 6                        * 
****************************************************************

Opening the cursor with the largest number of LOB/XML columns 
first may avoid the problem. 
Temporarily, if the application logic allows, stop closing 
cursors and set the registry variable DB2NOEXITLIST=YES to avoid 
the application side cursor tear-down.  Use the command "db2set 
DB2NOEXITLIST=YES"

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
 

First fixed in DB2 Version 9.7 Fix Pack 6

Temporarily, if the application logic allows, stop closing 
cursors and set the registry variable DB2NOEXITLIST=YES to avoid 
the application side cursor tear-down.  Use the command "db2set 
DB2NOEXITLIST=YES"

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84419 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

13.02.2012
11.07.2012
11.07.2012

9.7.FP6