DB2 FOR LUW / DB2FORLUW / 970 - 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 V97 FP8 and earlier                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V97 FP9                                       * 
****************************************************************

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
 

First Fixed in DB2 V97 FP9

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC97757 IC97760 
Nachfolger : 

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

01.06.2012
17.12.2013
17.12.2013

9.7.FP9