When a RESTORE or ROLLFORWARD is running online, access to
objects in the tablespace being restored or rolled forward may
fail. Errors seen may include an SQLCODE -902 during online
rollforward, or a BAD PAGE error from an operation (for example,
INSERT) that affects a table in that tablespace. In the latter
case, you would see db2diag.log entries similar to the
following:
2014-02-25-07.59.02.846580-300 I4264652A7380 LEVEL:
Severe
PID : 22282398 TID : 21353 KTID :
51380259
PROC : db2sysc 1
INSTANCE: sample NODE : 001 DB : DBDB
APPHDL : 1-3126 APPID:
9.26.97.146.55001.140225133227
AUTHID : SAMPLE HOSTNAME: samplehost
EDUID : 21353 EDUNAME: db2agent (DBDB) 1
FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page,
probe:3
MESSAGE : ZRC=0x86020001=-2046689279=SQLB_BADP "page is bad"
DIA8400C A bad page was encountered.
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
1
DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 104 bytes
Obj: {pool:13;obj:65535;type:64} Parent={13;65535}
lifeLSN: 000000000003B162
tid: 0 0 0
extentAnchor: 1
initEmpPages: 0
poolPage0: 0
poolflags: 0x 3122
objectState: 0x 27
lastSMP: 0
pageSize: 16384
extentSize: 32
bufferPoolID: 4
partialHash: 3221159949
objDescAttributes: 0
objDescEHLState: 0x0000000000000000
bufferPool: 0x0700000098826ce0
pdef: 0x07000001238bb860
DATA #5 : Bitmask, 4 bytes
0x00000002
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {tbspSeed:3402287818;obj:51914;type:202}
bphPPNum:3402287818 bphOPNum:3402287818
begoff: 51914
datlen: 51914
revnum: 51914
pagelsn: CACACACACACACACA
flag: ca
future32: 3402287818
cbits1to31: cacacaca
cbits32to63: cacacaca
DATA #7 : Bufferpool globals, PD_TYPE_SQLB_GLOBALS, 1264 bytes
dbcb: 0x07800000075a0080
bpcb: 0x07000000964cd6a0
ptbl: 0x07000000964cdc80
eduType: SQLB_EDU_AGENT
eduCB: 0x07800000074f0080
qryData: 0x0000000000000000
qryDataSz: 0
qryDataPos: 0
contQryData: 0x0000000000000000
contQryDataSz: 0
contQryDataPos: 0
bglobals_flags: 10200
eduId: 21353
curPfQ: 12
curRemHateListCounter: 21518
debugInfo: 0x0000000117809960
pCurRecLsn: 0x0000000000000000
clnrCB: 0x0000000000000000
prefetchPriority: 1
agentPriorityWeight: 00
staticStr:
curRecTsp: 0
curRecPage: 0
numPFRequestsHeld: 0
memAccessCount:
m_bIsInitialized: true
m_iDisabled: 2
m_iAccessCount: 0
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x090000000918B290 pdLog + 0x2D0
[1] 0x090000000AFD5614
sqlbLogReadAttemptFailure__FUiP16SQLB_OBJECT_DESCT1P9SQLB_PAGEib
UlT1PcP12SQLB_GLOBALS + 0x394
[2] 0x090000000AFEFDD0
sqlb_verify_page__FP9SQLB_PAGEP16SQLB_OBJECT_DESCUiT3P12SQLB_GLO
BALSPUl + 0xF30
[3] 0x090000000AFF51F8 sqlbReadPage + 0xA58
[4] 0x090000000C1A40D0 sqlbGetPageFromDisk__FP11SQLB_FIX_CBi +
0x1C30
[5] 0x090000000B7418EC sqlbfix__FP11SQLB_FIX_CB + 0x3F4C
[6] 0x090000000B00711C sqlbFixPage__FP11SQLB_FIX_CBiUiT2 +
0x27C
[7] 0x090000000B009F78
sqlbFixDataEMP__FP16SQLB_OBJECT_DESCiP10ExtMapAddrP11SQLB_FIX_CB
UiP12SQLB_GLOBALS + 0x8B8
[8] 0x090000000B00B928
sqlbIsExtentAllocated__FP16SQLB_OBJECT_DESCUiiP11SQLB_FIX_CBPiP1
0ExtMapAddrPUiPbP12SQLB_GLOBALS + 0x428
[9] 0x090000000B00C5B0
sqlbDMScheckObjAlloc__FP16SQLB_OBJECT_DESCUliT3PPUiP12SQLB_GLOBA
LS + 0x6F0
[10] 0x090000000C1A0618 sqlbGetDiskPageID__FP11SQLB_FIX_CBPUi
+ 0x8F8
[11] 0x090000000C1A3E58 sqlbGetPageFromDisk__FP11SQLB_FIX_CBi
+ 0x19B8
[12] 0x090000000B7418EC sqlbfix__FP11SQLB_FIX_CB + 0x3F4C
[13] 0x090000000ACBAFBC sqlbFixPage__FP11SQLB_FIX_CBiUiT2 +
0x27C
[14] 0x090000000ACCC32C
sqldReadTableInfo__FP13SQLD_DFM_WORKiP15SQLD_DF_HDR_RECP12SQLD_T
DIRRECP13SQLD_TDESCRECPUsP8SQLZ_RIDUs + 0x1EC
[15] 0x090000000ACCF584 sqldLoadTCB__FP8sqeAgentP8SQLD_TCBi +
0x784
[16] 0x090000000ACD4BD8
sqldFixTCB__FP8sqeAgentiN32PP8SQLD_TCBUiT7 + 0x6B8
[17] 0x090000000B5F4C5C
sqldFixTCBHandleSQLCA__FP8sqeAgentUsT2UcN22iPcT7T8T7PP8SQLD_TCBU
iT13_ + 0xBC
[18] 0x090000000B5F4FD0
sqldFixTCBwithName__FP8sqeAgentUsT2UciPcT5T6T5PP8SQLD_TCBUiT11_
+ 0x150
[19] 0x090000000B5F5164
sqldFixObjectTableTCB__FP8sqeAgentUsiPP8SQLD_TCBUiUl + 0x104
[20] 0x090000000B5FCFDC
sqldoSetupDmsWAforFtc__FP8sqeAgentUsT2iN34UiUl + 0x1DC
[21] 0x090000000B5FDF68
sqldoftc__FP8sqeAgentUsT2UliP15SQLD_OBJTAB_RECN25 + 0x648
[22] 0x090000000ACCD3B8
loadDMSDesc__FP8sqeAgentP8SQLD_TCBP16SQLB_OBJECT_DESCi + 0x298
[23] 0x090000000ACCDCF0
loadObjDesc__FP8sqeAgentP8SQLD_TCBP16SQLB_OBJECT_DESCi + 0x1D0
[24] 0x090000000ACCE358
sqldLoadParentObjDesc__FP8sqeAgentP8SQLD_TCBP16SQLB_OBJECT_DESCi
T4 + 0x318
[25] 0x090000000ACCF42C sqldLoadTCB__FP8sqeAgentP8SQLD_TCBi +
0x62C
[26] 0x090000000ACD4BD8
sqldFixTCB__FP8sqeAgentiN32PP8SQLD_TCBUiT7 + 0x6B8
[27] 0x090000000AD412EC
sqldLockTableFixTCB__FP8sqeAgentUsT2UcUliN26N25T6PcT6T12_T6P14SQ
LP_LOCK_INFOPP8SQLD_TCBUiT18_ + 0xECC
[28] 0x090000000DBC597C
sqldGetInsertTable__FP8sqeAgentUsN42UcUlN28PP16SQLD_TABLE_CACHEP
Pv + 0x6DC
[29] 0x090000000DBC668C
sqldGetInsertTable__FP8sqeAgentUsN42UcUliPP16SQLD_TABLE_CACHEPPv
+ 0xAC
[30] 0x090000000DBC6B28
sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP8SQLZ_RIDPPv +
0x408
[31] 0x090000000B9A0A8C
sqlrinsr__FP8sqlrr_cbUsT2iT2PP10SQLD_VALUEQ3_10sqlri_iudo11t_iud
oFlags17t_iudoFlagsKernelP8SQLZ_RIDPPv + 0x1CC
[32] 0x09000000136FEC14 sqlriisr__FP8sqlrr_cb + 0x634
[33] 0x0900000009CAEDEC
sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm + 0x7EC
[34] 0x0900000009CB1650
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x10F0
[35] 0x090000000B3C8928
sqlrr_process_execute_request__FP8sqlrr_cbib + 0x1C28
[36] 0x090000000C5D1C08
sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x728
[37] 0x09000000123235F8
sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x6D8
[38] 0x0900000012319538
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x258
[39] 0x0900000012317E10
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x290
[40] 0x09000000122E5DD8
sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x698
[41] 0x09000000122E85D0
sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x1D0
[42] 0x09000000122EFE5C
sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x59C
[43] 0x09000000122F232C
sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x2EC
[44] 0x090000000956CEBC RunEDU__8sqeAgentFv + 0x47C
[45] 0x090000000952A77C EDUDriver__9sqzEDUObjFv + 0x23C
[46] 0x090000000952AABC sqlzRunEDU__FPcUi + 0x3C
[47] 0x09000000092F21F4 sqloEDUEntry + 0x7B4
[48] 0x09000000005F2D30 _pthread_body + 0xF0
[49] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF |
