DB2 FOR LUW / DB2FORLUW / A50 - DB2

Under rare scenarios, DB2 might depict unoptimized query plan 
for queries when the following is true: 
1) The query contains one or more correlated subqueries 
2a) The subqueries are of the type NOT EXISTS/NOT IN 
2b) Alternatively, the subqueries are of the type EXISTS() or 
EXISTS() 
3) There are three or more tables in the outer subselect of the 
query. Atleast one of these tables is not correlated to the 
above subqueries 
4) The order of the joins between the outer tables places the 
correlated parent table as the last join.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v10.5 Fixpack 6 or Later.                 * 
****************************************************************

1) Rewrite the query to add redundant join predicates 
2) Use registry variable: db2set DB2COMPOPT=ALLOW_COMPLEX_SQ

First Fixed in DB2 LUW v10.5 Fixpack 6.

not known / see Local fix

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

23.03.2015
26.08.2015
26.08.2015