DB2 FOR LUW / DB2FORLUW / 970 - 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.7, Fixpack 5.                       * 
****************************************************************

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

First fixed in DB2 Version 9.7, Fixpack 5.

n/a

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

23.03.2011
03.01.2012
03.01.2012

9.7.FP5