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

DB2 MIGHT ABEND WHILE COMPILING QUERY WITH MULTIPLE OUTER JOINS AND IS NULL
PREDICATE

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
Under rare scenarios, DB2 might abend if the following 
conditions are true: 
 
1. The query has atleast two left or right joins. 
2. There are one or more IS NULL predicates in the where clause 
3. The IS NULL predicate references table from the null 
producing side of the left join 
4. The left join above has more than one join predicate defined 
in the on-clause 
5. One of more predicates references columns from the null 
producing side of the second left join. 
 
<Stack Trace> 
 
0        ossDumpStackTraceEx 
1        OSSTrapFile::dumpEx 
2        sqlo_trce 
3        sqloEDUCodeTrapHandler 
4        __pthread_mutex_cond_lock 
5        sqlno_project_end_prd 
6        sqlno_call_sf 
7        sqlno_each_prd 
8        sqlno_call_sf 
9        sqlno_each_opr 
10       sqlno_call_sf 
11       sqlno_each_qur 
12       sqlno_call_sf 
13       sqlno_scan_qgm 
14       sqlno_dpd 
15       sqlno_prep_phase 
16       sqlno_exe 
17       sqlnn_cmpl 
18       sqlnn_cmpl 
19       sqlra_compile_var 
20       sqlra_find_var 
21       sqlra_get_var 
22       sqlrr_prepare 
23       sqljs_ddm_prpsqlstt 
24       sqljsParseRdbAccessed 
25       sqljsParse 
26       sqljsSqlam 
27       sqljsDriveRequests 
28       sqljsDrdaAsInnerDriver 
29       sqljsDrdaAsDriver 
30       sqeAgent::RunEDU 
31       sqzEDUObj::EDUDriver 
32       sqlzRunEDU 
33       sqloEDUEntry 
34       pthread_create@@GLIBC_2.2.5 
35       clone
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 version 10.1 fixpack 3                 * 
****************************************************************
Local-Fix:
db2set DB2COMPOPT=327685,268435456 and restart instance
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
The fix is first included in DB2 version 10.1 fixpack 3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
10.11.2012
11.11.2013
11.11.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.3 FixList
10.1.0.3 FixList