|
Problem IT12566
|
Status: Closed |
PERFORMANCE DEGRADATION IN ROLLBACK WITH V10.5 FP5 AND FP6 |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| Solution |
The problem is first fixed in DB2 version 10.5.0.7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.12.2015
21.01.2016
21.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
