home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT05306 Status: Closed

PERFORMANCE OF A STORED PROCEDURE PROGRESSIVELY DECREASES WHEN RUN MANY
TIMES, CAUSING A MEMORY LEAK IN RALLOC SESSION MEMORY

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem 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.
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.    * 
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
31.10.2014
30.12.2015
30.12.2015
Problem solved at the following versions (IBM BugInfos)
12.10.xC6
Problem solved according to the fixlist(s) of the following version(s)
12.10.xC6 FixList