Latest versionsfixlist
11.1.0.6 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
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC70107 Status: Closed

HANGING CONNECTION AND UN-COMMITTED TRANSACTIONS WHEN CURRENT PACKAGE
PATH IS SET AND PACKAGE HAS BEEN REBOUND.

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
When CURRENT PACKAGE PATH is set and package has been rebound, 
connections could hang and leave some transactions un-committed 
during normal operation. 
A CPU peak can also be observed during this issue. 
 
If stacks are produced, you should see the following stack: 
 
<StackTrace> 
0x09000000049AB130 
sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9 + 0x5AC 
0x0900000006113090 sqlrxend__FP8sqlrr_cbP15SQLXA_CALL_INFOi + 
0x52C 
0x090000000611731C sqlrr_xend__FP14db2UCinterface + 0x1B0 
0x0900000005113170 sqljsSyncEnd__FP14db2UCinterface + 0x540 
0x0900000006345D0C 
sqljs_ddm_syncctl__FP14db2UCinterfaceP13sqljDDMObject + 0x3AC 
0x09000000049873A4 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface 
+ 0x1D0 
0x090000000467DDC0 
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124 
0x090000000467F3F0 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0x224 
0x0900000004748EF8 
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98 
0x0900000004748C04 
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0 
0x090000000474898C sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 
0x13C 
0x0900000004725850 RunEDU__8sqeAgentFv + 0x11C 
0x09000000047255B0 EDUDriver__9sqzEDUObjFv + 0x94 
0x09000000047202EC sqloEDUEntry + 0x54C 
0x09000000049AB130 
sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9 + 0x5AC 
0x0900000006113090 sqlrxend__FP8sqlrr_cbP15SQLXA_CALL_INFOi + 
0x52C 
0x090000000611731C sqlrr_xend__FP14db2UCinterface + 0x1B0 
0x0900000005113170 sqljsSyncEnd__FP14db2UCinterface + 0x540 
0x0900000006345D0C 
sqljs_ddm_syncctl__FP14db2UCinterfaceP13sqljDDMObject + 0x3AC 
0x09000000049873A4 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface 
+ 0x1D0 
0x090000000467DDC0 
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124 
0x090000000467F3F0 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0x224 
0x0900000004748EF8 
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98 
0x0900000004748C04 
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0 
0x090000000474898C sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 
0x13C 
0x0900000004725850 RunEDU__8sqeAgentFv + 0x11C 
0x09000000047255B0 EDUDriver__9sqzEDUObjFv + 0x94 
0x09000000047202EC sqloEDUEntry + 0x54C 
</StackTrace>
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See error description above.                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to V9.5 FP7 or use the circumvention          * 
****************************************************************
Local Fix:
Do not rebind the package when "CURRENT PACKAGE PATH" is set
available fix packs:
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First fixed in V9.5 FP7
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC70110 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.07.2010
10.01.2011
10.01.2011
Problem solved at the following versions (IBM BugInfos)
9.5.FP7
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.7 FixList
9.5.0.7 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.