home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
14.10.xC12 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 IT09066 Status: Geschlossen

THE EFFECT ON SETTING AUS_AUTO_RULES=0 IS NOT CLEARLY DESCRIBED IN THE
DOCUMENTATION

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
AUS_AUTO_RULES is one of the configuration parameters for 
Automatic Update Statistics (AUS). 
 
The documentation explains about it: 
If enabled, statistics are updated using the higher of the 
following default minimum guidelines or user-created 
distribution options: 
 
    All tables are updated in LOW mode. 
    All the leading index keys are updated in HIGH mode. 
    All non-leading index keys are updated in MEDIUM mode. 
    The minimum resolution for MEDIUM mode is 2.0. 
    The minimum confidence for MEDIUM mode is 0.95. 
    The minimum resolution for HIGH mode is 0.5. 
 
If the UPDATE STATISTICS statement was run manually for a table, 
the UPDATE STATISTICS statements generated by the AUS 
maintenance system do not reduce the level, resolution, 
confidence, or sampling size options. 
 
If disabled, user-created distribution options are used. 
 
form 
http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com. 
ibm.perf.doc/ids_prf_756.htm 
the problem is the last sentence. 
 
What exactly does happen when AUS_AUTO_RULES is set to 0? 
What options will be used, and how will they be set.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Informix 11.70, 12.10                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* See Problem Conclusion                                       * 
****************************************************************
Local-Fix:
Lösung
If the AUS_AUTO_RULES parameter is disabled by being set to 0, 
the Auto Update Statistics maintenance system checks which 
columns have existing distributions and generates update 
statistics statements to refresh them.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.05.2015
30.12.2015
30.12.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
12.10.xC6 FixList