DB2 FOR LUW / DB2FORLUW / A50 - DB2

In a pureScale environment, a pair of buffer pool information 
files (SQLBP.1 and SQLBP.2) exists on each member in the 
cluster. Assume that the database needs to be rolled forward. An 
unexpected problem (e.g. crash) happens when replaying a CREATE 
BUFFERPOOL statement, and the rollforward operation terminates. 
If the timing is right, it is possible that only some of the 
buffer pool information files have been updated while others 
have not. At this point, an attempt to restart the rollforward 
operation will fail with SQL0901N. Symptoms similar to the 
following will be recorded in the DB2 diagnostic log: 
 
2013-04-07-09.30.05.921561-240 I943469637A2280      LEVEL: 
Severe 
PID     : 34078918             TID : 22122          KTID : 
47448187 
PROC    : db2sysc 0 
INSTANCE: db2inst1             NODE : 000           DB   : 
SAMPLE 
APPHDL  : 0-55                 APPID: *N0.DB2.130407132957 
HOSTNAME: myhostname 
EDUID   : 22122                EDUNAME: db2redom (SAMPLE) 0 
FUNCTION: DB2 UDB, buffer pool services, sqlbCreateBPOnDisk, 
probe:3195 
MESSAGE : ZRC=0x82020001=-2113798143=SQLB_NONSEVERE_PRGERR 
          "non-severe BPS programming error" 
          DIA8532C An internal processing error has occurred. 
DATA #1 : String, 63 bytes 
on-disk bufferpool definition doesn't exist in uncommitted list 
DATA #2 : String, 18 bytes 
sqlbCreateBPOnDisk 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] pdLog 
  [1] sqlzSetAndLog901 
  [2] sqlbCreateBPOnDisk 
  [3] sqlbCreateBufferPoolAct 
  [4] bufferPoolAction 
  [5] sqldmpnd 
  [6] sqlptppl 
  [7] sqlpRFWppl 
  [8] sqlpRecDbRedo 
  [9] sqlprProcDPSrec 
  [10] sqlpPRecReadLog 
  [11] sqlpParallelRecovery

**************************************************************** 
* USERS AFFECTED:                                              * 
* See Error Description                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 for Linux, UNIX, and Windows Fix * 
* Pack 4                                                       * 
****************************************************************

Fix the problem causing the initial rollforward to fail, then 
restore and rollforward the database again.

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Problem first fixed in DB2 Version 10.1 for Linux, UNIX, and 
Windows Fix Pack 4

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

10.04.2013
08.09.2014
20.10.2014