Home

Neueste Versionen	FixList
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren
Kontaktformular

DB2 - Problembeschreibung

Problem IC72643	Status: Geschlossen
On DPF LOAD FROM CURSOR INTO a XML TABLE CRASHES WITH BAD PAGE ERROR.
Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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
Problem-Zusammenfassung:
On DPF LOAD FROM CURSOR INTO a XML TABLE CRASHES WITH BAD PAGE ERROR.
Local-Fix:
As a workaround: Load from a file instead of from cursor.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows 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
Lösung
Fixed in DB2 V9.7 FP4 As a workaround: Load from a file instead of from cursor.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger : APAR is sysrouted TO one or more of the following: IC73008 Nachfolger :
Weitere Daten
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung:	17.11.2010 29.04.2011 29.04.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP4
Problem behoben lt. FixList in der Version
9.7.0.4