DB2 instance crash due to BAD PAGE error returned during
load from cursor into XML table marking the database bad.
This happens on DPF environments.
DB2DIAG messages may look as follows:
2010-09-30-14.21.42.106432-300 I285755351A1802 LEVEL: Severe
(Origin)
PID : 848030 TID : 61810 PROC : db2sysc
0
INSTANCE: db2sample NODE : 000 DB : sample
APPHDL : 0-29759 APPID: XX.XXXXX.XXXXXXX
AUTHID : db2inst1
EDUID : 61810 EDUNAME: db2agntp (sample) 0
FUNCTION: DB2 UDB, Common Storage Layer,
sqldcsl_getRecDataAndLength, probe:2414
MESSAGE : ZRC=0x87A80001=-2019033087=SQLDCSL_BADPAGE "Bad Data
Page"
DIA8500C A data file error has occurred, record id is
"".
DATA #1 : signed integer, 8 bytes
0
DATA #2 : Hexdump, 20 bytes
0x07000001A3380038 : 0000 0000 0000 0000 7FB4 0000 7FB3 0000
................
0x07000001A3380048 : 0000 0014
....
CALLSTCK:
[0] 0x0900000008FF51E8 pdLog + 0xE8
[1] 0x090000000600D6C8
sqldcsl_fetchDirect__FP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQLD
CSL_FETCH_CB + 0x25C
[2] 0x0900000006A4E53C
sqldcsl_fetchRow__FP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQLDCSL
_FETCH_CB + 0x478
[3] 0x090000000754F508
xmls_FetchRecord__FP11XMLSTORE_CBR8XMLS_XIDPPcPUsT4UcP13XMLS_WA
TOKENPP8SQLD_TCB + 0x598
[4] 0x090000000683E034
fetchTempNode__12XmlrnNodeMgrFP11XMLSTORE_CBP17xmlDataDescriptor
R8XMLS_XIDsRP9XmlrnNodePPcPUsP12XmlsN
idStackP13XMLS_WA_TOKENP8S + 0xEC
[5] 0x0900000006A53B5C
getCurrentNodeInternal__15XmlrnTreeWalkerFRP9XmlrnNode + 0x104
[6] 0x09000000083BBB2C
appendFullString__16XmlrnConstructorFP17xmlDataDescriptorPCcUsT3
+ 0x19C
[7] 0x0900000006193AA8
addDescendantValue__16XmlrnConstructorFP17xmlDataDescriptorUsUiN
23UcT6T3PUcT2b + 0x27C
[8] 0x09000000083A60D4
copyCurrentChild__16XmlrnConstructorFP17xmlDataDescriptor +
0xCD0
[9] 0x09000000083A4554
addDescendantSubtree__16XmlrnConstructorFP17xmlDataDescriptorb +
0x818
2010-09-30-14.21.42.150926-300 I285757154A1814 LEVEL: Severe
(Origin)
PID : 848030 TID : 55405 PROC : db2sysc
0
INSTANCE: db2sample NODE : 000 DB : sample
APPHDL : 0-29759 APPID: XX.XXXXX.XXXXXXX
AUTHID : db2inst1
EDUID : 55405 EDUNAME: db2agntp (sample) 0
FUNCTION: DB2 UDB, Common Storage Layer,
sqldcsl_getRecDataAndLength, probe:2414
MESSAGE : ZRC=0x87A80001=-2019033087=SQLDCSL_BADPAGE "Bad Data
Page"
DIA8500C A data file error has occurred, record id is
"".
DATA #1 : signed integer, 8 bytes
0
DATA #2 : Hexdump, 20 bytes
0x07000001A3340038 : 0000 0000 0000 0000 7FB4 0000 7FB3 0000
................
0x07000001A3340048 : 0000 0014
....
CALLSTCK:
[0] 0x0900000008FF51E8 pdLog + 0xE8
[1] 0x090000000600D6C8
sqldcsl_fetchDirect__FP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQLD
CSL_FETCH_CB + 0x25C
[2] 0x0900000006A4E53C
sqldcsl_fetchRow__FP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQLDCSL
_FETCH_CB + 0x478
[3] 0x090000000754F508
xmls_FetchRecord__FP11XMLSTORE_CBR8XMLS_XIDPPcPUsT4UcP13XMLS_WA
TOKENPP8SQLD_TCB + 0x598
[4] 0x090000000683E034
fetchTempNode__12XmlrnNodeMgrFP11XMLSTORE_CBP17xmlDataDescriptor
R8XMLS_XIDsRP9XmlrnNodePPcPUsP12XmlsN
idStackP13XMLS_WA_TOKENP8S + 0xEC
[5] 0x0900000005742924
initWalker__15XmlrnTreeWalkerFP18XmlrnReferenceNodeUs + 0x428
[6] 0x0900000006A57028
initWalker__15XmlrnTreeWalkerFP17xmlDataDescriptorUs + 0x690
[7] 0x09000000083A3EE4
addDescendantSubtree__16XmlrnConstructorFP17xmlDataDescriptorb +
0x1A8
[8] 0x090000000839E9A8
copySubtree__16XmlrnConstructorFP17xmlDataDescriptorP12XmlrnNode
MgrUlUsT1bP17XmlsNidDescriptor + 0x12
8
[9] 0x090000000839CD04
deepCopy__17xmlDataDescriptorFP11XMLSTORE_CBP17xmlDataDescriptor
Ui + 0x1DC
2010-09-30-14.21.42.159197-300 I285762412A1655 LEVEL: Severe
PID : 848030 TID : 60016 PROC : db2sysc
0
INSTANCE: db2sample NODE : 000 DB : sample
APPHDL : 0-29759 APPID: XX.XXXXX.XXXXXXX
AUTHID : db2inst1
EDUID : 60016 EDUNAME: db2agntp (sample) 0
FUNCTION: DB2 UDB, Common Storage Layer,
sqldcsl_getRecDataAndLength, probe:2439
MESSAGE : ZRC=0x82A80001=-2102919167=SQLDCSL_NONSEVERE_ERROR
"Non-severe PROGRAM ERROR"
DIA8532C An internal processing error has occurred.
DATA #1 : String, 29 bytes
Accessing deleted Temp record
DATA #2 : String, 7 bytes
sqldcsl
CALLSTCK:
[0] 0x0900000008FF51E8 pdLog + 0xE8
[1] 0x0900000006CCE0FC sqlzSetAndLog901 + 0x1A8
[2] 0x090000000600D7A0
sqldcsl_fetchDirect__FP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQLD
CSL_FETCH_CB + 0x334
[3] 0x0900000006A4E53C
sqldcsl_fetchRow__FP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQLDCSL
_FETCH_CB + 0x478
[4] 0x090000000754F508
xmls_FetchRecord__FP11XMLSTORE_CBR8XMLS_XIDPPcPUsT4UcP13XMLS_WA
TOKENPP8SQLD_TCB + 0x598
[5] 0x090000000683E034
fetchTempNode__12XmlrnNodeMgrFP11XMLSTORE_CBP17xmlDataDescriptor
R8XMLS_XIDsRP9XmlrnNodePPcPUsP12XmlsN
idStackP13XMLS_WA_TOKENP8S + 0xEC
[6] 0x0900000005742924
initWalker__15XmlrnTreeWalkerFP18XmlrnReferenceNodeUs + 0x428
[7] 0x0900000006A57028
initWalker__15XmlrnTreeWalkerFP17xmlDataDescriptorUs + 0x690
[8] 0x09000000083A3EE4
addDescendantSubtree__16XmlrnConstructorFP17xmlDataDescriptorb +
0x1A8
[9] 0x090000000839E9A8
copySubtree__16XmlrnConstructorFP17xmlDataDescriptorP12XmlrnNode
MgrUlUsT1bP17XmlsNidDescriptor + 0x12
8
2010-09-30-14.21.42.160643-300 I285765253A533 LEVEL: Severe
PID : 848030 TID : 55405 PROC : db2sysc
0
INSTANCE: db2sample NODE : 000 DB : sample
APPHDL : 0-29759 APPID: XX.XXXXX.XXXXXXX
AUTHID : db2inst1
EDUID : 55405 EDUNAME: db2agntp (sample) 0
FUNCTION: DB2 UDB, Common Storage Layer, sqldcsl_fetchDirect,
probe:526
MESSAGE : INDENTIFIERS:
DATA #1 : String, 74 bytes
Tablespace ID = 4, Tablespace Seed = 4, Object ID = 2, Object
Type = 134
2010-09-30-14.21.42.162436-300 I285765787A1655 LEVEL: Severe
PID : 848030 TID : 64116 PROC : db2sysc
0
INSTANCE: db2sample NODE : 000 DB : sample
APPHDL : 0-29759 APPID: XX.XXXXX.XXXXXXX
AUTHID : db2inst1
EDUID : 64116 EDUNAME: db2agntp (sample) 0
FUNCTION: DB2 UDB, Common Storage Layer,
sqldcsl_getRecDataAndLength, probe:2439
MESSAGE : ZRC=0x82A80001=-2102919167=SQLDCSL_NONSEVERE_ERROR
"Non-severe PROGRAM ERROR"
DIA8532C An internal processing error has occurred.
DATA #1 : String, 29 bytes
Accessing deleted Temp record
DATA #2 : String, 7 bytes
sqldcsl
CALLSTCK:
[0] 0x0900000008FF51E8 pdLog + 0xE8
[1] 0x0900000006CCE0FC sqlzSetAndLog901 + 0x1A8
[2] 0x090000000600D7A0
sqldcsl_fetchDirect__FP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQLD
CSL_FETCH_CB + 0x334
[3] 0x0900000006A4E53C
sqldcsl_fetchRow__FP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQLDCSL
_FETCH_CB + 0x478
[4] 0x090000000754F508
xmls_FetchRecord__FP11XMLSTORE_CBR8XMLS_XIDPPcPUsT4UcP13XMLS_WA
TOKENPP8SQLD_TCB + 0x598
[5] 0x090000000683E034
fetchTempNode__12XmlrnNodeMgrFP11XMLSTORE_CBP17xmlDataDescriptor
R8XMLS_XIDsRP9XmlrnNodePPcPUsP12XmlsN
STACK TRACE looks as follows:
pthread_kill
sqloDumpEDU
sqeLocalDatabase::MarkDBBad
sqldDumpContext
sqldcsl_dumpBadPage
sqldcsl_fetchDirect
sqldcsl_fetchRow
xmls_FetchRecord
XmlrnNodeMgr::fetchTempNode
XmlrnTreeWalker::initWalker
XmlrnTreeWalker::initWalker
XmlrnConstructor::addDescendantSubtree
XmlrnConstructor::copySubtree
xmlDataDescriptor::deepCopy
xmlDataDescriptor::prepareForTransport
sqlrk_RPCRecvFetchXDM
sqlrk_xml_router
sqlrr_rpc_router
sqlrr_subagent_router
sqleSubRequestRouter
sqleProcessSubRequest
sqeAgent::RunEDU
sqzEDUObj::EDUDriver
sqloEDUEntry |
