Informix - Problembeschreibung
Problem IT27507 | Status: Geschlossen |
THERE IS A CHANGE OF BEHAVIOR IN AUS BETWEEN 11.70.FC9 AND 12.10.FC9 IN THAT TABLES ARE INCLUDED THAT HAVE LITTLE ACTIVITY | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
Within 11.70.FC9 (and 12.10.FC10), the onconfig has the following settings: AUTO_STAT_MODE 1 STATCHANGE 0 And within sysadmin:ph_threshold these have been altered from the default values. AUS_AGE 20 AUS_PDQ 0 The observations seen after the migration is that the nightly AUS runs were taking longer than they did previously on the older IDS version. Investigations and analysis showed that tables that are large are being processed even though there has been very little changes to the Update/Delete/Insert (UDI) values. As the AUS is run nightly and there are many tables like this, then the AUS runs take much longer and impact the start of the day processing. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS 12.10.xC10 and older versions. * **************************************************************** * PROBLEM DESCRIPTION: * * There is a change of behavior in AUS between 11.70.FC9 and * * 12.10.FC9 meaning that tables are included even though there * * are small changes to UDI values. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 24.12.2018 07.10.2019 07.10.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC11 | |
Problem behoben lt. FixList in der Version |