DB2 FOR LUW / DB2FORLUW / A50 - DB2

Under rare scenarios, DB2 might abend when the following 
conditions are true: 
1) The query contains one or more columns with column based 
access control 
2) The query contains one or more tables with outer joins or 
inner joins using the ANSI format 
3) There is a GROUP BY above the joins 
 
Workaround: 
1) Convert the ANSI format inner join to a comma separated 
joins. 
2) Convert the outer join to an inner join with an IS NOT NULL 
predicate on the join column from the NULL producing table

**************************************************************** 
* USERS AFFECTED:                                              * 
* all editions                                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 10.5 Fix Pack 7                           * 
****************************************************************

First fixed in version 10.5 Fix Pack 7

not known / see Local fix

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

30.04.2015
20.01.2016
20.01.2016