|
Problem IC89724
|
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: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V10.1 Fixpack 3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 Version 10.1 Fixpack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.01.2013
22.11.2013
22.11.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
