During HADR replay or roll forward recovery, an insert may fail
due to a bad page being returned from disk. You will see
messages in the db2diag.log similar to the following.
2015-05-12-21.32.51.442700+480 I847140A6049 LEVEL: Warning
PID : 3473428 TID : 19020 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MYDB
APPHDL : 0-9 APPID: *LOCAL.DB2.150509115048
HOSTNAME: myHost
EDUID : 19020 EDUNAME: db2redow (MYDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbGetPageFromDisk,
probe:932
MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page
Header"
DIA8547C An error occurred in a database page header.
DATA #1 : String, 39 bytes
Page from disk doesn't match obj or BPD
DATA #2 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {tbspSeed:8;obj:5142;type:0} PPNum:793865 OPNum:793865
begoff: 48
datlen: 4048
pagebinx: 2146491
revnum: 1280
pagelsn: 0000000F3EA2F29E
flag: 2a
future32: 0
cbits1to31: 1769af10
cbits32to63: 3f06533b
DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 256 bytes
Pagekey: {pool:8;obj:5142;type:0} PPNum:801673
objectPageNum: 793865
bucketGroupHashIndex: 279638
hashnext: 0x0000000000000000
hashprev: 0x0000000000000000
bpdLatch:
SXLatch :
{
state = 0x0000000000010000
= {
held X: 1
reserved for X: 0
shared holders: 0
firstSharIndex: 0x0
firstExclIndex: 0x0
}
starve X mode = true
xWaitCount = 0
requestCount = 0
identity = SQLB_BPD::bpdLatch_SX (253)
}
ULatch :
{
state = 0x0000000000000000
= {
held X: 0
reserved for X: 0
shared holders: 0
firstSharIndex: 0x0
firstExclIndex: 0x0
}
starve X mode = true
xWaitCount = 0
requestCount = 0
identity = NO_IDENTITY (0)
}
UFlags: 0
onDirtyListType: 0
isPageDirty: 0
pageAgeFlags: 0
pageStatusFlag: 0
permanentState: 0
transientState: 0
fixcount: 1
bpp: 0x0a00030240b1b000
pinCount:
0x0A000300257F7C54 : 0000 0000
....
weight: 00
clnrPosCount: 0
dirtyprev: 0x0000000000000000
dirtynext: 0x0000000000000000
blockDesc: 0x0000000000000000
pminlsn: 0000000000000000
hatenext: 0x0000000000000000
hateprev: 0x0000000000000000
onWhichHateList: 65535
permanentHateList: 21
inMemoryChecksum: 0
newbpdidx: 3221225472
diskRelativePageID: 6251337
lastLsnWARed: 0000000000000000
LRB ptr: 0x0000000000000000
pendingReclaim: 0
pageGBPDependency:
SQLB_PAGE_GBP_DEPENDENCY_NEVER_SHARED
pageReclaimCount: 0
pageReclaimXCount: 0
pageReclaimXHoldingXCount: 0
indexLeafPageReclaimCount: 0
indexSMPPageReclaimCount: 0
XI_vectorIndex: 0
pageIsValid: 0
DATA #4 : Fix control block, PD_TYPE_SQLB_FIX_CB, 200 bytes
accessMethod: SQLB_POOL_RELATIVE
fixMode: 3 SQLBX | SQLBOLD
buffptr: 0x0000000000000000
bpdPtr: 0x0000000000000000
pageLsnOnXLatch: 0000000000000000
dmDebugHdl: 0
objectPageNum: 4294967295
empDiskPageNum: 4294967295
unfixFlags: 0
dirtyState: SQLBCLEAN
fixInfoFlags: 1
regEDUid: 0
Pagekey: {pool:8;obj:5142;type:0} PPNum:801673
Obj: {pool:8;obj:5142;type:0} Parent={8;5142}
lifeLSN: 0000000F524A81A3
tid: 0 0 0
extentAnchor: 1600
initEmpPages: 0
poolPage0: 0
poolflags: 122
objectState: 27
lastSMP: 0
pageSize: 4096
extentSize: 64
bufferPoolID: 1
partialHash: 336986120
objDescAttributes: 0
bufferPool: 0x0a00020049f09440
pdef: 0x0a0002004bd34200
glob: 0x0000000111e9a340
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x090000000459EE1C sqlbGetPageFromDisk__FP11SQLB_FIX_CBi +
0x950
[1] 0x09000000064C8654 sqlbfix__FP11SQLB_FIX_CB + 0x1724
[2] 0x09000000087BC578
@113@sqldRedoUpsert__FP13SQLD_DFM_WORKP15SQLD_INSINFO_LRP9SQLP_L
SN8Ul + 0x2780
[3] 0x09000000087A08A8
sqldRedo__FP8sqeAgentP8SQLD_LRHP9SQLP_LSN8UlN24 + 0x87C
[4] 0x0900000008AE759C
sqldmrdo__FP8sqeAgentUsP9SQLP_LSN8PcUlN35P8SQLP_TIDP15SQLD_RECOV
_INFO + 0x5E8
[5] 0x0900000008F3CA4C
sqlpRecDbRedo__FP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcbP10SQLP_FRA
PPP11SQLP_TENTRYP16SQLPR_LOGREC_DISP10REDO_INPUT + 0x928
[6] 0x0900000005282300
sqlpPRecProcLog__FP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcb + 0xBCC
[7] 0x090000000527E4C4
sqlpParallelRecovery__FP8sqeAgentP5sqlca + 0x1918
[8] 0x0900000007331D74 sqleSubCoordProcessRequest__FP8sqeAgent
+ 0x198
[9] 0x0900000006858724 RunEDU__8sqeAgentFv + 0x6FC
[10] 0x0900000006855ACC EDUDriver__9sqzEDUObjFv + 0x13C
[11] 0x0900000006855954 sqlzRunEDU__FPcUi + 0x10
[12] 0x0900000006868CD8 sqloEDUEntry + 0x264
[13] 0x0900000000839E10 _pthread_body + 0xF0
[14] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
2015-05-12-21.32.51.479896+480 I853190A530 LEVEL: Severe
PID : 3473428 TID : 19020 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MYDB
APPHDL : 0-9 APPID: *LOCAL.DB2.150509115048
HOSTNAME: myHost
EDUID : 19020 EDUNAME: db2redow (MYDB) 0
FUNCTION: DB2 UDB, data management, sqldRedo, probe:8503
RETCODE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page
Header" DIA8547C An error occurred in a database page header.
2015-05-12-21.32.51.480241+480 I853721A648 LEVEL: Severe
PID : 3473428 TID : 19020 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MYDB
APPHDL : 0-9 APPID: *LOCAL.DB2.150509115048
HOSTNAME: myHost
EDUID : 19020 EDUNAME: db2redow (MYDB) 0
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:1250
MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page
Header" DIA8547C An error occurred in a database page header.
DATA #1 : String, 25 bytes
Error during REDO of LSN:
DATA #2 : SQLP_LSN8, PD_TYPE_SQLP_LSN8, 8 bytes
0000000F7EF0221B
2015-05-12-21.32.51.490418+480 E854370A594 LEVEL: Error
PID : 3473428 TID : 19020 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MYDB
APPHDL : 0-9 APPID: *LOCAL.DB2.150509115048
HOSTNAME: myHost
EDUID : 19020 EDUNAME: db2redow (MYDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbSetPoolState,
probe:3604
MESSAGE : ADM12512W Log replay on the HADR standby has stopped
on table space "HIS_DATA_TBS" (ID "8") because it has been put
into "ROLLFORWARD PENDING" state. |
