home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC66296 Status: Geschlossen

COMPRESSION STATISTIC PCTPAGESSAVED MAY BE INACCURATE.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users on V9.7 Fix Pack 1 and Below                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* 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.                                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V9.7  Fix Pack 2 or above                         * 
****************************************************************
Local-Fix:
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
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows

Lösung
First fixed in V9.7 Fix Pack 2
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
12.02.2010
12.08.2010
12.08.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.,
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList