DB2 FOR LUW / DB2FORLUW / A50 - DB2

Multi-threaded applications that make use of ESQL/C in some 
threads 
and CLI in others and do not explicitly manage their own 
contexts 
may experience hangs or crashes. 
 
Hangs will typically have no other threads in active CLI or 
ESQL/C 
code, with one ESQL/C thread having the stack: 
 
NOTE: On Windows, stacks need to be determined from user mode 
crash dump files with the correct debugging symbols. Stacks 
logged in the Windows event logs will not be accurate. 
 
ntdll!KiFastSystemCallRet 
ntdll!ZwWaitForSingleObject 
kernel32!WaitForSingleObjectEx 
kernel32!WaitForSingleObject 
db2sys!sqloxconflict_LONG 
db2sys!sqloxltc_app 
db2app!sqlastrt 
db2app!sqlastrt 
... 
 
Crashes will be in a CLI thread with a typical stack: 
 
sqlak_callbComplete 
sqljrParseRdbCmmReply 
sqljrParse 
sqljrDrdaArCommit 
CLI_sqlCommit 
SQLTransact2 
SQLDisconnect2 
SQLDisconnect 
... 
 
(Notably here we see CLI functions calling an ESQL/C call back 
function.) 
 
This APAR fix will address the conditions resulting in these two 
described events.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Multi-threaded applications using both ESQL/C and CLI        * 
* interfaces                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.5 FP 3 or higher                          * 
****************************************************************

Explicitly manage thread contexts in the application code.

DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

First fixed in DB2 V10.5 FP3

Explicitly manage thread contexts in the application code

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

27.08.2013
27.02.2014
27.02.2014