suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    das ultimative Tool für Informix

    pfeil  
Neueste VersionenFixList
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
Informix EditionenInformix Editionen
Informix Editionen
DokumentationDokumentation
Dokumentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download