DB2 - Problembeschreibung
Problem IC80723 | Status: Geschlossen |
RUNSTATS USING PROFILE DOES NOT USE SAMPLING ON INDEX STATISTICS COLLECTION. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When a profile is used for runstats, then if the profile was created with "sampled" indexes , the sampling will not occur on the indexes. This can lead to slower than expected runstats execution. e.g. runstats on table db2inst1.staff for sampled detailed index db2inst1.idx1 set profile only followed by : runstats on table db2inst1.staff use profile will effectively internally execute : runstats on table db2inst1.staff for detailed index db2inst1.idx1; | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade the DB2 server to V9.7 Fix Pack 6 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Lösung | |
This problem has first been fixed in V9.7 Fix Pack 6 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.01.2012 22.06.2012 22.06.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP6 | |
Problem behoben lt. FixList in der Version | |
9.7.0.6 |