DB2 - Problembeschreibung
Problem IC92524 | Status: Geschlossen |
COLLECTING INDEX-ONLY STATISTICS CAN INCORRECTLY UPDATE SYSCAT.COLUMNS.NQUANTILES AND SYSCAT.COLUMNS.NMOSTFREQ TO -1. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - 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 V9.7 FP9 * **************************************************************** | |
Local-Fix: | |
Perform a table and indexes statistics collection on the affected tables. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
Fixed in DB2 V9.7 FP9 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC95347 IC98550 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.05.2013 17.12.2013 17.12.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP9 | |
Problem behoben lt. FixList in der Version | |
9.7.0.9 | |
9.7.0.9 |