DB2 FOR LUW / DB2FORLUW / 980 - DB2

PCTPAGESSAVED is set to 0 when RUNSTATS is executed on just the 
indexes of the table via the FOR INDEXES clause, for example: 
    RUNSTATS ON TABLE s.t  FOR INDEXES ALL 
 
Under rare situations, incorrect intermediate calculations can 
lead to an inaccurate PCTPAGESSAVED value, including 0 and 
negative values.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.8 FP3 or Subsequent Fix Pack                * 
****************************************************************

Determine compression benefit from other compression statistics 
PCTROWSCOMPRESSED and AVGROWCOMPRESSIONRATIO. 
 
If PCTPAGESSAVED is 0 after an index-only RUNSTATS operation, 
collect statistics again, ensuring to collect statistics for the 
table as well as its indexes, for example: 
    RUNSTATS ON TABLE s.t  AND INDEXES ALL

DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

Problem First Fixed in DB2 Version 9.8 Fix Pack 3

keiner bekannt / siehe Local-Fix

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

12.03.2010
10.12.2012
10.12.2012

9.8.FP3