DB2 FOR LUW / DB2FORLUW / A10 - DB2

Query containing UNION ALL join, may perform badly due to 
statistics which prevent the push down of joins. 
 
This is a costing issue. The push-down makes progress only when 
query rewrite thinks the estimated join cardinality is not more 
than the outer LEFT OUTER JOIN.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Users on DB2 V101 FP3 and earlier                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v101 FP4                                      * 
****************************************************************

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First Fixed in db2 v101 FP4

keiner bekannt / siehe Local-Fix

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

19.11.2013
04.06.2014
04.06.2014