DB2 FOR LUW / DB2FORLUW / A50 - DB2

Incorrect results might be observed from queries:
1. contain at least one of these aggregations:
   COUNT(*), COUNT_BIG(*), COUNT(CONSTANT), COUNT_BIG(CONSTANT),
SUM(CONSTANT), MAX(CONSTANT) and MIN(CONSTANT)
2. the aggregations are on outer joined tables;
3. a foreign key on the NULL producing table of the outer join
references the primary key on the table at the other side of the
outer join;

An example query:
SELECT T1.X, COUNT (*) as c1 from TABLE_1 T1 left join TABLE_2
T2 on (T1.X = T2.Y) group by T1.X

whereas TABLE_1.X is the primary key and TABLE_2.Y is a foreign
key referencing the primary key TABLE_1.X

****************************************************************
* USERS AFFECTED:                                              *
* All DB2 Users                                                *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to DB2 for LUW 10.5 Fix Pack 10 or later.            *
****************************************************************

Set OPT level 1. This can be done by running:
db2set DB2_OPTPROFILE=YES
Then adding the following text after the problematic query:
/* 
     
 */

not known / see Local fix

forerunner  : 
follow-up : IT23261 

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

23.11.2017
12.07.2018
12.07.2018