Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC96681 Status: Geschlossen

SQL FUNCTION CONTAINING XML ARGUMENTS MIGHT CAUSE DB ABEND

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 V10.1 on LUW users.                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1 Fix Pack 4 or higher                    * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
Fixed in DB2 V10.1 Fix Pack 4
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.10.2013
27.06.2014
27.06.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.4 FixList