DB2 FOR LUW / DB2FORLUW / 970 - DB2

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:

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SLOW LOG REPLAY PERFORMANCE DUE TO LATCH CONTENTION          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 9.7 FP1                                           * 
****************************************************************

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
 

Problem was first fixed in Version 9.7 Fix Pack 1

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

06.07.2009
22.12.2009
22.12.2009

9.7.FP1