Informix - Problembeschreibung
Problem IC85223 | Status: Geschlossen |
DISTRIBUTIONS QUICKLY GROW STALE ON AUS_COMMAND TABLE AND SLOWS AUS_REFRESH TASK | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problembeschreibung: | |
You have a system with a large number of user tables. The automatic update statistics refresh (AUS refresh) runs slowly. You execute update statistics high on the aus_command table and refresh executes much more quickly. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Performance improvement, worked by now it runs much faster * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.70.xC6. * **************************************************************** | |
Local-Fix: | |
Execute update statistics high on sysadmin:aus_command | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Kommentar | |
http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp For download information, go to: http://www.ibm.com/support/fixcentral | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 10.07.2012 30.10.2012 30.10.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
11.70.xC6 | |
Problem behoben lt. FixList in der Version | |
10.1.xC0 | |
10.5.xC0 | |
11.70.xC7 |