Informix - Problem description
Problem IT27507 | Status: Closed |
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 | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
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 Summary: | |
**************************************************************** * 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: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.12.2018 07.10.2019 07.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC11 | |
Problem solved according to the fixlist(s) of the following version(s) |