DB2 FOR LUW / DB2FORLUW / 970 - DB2

You may notice that table cardinality is calculated wrong when 
using statistics profile on a table after adding database 
partition(s) and performing a redistribute. 
 
The statistics collection (RUNSTATS) during REDISTRIBUTE does 
not update the user statistics profile's number of nodes.  On 
the subsequent RUNSTATS USE PROFILE, DB2 looks at the user 
statistics profile number of nodes as indication of how many 
nodes the table is on. This causes incorrect external catalog 
statistics. 
 
In contrast the internal table packed descriptor cardinality 
value is correct. 
 
Hence this issue affects tools like REORGCHK, which is using the 
external statistics stored in the catalog tables. 
This issue does not affect the query compiler which relies on 
statistics stored in the internal packed descriptor of the 
table.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 5.                       * 
****************************************************************

Running an RUNSTATS 'update profile' or setting a new statistics 
profile after the REDISTRIBUTE helps to correct the number of 
nodes in the profile and get the correct table cardinality.

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 Version 9.7 Fix Pack 5.

keiner bekannt / siehe Local-Fix

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

30.03.2011
12.12.2011
12.12.2011

9.7.FP5