DB2 - Problem description
Problem IC84524 | Status: Closed |
IN DPF, XML QUERIES INCLUDING XMLTABLE EXPRESSIONS USING BIND-IN HOST VARIABLES CAN RESULT IN BADPAGE ERROR DUE TO A BAD EXECUTI | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
This problem could happen when a correlation context (e.g., a bind-in host variable value, like the xmldoc in a query) is being reversed TQed multiple times. In other words the problem is caused by a faulty execution plan which is sharing a data buffer across operators in different subsections Will the following errors in the db2diag.log file 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 0x07000000784A0038 : 0000 0000 0000 0000 7FB4 0000 7FB3 0000 ................ 0x07000000784A0048 : 0000 0014 .... CALLSTCK: [0] 0x0900000007339624 pdLog + 0xEC [1] 0x090000000A512810 sqldcsl_fetchDirect__FP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQLD CSL_FETCH_CB + 0x25C [2] 0x090000000851E43C sqldcsl_fetchRow__FP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQLDCSL _FETCH_CB + 0x470 [3] 0x0900000009A71D34 xmls_FetchRecord__FP11XMLSTORE_CBR8XMLS_XIDPPcPUsT4UcP13XMLS_WA_ TOKENPP8SQLD_TCB + 0xBB0 [4] 0x09000000086CAE20 fetchTempNode__12XmlrnNodeMgrFP11XMLSTORE_CBP17xmlDataDescriptor R8XMLS_XIDsRP9XmlrnNodePPcPUsP12XmlsNidStac kP13XMLS_WA_TOKENP8S + 0xEC [5] 0x0900000009FA2A80 fetchNode__12XmlrnNodeMgrFP11XMLSTORE_CBP17xmlDataDescriptorR8XM LS_XIDR13XMLS_EXT_LXIDP12XmlsNidStackRP9Xml rnNodePUsP13XMLS_WA_ + 0x394 [6] 0x090000000AD1A76C m_startNavOnContext__14XmlnvNavigatorFP17xmlDataDescriptorb + 0x854 [7] 0x090000000AD19E8C openNavigator__14XmlnvNavigatorFP17xmlDataDescriptorP8sqlrr_cb + 0x940 [8] 0x090000000A12E7DC sqlriXMLScan__FP8sqlrr_cb + 0x294 [9] 0x090000000740F84C sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x658 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * This problem could happen when a correlation context (e.g., * * a bind-in host variable value, * * like the xmldoc in a query) is being reversed TQed multiple * * times. * * * * In other words the problem is caused by a faulty execution * * plan which is * * sharing a data buffer across operators in different * * subsections * * * * Will the following errors in the db2diag.log file * * * * 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 * * 0x07000000784A0038 : 0000 0000 0000 0000 7FB4 0000 7FB3 0000 * * ................ * * 0x07000000784A0048 : 0000 0014 .... * * CALLSTCK: * * [0] 0x0900000007339624 pdLog + 0xEC * * [1] 0x090000000A512810 * * sqldcsl_fetchDirect__FP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16 * * SQLD * * CSL_FETCH_CB + 0x25C * * [2] 0x090000000851E43C * * sqldcsl_fetchRow__FP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQL * * DCSL * * _FETCH_CB + 0x470 * * [3] 0x0900000009A71D34 * * xmls_FetchRecord__FP11XMLSTORE_CBR8XMLS_XIDPPcPUsT4UcP13XMLS * * _WA_ * * TOKENPP8SQLD_TCB + 0xBB0 * * [4] 0x09000000086CAE20 * * fetchTempNode__12XmlrnNodeMgrFP11XMLSTORE_CBP17xmlDataDescri * * ptor * * R8XMLS_XIDsRP9XmlrnNodePPcPUsP12XmlsNidStac * * kP13XMLS_WA_TOKENP8S + 0xEC * * [5] 0x0900000009FA2A80 * * fetchNode__12XmlrnNodeMgrFP11XMLSTORE_CBP17xmlDataDescriptor * * R8XM * * LS_XIDR13XMLS_EXT_LXIDP12XmlsNidStackRP9Xml * * rnNodePUsP13XMLS_WA_ + 0x394 * * [6] 0x090000000AD1A76C * * m_startNavOnContext__14XmlnvNavigatorFP17xmlDataDescriptorb * * + * * 0x854 * * [7] 0x090000000AD19E8C * * openNavigator__14XmlnvNavigatorFP17xmlDataDescriptorP8sqlrr_ * * cb + * * 0x940 * * [8] 0x090000000A12E7DC sqlriXMLScan__FP8sqlrr_cb + 0x294 * * [9] 0x090000000740F84C * * sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x658 * **************************************************************** * RECOMMENDATION: * * Upgrade to V10.1 Fixpack 1 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows | |
Solution | |
First fixed in V10.1 Fixpack 1 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 14.06.2012 31.12.2012 31.12.2012 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.1 | |
10.5.0.1 |