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