DB2 FOR LUW / DB2FORLUW / 970 - DB2

If a transaction that includes a rollback of a create table 
statement is applied during recovery (crash recovery, 
rollforward recovery following a restore, or on a HADR standby 
database), the following error may be encountered during online 
extent movement.   The error is only detected by online extent 
movement, and only if the database has not been restarted since 
recovery completed. 
 
2012-03-20-07.45.45.854843+060 I147568A3884       LEVEL: Severe 
PID     : 21364924             TID  : 43915       PROC : db2sysc 
0 
INSTANCE: db2inst1            NODE : 000         DB   : SAMPLE 
APPHDL  : 0-10697              APPID: *LOCAL.DB2.120320064128 
AUTHID  : db2inst1 
EDUID   : 43915                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, 
probe:14 
MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page 
Header" 
          DIA8547C An error occurred in a database page header. 
DATA #1 : String, 64 bytes 
Error encountered trying to read a page - information follows : 
DATA #2 : String, 23 bytes 
Page verification error 
DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes 
7169488 
DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 88 bytes 
    Obj: {pool:62;obj:10557;type:64} Parent={62;10557} 
  lifeLSN:       0000000000000000 
  tid:           0 0  0 
<...> 
 
CALLSTCK: 
  [0] 0x090000001451E1AC pdLog + 0xD4 
  [1] 0x09000000111BF828 
sqlbLogReadAttemptFailure__FUiP16SQLB_OBJECT_DESCT1P9SQLB_PAGEib 
UlT1PcP12SQLB_GLOBALS + 0x194 
  [2] 0x09000000111C0244 
sqlbLogReadAttemptFailure__FUiP16SQLB_OBJECT_DESCT1P9SQLB_PAGEib 
UlT1PcP12SQLB_GLOBALS@glue4F2 + 0x9C 
  [3] 0x0900000010070B98 
sqlb_verify_page__FP9SQLB_PAGEP16SQLB_OBJECT_DESCUiT3P12SQLB_GLO 
BALSPUl + 0x10C 
  [4] 0x090000001446204C sqlbReadPage + 0x19C 
  [5] 0x090000001445C838 sqlbGetPageFromDisk__FP11SQLB_FIX_CBi + 
0x678 
  [6] 0x090000001445BF88 sqlbfix__FP11SQLB_FIX_CB + 0xB40 
  [7] 0x090000000F8F6194 
sqlbScanAllEMPsForObject__FUiP16SQLB_OBJECT_DESCP11SQLB_FIX_CBPl 
P12SQLB_POOL_CBP12SQLB_GLOBALS + 0x4A8 
  [8] 0x090000000F8F5508 
sqlbFindEMPMappingMovedExtent__FUiP11SQLB_FIX_CBUsT3UcPUiPUlPlPU 
cP12SQLB_GLOBALS + 0x1250 
  [9] 0x090000000FA8DE90 
sqlbMoveHighestExtent__FUilP12SQLB_POOL_CBT1P9sqeBsuEdu + 0x1414

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version V9.7 FP6                              * 
****************************************************************

Restart the database before beginning an online extent move 
following a recovery event.

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
 

First fixed in version 9.7 Fix Pack 6.

keiner bekannt / siehe Local-Fix

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

29.03.2012
05.06.2012
05.06.2012

9.7.FP6