DB2 FOR LUW / DB2FORLUW / 970 - DB2

On the statistics collection during REDISTRIBUTE, after RUNSTATS 
updates the catalogs with 
 a) external catalog statistics and 
 b) a table packed descriptor (PD) with statistics, 
REDISTRIBUTE modifies the table packed descriptor to change the 
partition map. 
 
This subsequent update wipes out the changes to the PD that 
RUNSTATS did, resulting in incorrect internal packed descriptor 
statistics. 
 
Although the external SYSCAT.TABLES cardinality statistics will 
be correct, the incorrect internal packed descriptor will affect 
the query compiler estimates.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* This fix has been moved to DB2 V10.1 Fix Pack 1.             * 
****************************************************************

Gather new statistics after REDISTIRBUTE finished.

keiner bekannt / siehe Local-Fix

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

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

30.03.2011
27.06.2012
27.06.2012