DB2 FOR LUW / DB2FORLUW / 950 - DB2

This APAR will limit the scope of the optimization added in 
IZ36539, which attempts to push down group-by subquery through 
outer-join subquery, when all of the following conditions are 
met - 
 
1. Database Partitioning Feature (DPF) 
2. Group-by subquery is not a scalar subquery. 
3. The group-by subquery and outer-join subquery are fed to a 
   common inner join operator. This inner join operator has at 
   least another input stream, called subq3. 
4. Group-by subquery and subq3 have equality join predicate.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users affected by APAR IZ36539.                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* This APAR will limit the scope of the optimization added in  * 
* IZ36539 as described in the "ERROR DESCRIPTION" section.     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5, Fixpack 8.                       * 
****************************************************************

DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 9.5, Fixpack 8.

n/a

Vorgänger  : APAR is sysrouted TO one or more of the following: IC75208 
Nachfolger : 

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

10.01.2011
06.07.2011
06.07.2011

9.5.FP8