|
Problem IC81386
|
Status: Closed |
EMBEDDED SQL APPLICATION MAY CRASH WHEN USING MULTIPLE CURSORS WITH LOB OR XML COLUMNS. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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
... |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 6 *
**************************************************************** |
| Local Fix: |
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" |
| 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 |
First fixed in DB2 Version 9.7 Fix Pack 6 |
| Workaround |
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" |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84419
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.02.2012
11.07.2012
11.07.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
|
 |
