|
Problem IC82362
|
Status: Closed |
BAD PAGE HEADER DETECTED DURING ONLINE EXTENT MOVE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version V9.7 FP6 *
**************************************************************** |
| Local Fix: |
Restart the database before beginning an online extent move
following a recovery event. |
| available fix packs: |
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
|
| Solution |
First fixed in version 9.7 Fix Pack 6. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.03.2012
05.06.2012
05.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
