DB2 - Problembeschreibung
Problem IT00500 | Status: Geschlossen |
AVGLEAFKEYSIZE AND AVGNLEAFKEYSIZE ARE INCORRECT WHEN RUNSTATS USING INDEXSAMPLE SYSTEM | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
When using "INDEXSAMPLE SYSTEM" to collect index statistics, the RUNSTATS utility can generate inacurrate AVGLEAFKEYSIZE and AVGNLEAFKEYSIZE. This problem affects the REORGCHK utility which uses the AVGLEAFKEYSIZE and AVGNLEAFKEYSIZE statistical values. For example: RUNSTATS ON TABLE MYSCHEMA.MYTABLE AND INDEXES ALL INDEXSAMPLE SYSTEM (10.000000) This runstats command results in: AVGLEAFKEYSIZE AVGNLEAFKEYSIZE -------------- --------------- 5 5 Compare to: RUNSTATS ON TABLE MYSCHEMA.MYTABLE AND INDEXES ALL ; AVGLEAFKEYSIZE AVGNLEAFKEYSIZE -------------- --------------- 53 53 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 Fix Pack 5. * **************************************************************** | |
Local-Fix: | |
Lösung | |
First fixed in DB2 Version 10.1 Fix Pack 5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.03.2014 23.07.2015 23.07.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |