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 |