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 IT12566 Status: Geschlossen

PERFORMANCE DEGRADATION IN ROLLBACK WITH V10.5 FP5 AND FP6

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
With V10.5 Fix Pack 5 and Fix Pack 6, when a lot of roll back 
statements are performed concurrently, 
performance degradation could be observed compared with V10.5 
Fix Pack 4. 
 
In this situation, multiple number of stack traces like the 
following would be observed. 
 
-------Frame------ ------Function + Offset------ 
0x0900000000A5D6FC ossLockGetConflict + 0x17C 
0x0900000005694018 @144@pdLogInternal__FUlUiT1T2N41PvT1bPPc + 
0x748 
0x090000000568A780 pdLogEvRecEx + 0x458 
0x09000000061A037C sqluRollBackCallBack__Fv + 0x2FE8 
0x090000000518F7F4 
sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9 + 0x104 
0x0900000004FE53D8 sqlrrbck__FP8sqlrr_cbiN32P15SQLXA_CALL_INFO + 
0x1A34 
0x0900000004FE36D4 sqlrr_rollback__FP14db2UCinterface + 0xF0 
0x09000000061EC668 
sqljs_ddm_rdbrllbck__FP14db2UCinterfaceP13sqljDDMObject + 0x2DC 
0x090000000513F6C8 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface + 0xFC 
0x0900000005179260 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0x1174 
0x0900000005178E54 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0xD68 
0x0900000006686B90 
@72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8 
0x09000000066876A0 
@72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5F8 
0x09000000048345AC RunEDU__8sqeAgentFv + 0x48C38 
0x09000000047B2240 RunEDU__8sqeAgentFv + 0x124 
0x0900000005CCCDFC EDUDriver__9sqzEDUObjFv + 0x130 
0x0900000004D3D664 sqloEDUEntry + 0x390
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* User using DB2 Server Fix Pack 5 or Fix Pack 6.              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade DB2 Server to version 10.5.0.7.                      * 
****************************************************************
Local-Fix:
Lösung
The problem is first fixed in DB2 version 10.5.0.7.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
03.12.2015
21.01.2016
21.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList