DB2 FOR LUW / DB2FORLUW / B10 - DB2

DB2 engine might crash when queries have outer joins, NOT EXISTS 
or NOT IN predicates 
 
Users might encounter DB2 engine crash when running queries: 
1. contain outer joins, NOT EXISTS or NOT IN predicates 
2. the left side of a left outer join, the right side of the a 
right outer join, the left side of NOT IN predicates or the 
predicates in the NOT EXISTS sub-select contain sub-queries 
3. the predicates in these sub-queries reference tables that is 
not local to the sub-queries 
 
An example of such a query is as following: 
SELECT * 
FROM   (SELECT b1 
        FROM   a, 
               b 
        WHERE  b1 = (SELECT Sum(c1) AS sum_c1  // 2. the left OJ 
side has predicate containing sub-query 
                     FROM   c 
                     WHERE  a.a1 = c.c1        // 3. the 
sub-query reference Table a is not local to the sub-query 
                     GROUP  BY c.c1)) u 
       LEFT JOIN (SELECT d1                    // 1. query has 
outer join 
                  FROM   d 
                  WHERE  d.d1 <> 1 
                  ORDER  BY d1) v 
              ON u.b1 = v.d1 
 
Example of the crash stack: 
 
<StackTrace> 
<sqlno_analyze_relop> 
<sqlno_analyze_pred_expr> 
 <sqlno_assign_optprd> 
<sqlno_assign_prd> 
<sqlno_call_sf> 
 <sqlno_each_opr>

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v111m3fp3                                         * 
****************************************************************

Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
 

Upgrade to v111m3fp3

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

23.10.2017
15.03.2018
15.03.2018