INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

When AUTO_STAT_MODE is enabled in the onconfig the system 
catalog table sysindices may not be filled with the statistics 
for an index after an UPDATE STATISTICS LOW. Only the nrows 
column will then have the value current at the time of the 
update statistics run, other columns like levels, leaves, 
nunique and cluster will not have any values. 
 
This can happen when the index is created in disabled mode like 
"CREATE INDEX index_name ON TABLE table_name(column) DISABLED" 
and the UPDATE STATISTICS LOW is run while it still is disabled. 
 
When you enable the index with "SET INDEXES FOR TABLE table_name 
ENABLED" and do an UPDATE STATISTICS LOW an active 
AUTO_STAT_MODE can prevent the statistics from being updated 
when not sufficiently many changes on the table did happen after 
the last UPDATE STATISTICS LOW (depending on the STATCHANGE 
setting in the configuration). 
 
Missing statistical information can lead to inappropriate query 
plans and hence to intolerable query run times. 
 
When you add the FORCE option to your UPDATE STATISTICS LOW run 
at a time when the indexes are enabled it will ensure the 
statistics to be gathered and written to sysindices, regardless 
of the AUTO_STAT_MODE and STATCHANGE settings.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10.xC6                      * 
****************************************************************

Problem Fixed In IBM Informix Server 12.10.xC6

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

10.02.2015
19.01.2016
19.01.2016

12.10.xC6