|
Problem IC73763
|
Status: Closed |
This APAR will limit the scope of the optimization added in IZ36539 |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* 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. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
First fixed in DB2 Version 9.5, Fixpack 8. |
| Workaround |
n/a |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC75208
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.01.2011
06.07.2011
06.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
