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

ERROR HANDLING DURING INDEX PAGE PREFETCHING MIGHT CAUSE INSTANCE TO ABEND

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
When index page prefetching encounters an error (for example a 
bad index page error), the error handling might attempt to 
double free a piece of memory, bringing down the instance. 
Index page prefetching can occur during index reorg, or a normal 
select. 
 
The trapping process will produce the following callstack 
 
<StackTrace> 
0x0900000005378BE0 sqloCrashOnCriticalMemoryValidationFailure + 
0x20 
0x0900000005379590  sqlofmblkEx + 0x490 
 
0x0900000006274E5C sqlbServiceLeafRequest__FP11SQLB_pfMisc + 
0x14BC 
0x090000000626F3E8 
sqlbPFPrefetcherEntryPoint__FP16sqbPrefetcherEdu + 0xAA8 
0x090000000627D90C RunEDU__16sqbPrefetcherEduFv + 0x2C 
0x09000000054780B8  EDUDriver__9sqzEDUObjFv + 0x278 
 
0x0900000005477DF0  sqlzRunEDU__FPcUi + 0x10 
0x09000000053C7F4C sqloEDUEntry + 0x2CC 
</StackTrace> 
 
With error messages that look like the following: 
 
2011-02-01-19.37.13.415181-360 I1863695A2348      LEVEL: Severe 
PID    : 15139044            TID  : 34183      PROC : db2sysc 
0 
INSTANCE: db2inst1              NODE : 000 
EDUID  : 34183                EDUNAME: db2pfchr (SAMPLE) 0 
FUNCTION: DB2 UDB, buffer pool services, sqlbServiceLeafRequest, 
probe:4479 
DATA #1 : String, 9 bytes 
leafFixCB 
DATA #2 : Fix control block, PD_TYPE_SQLB_FIX_CB, 168 bytes 
  accessMethod:  SQLB_POOL_RELATIVE 
  fixMode:                        2  SQLBOLD/SQLBOLDS 
  buffptr:      0x070000028fcac000 
  bpdPtr:        0x07000000725f3308 
  dmDebugHdl:                    0 
  objectPageNum:              49407 
  empDiskPageNum:        4294967295 
  unfixFlags:                    0 
  dirtyState:    SQLBCLEAN 
  fixInfoFlags: 
  regEDUid:      0
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When index page pre-fetching encounters an error (for        * 
* example a bad index page error), the error handling might    * 
* attempt to   double free a piece of memory, bringing down    * 
* the instance. Index page pre-fetching can occur during index * 
* reorg, or a normal select.                                   * 
*                                                              * 
* The trapping process will produce the following call stack   * 
*                                                              * 
* <StackTrace>                                                 * 
* 0x0900000005378BE0                                           * 
* sqloCrashOnCriticalMemoryValidationFailure +0x20             * 
* 0x0900000005379590  sqlofmblkEx + 0x490                      * 
* 0x0900000006274E5C sqlbServiceLeafRequest__FP11SQLB_pfMisc   * 
* +0x14BC                                                      * 
* 0x090000000626F3E8                                           * 
* sqlbPFPrefetcherEntryPoint__FP16sqbPrefetcherEdu + 0xAA8     * 
* 0x090000000627D90C RunEDU__16sqbPrefetcherEduFv + 0x2C       * 
* 0x09000000054780B8  EDUDriver__9sqzEDUObjFv + 0x278          * 
* 0x0900000005477DF0  sqlzRunEDU__FPcUi + 0x10                 * 
* 0x09000000053C7F4C sqloEDUEntry + 0x2CC                      * 
* </StackTrace>                                                * 
*                                                              * 
* With error messages that look like the following:            * 
*                                                              * 
* 2011-02-01-19.37.13.415181-360 I1863695A2348      LEVEL:     * 
* Severe                                                       * 
* PID    : 15139044            TID  : 34183      PROC :        * 
* db2sysc 0                                                    * 
* INSTANCE: db2inst1              NODE : 000                   * 
* EDUID  : 34183                EDUNAME: db2pfchr (SAMPLE) 0   * 
* FUNCTION: DB2 UDB, buffer pool services,                     * 
* sqlbServiceLeafRequest,probe:4479                            * 
* DATA #1 : String, 9 bytes                                    * 
* leafFixCB                                                    * 
* DATA #2 : Fix control block, PD_TYPE_SQLB_FIX_CB, 168 bytes  * 
*   accessMethod:  SQLB_POOL_RELATIVE                          * 
*   fixMode:                        2  SQLBOLD/SQLBOLDS        * 
*   buffptr:      0x070000028fcac000                           * 
*   bpdPtr:        0x07000000725f3308                          * 
*   dmDebugHdl:                    0                           * 
*   objectPageNum:              49407                          * 
*   empDiskPageNum:        4294967295                          * 
*   unfixFlags:                    0                           * 
*   dirtyState:    SQLBCLEAN                                   * 
*   fixInfoFlags:                                              * 
*   regEDUid:      0                                           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fixpack 5                         * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 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
Fixed in DB2 Version 9.7 Fixpack 5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
08.04.2011
30.01.2012
30.01.2012
Problem solved at the following versions (IBM BugInfos)
9.7.FP5
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.5 FixList