DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 might give a -901 if the query satisfies the following 
conditions: 
 
1. The query has an outer join between base tables. 
2. The outer join has a DISTINCT. 
3. The output column list from outer join contains one or more 
columns from the null producing side. 
4. There is an IS NULL predicate above the outer join on the 
same column(s) as 3. 
 
eg. 
Select c1 from 
( select DISTINCT t1.c1, t2.c2  < ------------- condition 2,3 
  from t1 left join            <---------------- condition 1 
          t2 
  on t1.c1 = t2.c1) tmp(c1,c2) 
where tmp.c2 is null;      <--------------- condition 4 
 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "Had 
troubles while 
removing an unreferenced QCL.".)  SQLSTATE=58004 
 
Stack: 
 
sqlnr_Manual2NativeAJ[85] 
sqlnr_optprep[125] 
sqlnr_optprep_action[100] 
sqlnr_comp[110] 
sqlnr_seq[100] 
sqlnr_rcc[100] 
sqlnr_exe[1200] 
sqlnn_cmpl[370]

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 version 970 fixpack 6                  * 
****************************************************************

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 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
 

Problem is fixed in DB2 version 970 fixpack 6

keiner bekannt / siehe Local-Fix

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

07.11.2011
06.06.2012
06.06.2012

9.7.0