|
Problem IC61885
|
Status: Closed |
SLOW LOG REPLAY PERFORMANCE DUE TO LATCH CONTENTION |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
During log replay (either rollforward or on a standby database),
we may see slow performance due to a latch contention for
transsem latch. On HADR systems, this slow performance may
contribute congestion states. To verify this, stacks have to be
collected for all db2redo worker processes.
A typical stack for redo worker process holding the transsem
latch is:
528654 (./t528654.000) -- Line: 156, File: sqlptinf.C
Agent Type: db2redow (OB7)
*** Stack ***
Timestamp: 2009-05-10-14.15.56.790422
0x0900000005107398
sqlpReservedToBeFreed__FP20sqle_agent_privatecbP8SQLP_TIDi +
0x3A0
0x0900000004E7107C
sqldConsumeSpace__FP13SQLD_DFM_WORKP13SQLD_DPG_DATAiN23 + 0x104
0x0900000004E630F0
@30@sqldRedoUpsert__FP13SQLD_DFM_WORKP15SQLD_INSINFO_LRP8SQLP_LS
NUl + 0x678
0x0900000004E600DC
sqldRedo__FP20sqle_agent_privatecbP8SQLD_LRHP8SQLP_LSNUlN24 +
0x484
0x09000000047FF958
sqldmrdo__FP20sqle_agent_privatecbP8SQLP_LSNPcUlN34P8SQLP_TIDP15
SQLD_RECOV_INFO + 0x540
0x090000000451DCFC
sqlpRecDbRedo__FP20sqle_agent_privatecbP8SQLP_ACBP9SQLP_DBCBP10S
QLP_FRAPPP11SQLP_TENTRYP16SQLPR_LOGREC_DISP10REDO_INPUT + 0x574
0x090000000516EBD4
sqlpPRecProcLog__FP20sqle_agent_privatecbP8SQLP_ACBP9SQLP_DBCB +
0x640
0x090000000451C820
sqlpParallelRecovery__FP20sqle_agent_privatecbP5sqlca + 0x930
0x09000000050E70B8 sqleSubCoordProcessRequest__FP13sqle_agent_cb
+ 0x1C0
0x0900000004E9BD14 sqleRunAgent__FPcUi + 0x95C
0x0900000004F1BE4C
sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x264
0x0900000004F1B7F4 @49@sqloRunGDS__Fv + 0x178
0x0900000004F3D378 sqloInitEDUServices + 0x180
0x0900000004A15394
@49@sqloSystemControllerMain__FCUiPFv_iPFi_vPPvCPi + 0x2E8
Holding Latch type: (SQLO_LT_SQLP_DBCB__transsem) - Address:
(780000020018038), Line: 156, File: sqlptinf.C
A typical stack for redo worker process waiting for the same
transsem latch is:
258418 (./t258418.000) -- Line: 0, File:
Agent Type: db2redow (OB7)
<<< Stack >>>
Timestamp: 2009-05-10-14.15.56.801798
0x0900000004FE3854 getConflictComplex__17SQLO_SLATCH_CAS64FCUl +
0x4AC
0x0900000004FE3B2C getConflict__17SQLO_SLATCH_CAS64FCUl + 0x98
0x090000000643A05C
sqloltch_track__FCP10sqlo_latchCUlCPCcT2C14SQLO_LT_VALUES@glue20
8 + 0x1F8
0x0900000005107234
sqlpReservedToBeFreed__FP20sqle_agent_privatecbP8SQLP_TIDi +
0x23C
0x0900000004E714B8
sqldReleaseSpace__FP13SQLD_DFM_WORKP13SQLD_DPG_DATAiN23 + 0x108
0x0900000004E6CE20
@30@sqldRedoDelete__FP13SQLD_DFM_WORKP15SQLD_DELINFO_LRP8SQLP_LS
NUl + 0x500
0x0900000004E600AC
sqldRedo__FP20sqle_agent_privatecbP8SQLD_LRHP8SQLP_LSNUlN24 +
0x454
0x09000000047FF958
sqldmrdo__FP20sqle_agent_privatecbP8SQLP_LSNPcUlN34P8SQLP_TIDP15
SQLD_RECOV_INFO + 0x540
0x090000000451DCFC
sqlpRecDbRedo__FP20sqle_agent_privatecbP8SQLP_ACBP9SQLP_DBCBP10S
QLP_FRAPPP11SQLP_TENTRYP16SQLPR_LOGREC_DISP10REDO_INPUT + 0x574
0x090000000516EBD4
sqlpPRecProcLog__FP20sqle_agent_privatecbP8SQLP_ACBP9SQLP_DBCB +
0x640
0x090000000451C820
sqlpParallelRecovery__FP20sqle_agent_privatecbP5sqlca + 0x930
0x09000000050E70B8 sqleSubCoordProcessRequest__FP13sqle_agent_cb
+ 0x1C0
0x0900000004E9BD14 sqleRunAgent__FPcUi + 0x95C
0x0900000004F1BE4C
sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x264
Waiting on latch type: (SQLO_LT_SQLP_DBCB__transsem) - Address:
(780000020018038), Line: 0, File: |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* SLOW LOG REPLAY PERFORMANCE DUE TO LATCH CONTENTION *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 9.7 FP1 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.07.2009
22.12.2009
22.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
