DB2 FOR LUW / DB2FORLUW / 950 - DB2

If query has a local predicate on top of a left outer join 
block, and if the local predicate refers to columns output from 
the inner stream of the left outer join operator, then this left 
outer join can be converted to inner join. This will give the 
query more opportunities to be optimized by other DB2 
transformations. 
 
For example, a left outer join query is 
select * from table1 left outer join table2 on table1.col1 = 
table2.col1 where table2.col2 = 1 or table2.col3 = 1; 
 
DB2 query rewrite will automatically change it to 
select * from table1 inner join table2 on table1.col1 = 
table2.col1 where table2.col2 = 1 or table2.col3 = 1;

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.5 Fix Pack 5.                           * 
****************************************************************

Rewrite the query statement.

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

Problem first fixed in Version 9.5 Fix Pack 5.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC61930 
follow-up : 

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

08.07.2009
18.01.2010
18.01.2010

9.5.FP5