DB2 FOR LUW / DB2FORLUW / A50 - DB2

The DB2 optimizer might produce a non-optimal access plan when 
all of the conditions below are met 
 
(1) in a DPF environment 
(2) DB2_WORKLOAD=SAP registry variable is set 
(3) queries fit the required criteria for the star schema join 
(4) At least one of the join columns on the fact table has 
highly skewed data distribution. 
 
When this problem is encountered, the optimizer can 
under-estimate the join cardinality and subsequently choose a 
sub-optimal query plan.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DPF environment                                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 7                       * 
****************************************************************

create a statistical view to cover the joins

keiner bekannt / siehe Local-Fix

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

05.01.2015
22.01.2016
22.01.2016