APAR status
Closed as Permanent restriction.
Error description
If SQLTRACE is set to " level=high,ntraces=1000,size=2,mode=global" and if the task "Auto Update Statistics Refresh" is disabled and then enabled. calculation of tk_attributes and tk_next_execution fails and is blank in output of SQL "SELECT * FROM ph_task WHERE tk_name = 'Auto Update Statistics Refresh';"
Local fix
1. Stop IDS server 2. Set SQLTRACE back to level=off,ntraces=1000,size=1. 3. Start server. 4. Disabled and then enabled "Auto Update Statistics Refresh".
Problem summary
**************************************************************** * USERS AFFECTED: * * NONE * **************************************************************** * PROBLEM DESCRIPTION: * * NONE * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
SEE PROBLEM DESCRIPTION
Temporary fix
Comments
APAR Information
APAR number
IT32940
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
E10
Status
CLOSED PRS
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-05-20
Closed date
2022-10-20
Last modified date
2022-10-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10","Line of Business":[{"code":"LOB10","label":"Data and AI"}]}]
Document Information
Modified date:
20 October 2022