home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC71477 Status: Closed

INSTANCE PANICS WITH ERROR "EXPECTED LATCH TO BE HELD"

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Instance panics and crashes with the following message in the 
db2diag.log 
 
2010-07-27-12.25.44.623481+120 E58407708A2265     LEVEL: Severe 
(OS) 
PID     : 2302062              TID  : 1           PROC : 
db2pfchr 1 
INSTANCE: dwhprod              NODE : 001 
FUNCTION: DB2 UDB, SQO Latch Tracing, 
SQLO_SLATCH_CAS64::releaseConflictComple, probe:330 
MESSAGE : 
ZRC=0x870F011E=-2029059810=SQLO_LATCH_ERROR_EXPECTED_HELD 
          "expected latch to be held." 
CALLED  : OS, -, unspecified_system_function 
DATA #1 : String, 39 bytes 
Attempting to unlock an invalid latch: 
DATA #2 : File name, 16 bytes 
sqloLatchCAS64.C 
DATA #3 : Source file line number, 8 bytes 
980 
DATA #4 : Codepath, 8 bytes 
4 
DATA #5 : String, 125 bytes 
0x0000000000000000: { 
   held X: 0 
   reserved for X: 0 
   shared holders: 0 
   firstSharIndex: 0x0 
   firstExclIndex: 0x0 
} 
DATA #6 : LatchMode, PD_TYPE_LATCH_MODE, 8 bytes 
0x0 (invalid mode) 
DATA #7 : String, 394 bytes 
{ 
   state         = 0x0000000000000000 
                 = { 
                       held X: 0 
                       reserved for X: 0 
                       shared holders: 0 
                       firstSharIndex: 0x0 
                       firstExclIndex: 0x0 
                   } 
   starve X mode = true 
   xWaitCount    = 0 
   requestCount  = 0 
   identity      = SQLB_BPD::bpdLatch (38) 
} 
DATA #8 : Hexdump, 16 bytes 
0x0780000222E869D0 : 0002 2600 0001 0000 0026 0001 0000 0000 
..&......&...... 
CALLSTCK: 
  [0] 0x090000000305FEC0 
dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T 
3T7 
+ 0x298 
  [1] 0x090000000305FB44 
dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T 
3T7@glueA3 
+ 0x98 
  [2] 0x0900000002F0A308 
releaseConflictComplex__17SQLO_SLATCH_CAS64Fv + 0x33C 
  [3] 0x09000000027989A4 
sqlbBlockAreaErrorUnchain__FP20SQLB_BLOCK_VICTIM_CBUiP11SQLB_pfM 
isc 
+ 0x10 
  [4] 0x0900000002798888 
sqlbBlockAreaErrorHandler__FiP20SQLB_BLOCK_VICTIM_CBUiPcP16SQLB_ 
OBJECT_DESCP11SQLB_pfMisc 
+ 0x24C 
  [5] 0x0900000003308260 
sqlbProcessRange__FP16SQLB_OBJECT_DESCUiT2P11SQLB_pfMisc + 0x50C 
  [6] 0x0900000005A62E00 
.sqlbServiceRangeRequest__FP11SQLB_pfMisc_fdprpro_clone_263 + 
0x11C 
  [7] 0x09000000036B58BC sqlbPFPrefetcherEntryPoint__FPcUi + 
0x6C 
  [8] 0x09000000035FB668 
sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x270 
  [9] 0x09000000035F9AF0 @49@sqloRunGDS__Fv + 0xDC 
 
Trap file shows the following function stack trace 
 
</Siginfo_t> 
Signal #36 (SIGPRE): si_code is 0 (SI_USER:Sent by kill, 
sigsend, raise.) si_pid is 2302062, si_uid is 18, si_value is 
00000000 
</SignalDetails> 
 
0x09000000033F7200 sqloDumpEDU + 0x14 
0x090000000275546C sqle_panic__Fv + 0x34 
0x090000000305FEC8 
dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T 
3T7 
+ 0x2A0 
0x090000000305FB44 
dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T 
3T7@glueA3 
+ 0x98 
0x0900000002F0A308 releaseConflictComplex__17SQLO_SLATCH_CAS64Fv 
+ 0x33C 
0x09000000027989A4 
sqlbBlockAreaErrorUnchain__FP20SQLB_BLOCK_VICTIM_CBUiP11SQLB_pfM 
isc 
+ 0x10 
0x0900000002798888 
sqlbBlockAreaErrorHandler__FiP20SQLB_BLOCK_VICTIM_CBUiPcP16SQLB_ 
OBJECT_DESCP11SQLB_pfMisc 
+ 0x24C 
0x0900000003308260 
sqlbProcessRange__FP16SQLB_OBJECT_DESCUiT2P11SQLB_pfMisc + 0x50C 
0x0900000005A62E00 
.sqlbServiceRangeRequest__FP11SQLB_pfMisc_fdprpro_clone_263 + 
0x11C 
0x09000000036B58BC sqlbPFPrefetcherEntryPoint__FPcUi + 0x6C 
 
<LatchInformation> 
Holding Latch type: 
(SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch) - Address: 
(780000245873d00), Line: 2802, File: sqlbpfchr.C 
Holding Latch type: (SQLO_LT_SQLD_TCB__datExist) - Address: 
(7800002a1ff28f0), Line: 7786, File: sqldtcb.C 
</LatchInformation>
Problem Summary:
Users Effected: 
All Users 
 
Problem Description: 
Instance crashes with info listed above.
Local Fix:
available fix packs:
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 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 DB2 Version 9.7, Fix Pack 4
Workaround
Upgrade to DB2 Version V9.7 FP4
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
27.09.2010
02.05.2011
15.09.2011
Problem solved at the following versions (IBM BugInfos)
9.7.,
9.7.FP4
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.4 FixList