DB2 FOR LUW / DB2FORLUW / 970 - DB2

Query performance may be poor when the query contains at least 
three (3) tables joined together using INNER or OUTER joins and 
there are at least 2 equal join predicates and at least two 
local equality predicate. 
 
  The last table in the join sequence must have multicolumn 
index covering the columns involved in the predicates. The 
equality join predicates must be applicable on the first and 
last columns of the index with the local eer quality predicate 
applicable on the intermediate columns of the index. 
 
  Under these conditions the optimizer may incorrectly calculate 
the cost of the joins leading to a poorly performing plan.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 fixpack 9                         * 
****************************************************************

Use an optimization profile to obtain a better join order 
  or 
  Change the index definition so that the join predicate are 
applicable to either the leading or trailing columns of the 
index without any intermediate local equality predicates.

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
 

Problem was first fixed in DB2 version 9.7 fixpack 9

keiner bekannt / siehe Local-Fix

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

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

21.01.2013
30.12.2013
30.12.2013

9.7.FP9