|
Problem IC96352
|
Status: Closed |
SQL FUNCTION CONTAINING XML ARGUMENTS MIGHT CAUSE DB ABEND |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Under rare scenarios, DB2 might abend if the following
conditions are met:
1. The query contains one or more XML columns
2. There is at least one predicate of the form:
SQL function (arguments) <relop> <constant>.
<relop> refers to any relational operator like equality,
less than, greater than, etc.
<constant> refers to any constant value, host variable or
special register like current_timestamp, etc.
3. The xml column(s) from 1 is passed in as an argument to the
SQL function in 2.
DB2 may abend with the following stack:
<StackTrace>
0x090000000D47C064
@44@sqlri_position_posstr_locate_short_core__FP8sqlrr_cb11sqlvFu
ncNumP10sqlz_valueN63 + 0x89C
0x090000000D47B60C
sqlri_opparm_position_locate_short__FP8sqlrr_cb + 0x3C0
0x0900000010CDFAC0
evalPredicate__14xmlnvXpathNodeFP14XmlnvAutomatonP8sqlrr_cbRbb +
0xB8
0x0900000010CF2C34
m_checkConditions__14XmlnvAutomatonFP19XmlnvWorkArrayEntryiUiT3P
bRbT6 + 0x440
0x0900000010CF212C m_closeMatchedEntry__14XmlnvAutomatonFiRiPb +
0x1D0
0x0900000010CF0E38 endNode__14XmlnvAutomatonFPb + 0x274
0x0900000010CE2DAC m_traverse__14XmlnvNavigatorFb + 0x860
0x0900000010CE2348 getTuple__14XmlnvNavigatorFRbP8sqlrr_cb +
0x170
0x090000000E9996AC sqlriXMLScan__FP8sqlrr_cb + 0x214
0x090000000DB88548 sqlriNljnPiped__FP8sqlrr_cb + 0x4A0
0x090000000DB898E4 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x24
0x090000000CD63CA8 sqlrr_dss_router__FP8sqlrr_cb + 0x6F0
0x090000000E5D2600
sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x5D0
0x090000000DFBFA58 sqleSubRequestRouter__FP8sqeAgentPUiT2 +
0x5F0
0x090000000C985280 sqleProcessSubRequest__FP8sqeAgent + 0x2C84
0x090000000CB03840 RunEDU__8sqeAgentFv + 0x2EC
0x090000000D9F8C8C EDUDriver__9sqzEDUObjFv + 0xD8
0x090000000DA1CB9C sqloEDUEntry + 0x260
</StackTrace> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All user. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.5 fixpck 3. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
APAR is first fixed DB2 10.5 fixpck 3. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.09.2013
27.02.2014
27.02.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
