|
Problem IC90874
|
Status: Closed |
SQL FUNCTION CONTAINING XML ARGUMENTS MIGHT CAUSE DB ABEND |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: *
* Using XML columns. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.7 Fixpack 9 . *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
APAR first fixed in DB2 V9.7 Fixpack 9 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC96352 IC96681
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.03.2013
13.01.2014
13.01.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.9
|
 |
| 9.7.0.9
|
|
