home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IT01175 Status: Geschlossen

SQL FUNCTION CONTAINING XML ARGUMENTS MIGHT CAUSE DB ABEND

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - 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.5 users                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.5 Fix Pack 4 or higher.                   * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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

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