APAR status
Closed as program error.
Error description
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
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 * ****************************************************************
Problem conclusion
Problem Fixed In IBM Informix Server 12.10.xC6
Temporary fix
Comments
APAR Information
APAR number
IT11137
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-09-09
Closed date
2016-01-19
Last modified date
2016-01-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
RA10 PSN
UP
RA10 PSY
UP
RB10 PSN
UP
RB10 PSY
UP
RB50 PSN
UP
RB50 PSY
UP
RB70 PSN
UP
RB70 PSY
UP
RC10 PSN
UP
RC10 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
19 January 2016