|
Problem IC80110
|
Status: Closed |
DEAD LATCH IN DB2TASKP, DB2STMM AND THE INDEPENDENT COORDINATOR AGENT TRYING TO UPDATE DATABASE CONFIG MAXAPPLS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Problem Description Above *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 6 *
**************************************************************** |
| Local Fix: |
Set MAXAPPLS to a fixed value. |
| available fix packs: |
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
|
| Solution |
First Fixed in Version 9.7 Fix Pack 6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 30.11.2011
20.10.2012
20.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
