DB2 FOR LUW / DB2FORLUW / A10 - DB2

Some necessary conditions to hit the problem are: 
The query is in a pattern of 
SELECT FROM (<SUBQUERY1> as A, (SELECT FROM WHERE <ANYCOL> IN 
<SUBQUERY2>) as B) WHERE A.col1 = B.col1 GROUP BY A.col2; 
 
here, 
SUBQUERY1 = SELECT col1, col2 from <SUBQUERY3> GROUP BY col1, 
col2 
SUBQUERY2 = SELECT DISTINCT col1 from <SUBQUERY3> 
SUBQUERY3 = SELECT col1, col2 from <base tables> WHERE 
<ANYPREDICATES>

**************************************************************** 
* USERS AFFECTED:                                              * 
* all OS                                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* -901 FROM RUNNING A QUERY.                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* apply fp5 or higher                                          * 
****************************************************************

Manually rewrite SUBQUERY2 from "SELECT DISTINCT col1 from 
<SUBQUERY3>" to "SELECT col1 from <SUBQUERY3> GROUP BY col1".

fp5

not known / see Local fix

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

05.06.2014
14.10.2015
14.10.2015