DB2 - Problembeschreibung
Problem IC95347 | Status: Geschlossen |
COLLECTING INDEX-ONLY STATISTICS CAN INCORRECTLY UPDATE SYSCAT.COLUMNS.NQUANTILES AND SYSCAT.COLUMNS.NMOSTFREQ TO -1. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
If a column has distribution statistics and it is the leading column in an index, collecting index-only statistics for the index will incorrectly update SYSCAT.COLUMNS.NQUANTILES and SYSCAT.COLUMNS.NMOSTFREQ to -1, suggesting the column does not have distribution statistics. However, the column's distribution statistics are not affected in the SYSCAT.SYSCOLDIST catalog. Also not affected are the distribution statistics in the table's packed descriptor which is used by the query optimizer. The problem therefore affects applications that query SYSCAT.COLUMNS.NQUANTILES and SYSCAT.COLUMNS.NMOSTFREQ, instead of SYSCAT.SYSCOLDIST, to determine if a column has distribution statistics. The db2look tool is affected by this problem. When the problem has occurred, db2look mimic output will not contain distribution statistics information for the affected columns. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 v10.5 FP3 * **************************************************************** | |
Local-Fix: | |
Perform a table and indexes statistics collection on the affected tables. | |
Lösung | |
Problem Fixed In DB2 v10.5 FP3 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.08.2013 21.04.2014 21.04.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |