Informix - Problembeschreibung
Problem IT11137 | Status: Geschlossen |
IF AUS_AGE IS SET TO 0 AUS_EVALUATOR GENERATES WRONG UST HIGH SQL STATEMENTS FOR SYSADMIN DATABASE | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
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 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.09.2015 19.01.2016 19.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC6 | |
Problem behoben lt. FixList in der Version | |
12.10.xC6 |