DB2 - Problembeschreibung
Problem IC75415 | Status: Geschlossen |
RUNSTATS via USE PROFILE collects inaccurate statistics after REDISTRIBUTE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
You may notice that table cardinality is calculated wrong when using statistics profile on a table after adding database partition(s) and performing a redistribute. The statistics collection (RUNSTATS) during REDISTRIBUTE does not update the user statistics profile's number of nodes. On the subsequent RUNSTATS USE PROFILE, DB2 looks at the user statistics profile number of nodes as indication of how many nodes the table is on. This causes incorrect external catalog statistics. In contrast the internal table packed descriptor cardinality value is correct. Hence this issue affects tools like REORGCHK, which is using the external statistics stored in the catalog tables. This issue does not affect the query compiler which relies on statistics stored in the internal packed descriptor of the table. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * see ERROR DESCRIPTION * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fix Pack 8. * **************************************************************** | |
Local-Fix: | |
Running an RUNSTATS 'update profile' or setting a new statistics profile after the REDISTRIBUTE helps to correct the number of nodes in the profile and get the correct table cardinality. | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 9.5 Fix Pack 8. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC75416 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 30.03.2011 01.07.2011 01.07.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP8 | |
Problem behoben lt. FixList in der Version | |
9.5.0.8 |