home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC70107 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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
verfügbare FixPacks:
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

Lösung
First fixed in V9.5 FP7
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC70110 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.07.2010
10.01.2011
10.01.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP7
Problem behoben lt. FixList in der Version
9.1.0.7 FixList
9.5.0.7 FixList