DB2 FOR LUW / DB2FORLUW / 970 - DB2

Rarely dead latch may happen in db2taskp, db2stmm and the 
independent coordinator agent trying to update database config 
MAXAPPLS when MAXAPPLS is set to AUTOMATIC: 
 
(1) the independent coordinator agent waits on latch 
SQLO_LT_SQLE_KRCB__cfg_change_latch which is held by STMM 
========================================= 
******** LATCHWAIT DETECTED ( #1 )  *********** 
Printing LatchWait information 
========================================= 
<<<<  Holder Information (Address = 780000000d39188)  >>>> 
  File Information: 
      Line: 975, File: sqle_database_services.C HoldCount: 1 
 
---------------------------- 
  PID(s): 
  50216 (./1659312.50216.000.stack.txt) -- Line: 975, File: 
sqle_database_services.C HoldCount: 1 
(SQLO_LT_sqeLocalDatabase__dblatch) 
  Agent Type:  db2agnti (INSTANCE) 
 
0x09000000111BBBB0 sqloXlatchConflict + 0x294 
0x09000000111186A0 sqloXlatchConflict@glue1AB@clone5 + 0x78 
0x090000000D4A666C 
sqlfUpdateDbCfg__FP16sqeLocalDatabaseP6db2CfgUiiT4P5sqlca + 
0x108 
0x090000000D965E64 
sqlf_set_automatic_parameter__FiT1PcP16sqeLocalDatabaseP5sqlca + 
0x140 
0x090000000D2CF530 
SubsequentConnect__16sqeLocalDatabaseFP8SQLE_BWAP8sqeAgentUcPiP8 
sqlo_gmti + 0x964 
0x0900000011223C90 
StartUsingLocalDatabase__8sqeDBMgrFP8SQLE_BWAP8sqeAgentRccP8sqlo 
_gmt + 0x6C4 
 
 
<LatchInformation> 
 
Waiting on latch type: (SQLO_LT_SQLE_KRCB__cfg_change_latch) - 
Address: (7800000002a6190), Line: 
3058, File: sqlf_db_op.C 
 
Holding Latch type: (SQLO_LT_sqeLocalDatabase__dblatch) - 
Address: (780000000d39188), Line: 975, 
File: sqle_database_services.C HoldCount: 1 
</LatchInformation> 
 
(2) STMM trying to adjust package cache, but stuck in getting 
latch SQLO_LT_ABPDispatcher which is held by db2taskp 
1659312.6684.000.stack.txt:  (EDU name    : db2stmm (INSTANCE) 
0) 
<LatchInformation> 
 
Waiting on latch type: (SQLO_LT_ABPDispatcher) - Address: 
(700000066bee260), Line: 1622, File: 
abpDispatcher.C 
 
Holding Latch type: (SQLO_LT_SQLE_KRCB__cfg_change_latch) - 
Address: (7800000002a6190), Line: 3058, 
 
File: sqlf_db_op.C HoldCount: 1 
Holding Latch type: 
(SQLO_LT_sqlra_anchor_stmt__invalid_var_latch) - Address: 
(700000066cb97a8), 
 
Line: 583, File: sqlra_csm.C HoldCount: 1 
</LatchInformation> 
 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x090000001103006C getConflictComplex__17SQLO_SLATCH_CAS64FCUl + 
0x3E4 
0x090000001102F848 
getConflictX__17SQLO_SLATCH_CAS64FCUl@glue17D0 + 0x80 
0x090000000DF510E0 
activateTaskProContexts__13ABPDispatcherFRC8sqeAgentR21ABPTaskPr 
oContextList + 0x274 
0x0900000011241670 
abpActivateTaskProContexts__FPC8sqeAgentP21ABPTaskProContextList 
+ 0x48 
0x0900000011241780 
abpActivateTaskProContexts__FPC8sqeAgentP21ABPTaskProContextList 
@glue9FB + 0x80 
0x090000000F4FAE7C 
sqlra_cache_del_var__FP8sqlrr_cbP16sqlra_cached_variP23sqlra_cac 
hed_dependency + 0xB0 
0x090000000F2BE878 
sqlra_csm_drop_var__FP8sqlrr_cbPP16sqlra_cached_variP23sqlra_cac 
hed_dependencyPi + 0x47C 
0x090000000F2C5320 
sqlra_csm_flush_vars_anchor__FP8sqlrr_cbP17sqlra_anchor_stmt+ 
0x2A8 
0x090000000EBA3370 sqlra_csm_flush_vars__FP8sqlrr_cb + 0x4C 
0x09000000111EE4E4 sqlra_cache_space_mgmt__FP8sqlrr_cbUl + 0xB4 
0x090000000F7D6C90 
sqlra_cache_space_mgmt__FP8sqlrr_cbUl@glue153D + 0x74 
0x090000000F78C894 sqlra_resize_pckcache__FP16sqeLocalDatabasei 
+ 0xFC 
0x0900000011213C4C 
sqlf_dynamic_db_update__FP16sqeLocalDatabaseP11db2CfgParamP10sql 
f_dbcfdP5sqlca + 0x8 
0x090000001121B7BC 
sqlfUpdateDbCfg__FP16sqeLocalDatabaseP6db2CfgUiiT4P5sqlca + 
0x8B8 
0x0900000010FB7658 
sqlfDispatchDbCfgUpdate__FP16sqeLocalDatabaseP6db2CfgiT3P5sqlca 
+ 0x5C 
0x090000000D4100CC 
stmmUpdateDBConfig__FP16sqeLocalDatabaseUlPclbN25 + 0x1A4 
0x090000000D440C48 stmmUpdatePackageCache__FP16sqeLocalDatabasei 
+ 0x2C 
0x090000000D43F68C 
stmmResizeRecord__FP21stmmCostBenefitRecordP16sqeLocalDatabase + 
0x338 
0x090000000D43D828 
stmmDecreaseEntriesAndRemoveFromList__FP16sqeLocalDatabasePP21st 
mmCostBenefitRecordPUi + 0xBEC 
0x090000000D438DA4 
stmmResizeEntriesAndRemoveFromList__FPP21stmmCostBenefitRecordP1 
6sqeLocalDatabase + 0xCC 
0x090000000D4388B8 
stmmTuneMemory__FPP21stmmCostBenefitRecordP16sqeLocalDatabase + 
0x11C 
0x090000000D2D69DC stmmMemoryTunerMain + 0x474 
0x090000001126BF60 sqleIndCoordProcessRequest__FP8sqeAgent + 
0x184 
0x0900000011238DF4 RunEDU__8sqeAgentFv + 0x1B0 
0x0900000011230898 EDUDriver__9sqzEDUObjFv + 0xDC 
0x090000001123077C sqlzRunEDU__FPcUi + 0x14 
0x090000001122B58C sqloEDUEntry + 0x264 
</StackTrace> 
 
(3) db2staskp is waiting on the independent coordinator to 
return 
1659312.49959.000.stack.txt : (EDU name    : db2taskp 
(SVMSTEST) 0) 
 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x0900000011048B10 sqloWaitEDUWaitPost + 0x58 
0x0900000011246BD4 WaitForSanityCheck__11sqeIcoordCBFP5sqlca + 
0x58 
0x0900000011246A04 
DispatchIndependentDBAgent__11sqeIcoordCBFiP5sqlcaP13SQLKD_TA 
SK_IDPvPCcP16SQLE_CLIENT_INFOP16SQLEX_AUTHINFO_TP12SQLZ_APP_HDLN 
21b + 0x2F0 
0x0900000011240DDC 
spawnIcoordAgent__14ABPIcoordAgentFRC8sqeAgentCbPC17ABPTaskProCo 
ntextR5sqlcaT2 + 0xD8 
0x0900000011240F44 
spawnAgent__13ABPDispatcherFRC8sqeAgentPC17ABPTaskProContextCbN2 
3 + 0x88

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description Above                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 6                        * 
****************************************************************

Set MAXAPPLS to a fixed value.

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 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in Version 9.7 Fix Pack 6

keiner bekannt / siehe Local-Fix

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

30.11.2011
20.10.2012
20.10.2012

9.7.FP6