DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix pack 8.                       * 
****************************************************************

db2set DB2COMPOPT=327685,268435456 and restart instance

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
 

First fixed in DB2 Version 9.7 Fix pack 8.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC88127 IC88128 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

08.11.2012
01.04.2013
01.04.2013

9.7.FP8