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

DB2 PURESCALE INSTANCE MAY PANIC DURING BUFFERPOOL DECREASE

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
A pureScale instance may panic while a bufferpool decrease
operation is running. Bufferpool decrease can be initiated from
STMM or by explicitly resizing a bufferpool to a smaller size.
This is a very rare timing issue and the likelihood to hit the
issue is very low. The panic will be reported by an agent
indicating that a page latch is not held, similar to the
following db2diag.log message:

FUNCTION: DB2 UDB, SQO Latch Tracing,
SQLO_SLATCH_CAS64::releaseConflict, 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
1054
DATA #4 : Codepath, 8 bytes
2
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, 399 bytes
{
   state         = 0x0000000000000000
                 = {
                       held X: 0
                       reserved for X: 0
                       shared holders: 0
                       firstSharIndex: 0x0
                       firstExclIndex: 0x0
                   }
   starve X mode = false
   xWaitCount    = 0
   requestCount  = 0
   identity      = SQLB_BPD::bpdLatch_SX (264)
}
DATA #8 : Pointer, 8 bytes
0x0a000302d59785d8

The latch information in the trap file in the FODC directory
will indicate the agent is holding a page latch in mode: S.


Holding Latch type: (SQLO_LT_SQLP_SAVEPOINTS__spLatch) -
Address: (0xa000301836b8680)
Holding Latch type: (SQLO_LT_SQLP_TENTRY__applLatch) - Address:
(0xa000301836b8cf0), Line: 873, File: sqlpxreg.C HoldCount: 1
Holding latch type: (SQLO_LT_SQLB_BPD__bpdLatch_SX) - Address:
(0xa0003031e7e9968), mode: S, Line: 1650, File: sqlbfix.C
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
19.02.2019
16.01.2020
16.01.2020
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)