INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

If AUS_AGE is set to 0 the aus_evaluator task generates wrong
UST HIGH sql statements for sysadmin database.
The .. FORCE is missing for UPDATE STATISTICS MEDIUM/HIGH
statements.

example:

> truncate table aus_command;

Table truncated.

> EXECUTE FUNCTION sysadmin:exectask ("Auto Update Statistics
Evaluation");


(expression)

        2344

> select aus_cmd_exe from aus_command where aus_cmd_exe matches
"*informix.syscolumns*";



aus_cmd_exe  UPDATE STATISTICS LOW FOR TABLE
sysutils:informix.syscolumns FORCE


aus_cmd_exe  UPDATE STATISTICS HIGH FOR TABLE
sysutils:informix.syscolumns(tabi
             d,extended_id) RESOLUTION 0.50 DISTRIBUTIONS ONLY
FORCE

aus_cmd_exe  UPDATE STATISTICS MEDIUM FOR TABLE
sysutils:informix.syscolumns(co
             lno) RESOLUTION 2.00 0.95 DISTRIBUTIONS ONLY FORCE

aus_cmd_exe  UPDATE STATISTICS LOW FOR TABLE
sysuser:informix.syscolumns FORCE

aus_cmd_exe  UPDATE STATISTICS HIGH FOR TABLE
sysuser:informix.syscolumns(tabid
             ,extended_id) RESOLUTION 0.50 DISTRIBUTIONS ONLY
FORCE

aus_cmd_exe  UPDATE STATISTICS MEDIUM FOR TABLE
sysuser:informix.syscolumns(col
             no) RESOLUTION 2.00 0.95 DISTRIBUTIONS ONLY FORCE

aus_cmd_exe  UPDATE STATISTICS LOW FOR TABLE
sysadmin:informix.syscolumns FORCE


aus_cmd_exe  UPDATE STATISTICS HIGH FOR TABLE
sysadmin:informix.syscolumns(tabi
             d,extended_id) RESOLUTION 0.50 DISTRIBUTIONS ONLY

aus_cmd_exe  UPDATE STATISTICS MEDIUM FOR TABLE
sysadmin:informix.syscolumns(co
             lno) RESOLUTION 2.00 0.95 DISTRIBUTIONS ONLY

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

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

09.09.2015
19.01.2016
19.01.2016

12.10.xC6