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 IC77592 Status: Geschlossen

CRASH ON SQLRIHASHPROBE WHEN PLAN HAS IXAND OPERATOR

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
DB2 can crash with the following stack when running a query that 
 
has a  IXAND on the query plan (Note we have sqlriBIxaAnd in the 
stack) 
 
        ossDumpStackTraceEx 
        OSSTrapFile::dumpEx 
        sqlo_trce 
        sqloEDUCodeTrapHandler 
        __invoke_dynamic_linker__ 
        sqlriHashProbe 
        sqlriBMapBandP 
        sqlischf 
        sqliFirstTreeSearch 
        sqlirdk 
       sqldIndexFetch 
       sqldRowFetch 
       sqlriFetch 
       sqlriNljnNonPiped 
       sqlriExecThread 
       sqlriBIxaAnd 
       sqlriExecThread 
       sqlrihsjn 
       sqlriExecThread 
       sqlrihsjn 
       sqlriSectInvoke 
       sqlrr_dss_router 
       sqlrr_subagent_router 
       sqleSubRequestRouter 
       sqleProcessSubRequest 
       sqeAgent::RunEDU 
       sqzEDUObj::EDUDriver 
       sqlzRunEDU 
       sqloEDUEntry 
       cond_extricate_func 
       __clone
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The problem is a missing checking for memory allocated to a  * 
* internal structure for IXAND.                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 and Fix Pack 5                    * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
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

Lösung
Problem was first fixed in DB2 Version 9.7 and Fix Pack 5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
18.07.2011
09.12.2011
09.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.5 FixList