|
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
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 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
|
|
