DB2 FOR LUW / DB2FORLUW / 970 - DB2

On rare occasions, DB2 may determine a negative statistical 
value. 
 
This problem is dependent on the data values used to determine 
the statistics.  When the problem occurs, it is likely to occur 
for a table that has a large number of rows, statistically in 
the order of 2^32. 
 
Negative statistical values may lead the query compiler to 
determine a poor access plan. 
 
The following column and column group statistics can observe the 
problem: 
 
syscat.columns.colcard 
syscat.colgroups.colgroupcard 
 
For parititioned indexes, the following index statistics can 
observe the problem: 
 
syscat.indexes.firstkeycard 
syscat.indexes.first2keycard 
syscat.indexes.first3keycard 
syscat.indexes.first4keycard 
syscat.indexes.fullkeycard

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL USERS on DB2 v97 FP5 and earlier                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* UPgrade to DB2 v97 FP6                                       * 
****************************************************************

There is no workaround for the index statistics. 
 
For the column and column group statistics, it is possible that 
a slight change in the data set might avoid the problem. 
 
If not using the TABLESAMPLE option for RUNSTATS command, try 
the TABLESAMPLE option. 
If using the TABLESAMPLE option for RUNSTATS command, try a 
different sample size, sampling method, or repeatable seed.

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 V97 FP6

keiner bekannt / siehe Local-Fix

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

25.11.2011
14.06.2012
14.06.2012

9.7.FP6