APAR status
Closed as fixed if next.
Error description
You might observe that a stored procedure, called many times with different variables, progressively gets slower with each call. Apart from the decreased performance, you might also observe an increase in the session memory's ralloc pool. After an 'update statistics for procedure', the procedure is fast but will once again start to progressively get slower.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * fixed in 12.10.xC6 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Problem is fixed in 12.10.xC6 and confirmed by submitter. * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IT05306
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-10-31
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":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
30 December 2015