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 IC71001 Status: Closed

INSTANCE PANICS WITH ERROR "EXPECTED LATCH TO BE HELD"

product:
DB2 FOR LUW / DB2FORLUW / 910 - 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 AFFECTED:                                              * 
* All users on DB2 V9.1 FixPack 10 or below.                   * 
**************************************************************** 
* 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_CAS64CFCPCcCUiCUlT3ClT3C * 
* iT1T                                                         * 
* 3T7                                                          * 
* + 0x298                                                      * 
*   [1] 0x090000000305FB44                                     * 
* dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3C * 
* iT1T                                                         * 
* 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_CBUiPcP16S * 
* QLB_                                                         * 
* 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_CAS64CFCPCcCUiCUlT3ClT3C * 
* iT1T                                                         * 
* 3T7                                                          * 
* + 0x2A0                                                      * 
* 0x090000000305FB44                                           * 
* dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3C * 
* iT1T                                                         * 
* 3T7@glueA3                                                   * 
* + 0x98                                                       * 
* 0x0900000002F0A308                                           * 
* releaseConflictComplex__17SQLO_SLATCH_CAS64Fv                * 
* + 0x33C                                                      * 
* 0x09000000027989A4                                           * 
* sqlbBlockAreaErrorUnchain__FP20SQLB_BLOCK_VICTIM_CBUiP11SQLB * 
* _pfM                                                         * 
* isc                                                          * 
* + 0x10                                                       * 
* 0x0900000002798888                                           * 
* sqlbBlockAreaErrorHandler__FiP20SQLB_BLOCK_VICTIM_CBUiPcP16S * 
* QLB_                                                         * 
* 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>                                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.1 FixPack 11 or higher                     * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
Problem first fixed in DB2 V9.1 FixPack 11
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC71476 IC71477 IC71478 IC74158 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
08.09.2010
08.12.2011
08.12.2011
Problem solved at the following versions (IBM BugInfos)
9.1.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.11 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.