DB2 FOR LUW / DB2FORLUW / 970 - DB2

In a DPF environment, when a declared temporary table is created 
into a multi-dbpartition tablespace, data skew might lead to a 
situation where some dbpartitions do not have data.  This 
situation is more likely to occur when the table is small.  If 
statistics collection is performed from a dbpartition with no 
data, the query optimizer will plan the query based on the table 
being empty, which might lead to a poor access plan. 
 
This problem was first introduced in DB2 Version 9.7 Fix Pack 2.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SMALL DECLARED TEMPORARY TABLES IN DPF MIGHT HAVE POOR QUERY * 
* ACCESS PLAN                                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 Fixpack 5.                        * 
****************************************************************

Use a single dbpartition tablespace for small declared temporary 
tables.

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 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 version 9.7 Fixpack 5.

keiner bekannt / siehe Local-Fix

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

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

28.03.2011
09.01.2012
09.01.2012

9.7.FP5