DB2 FOR LUW / DB2FORLUW / A50 - DB2

Under rare scenarios, a query executing on DB2 might take a long 
time if the following conditions are true: 
1) The query contains one or more subqueries of the type NOT 
EXISTS/NOT IN. 
2) The subqueries contains predicates which can be proven to be 
ALWAYS FALSE and 
produce an empty result set. 
 
eg. Select * from T1 
       Where Not Exists (select * from T2 
                                      where T1.c1 = T2.c1 and 
1=0)

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please update to DB2 Cancun Release 10.5.0.4                 * 
****************************************************************

Workaround: 
1) Manually rewrite the query to remove the subquery 
2) db2set -im DB2_ANTIJOIN=NO

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

The problem is fixed in DB2 Cancun Release 10.5.0.4

keiner bekannt / siehe Local-Fix

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

15.01.2014
06.10.2014
06.10.2014