APAR status
Closed as fixed if next.
Error description
Select on sysmaster database is more than 100 times slower after upgrade to 12.10. Customer has a lot of databases and tables (total about 500-700 thousand partitions). After upgrade from 11.50 to 12.10 all is going slower. Found following: select count(*) from sysmaster:systabnames; 11.50.FC9 Tables 200 2000 20000 200000 runtime 2.880s 2.279s 3.222s 6.517s 12.10.FC4W1 Tables 200 2000 20000 200000 runtime 4.633s 10.334s 227.489s 1057.387s
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * user of informix database server * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to 12.10.xC5 * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IT09622
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-06-23
Closed date
2015-12-30
Last modified date
2015-12-30
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
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:
30 December 2015