• Admin-Scout-small-Banner
           
    CURSOR Admin-Scout
    get the ultimate tool for Informix
    pfeil  
invispix 10x10
invispix 10x10
Latest versionsfixlist
14.10.xC5 FixList
12.10.xC14.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
Question in the chat LiveZilla Live Help

Informix - Problem description

Problem IT34088 Status: Closed

INCREASED SESSION MEMORY USAGE DUE TO STATEMENTS INSIDE STORED PROCEDURES
NOT BEING FREED

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
t appears that statement descriptor blocks for statements inside
stored procedures may not be getting freed correctly.  This can
be seen via large amounts of statements in the onstat -g stm
output for a session, along with increased memory usage for the
session.

onstat -g stm:

IBM Informix Dynamic Server Version 12.10.FC12W1XQ -- On-Line --
Up 00:00:49 -- 549724 Kbytes

session 9
---------------------------------------------------------------
sdblock          heapsz     flags statement ('*' = Open cursor)
461bf028         7712       ----- *execute procedure p1()
461bf2e0         7712       ----- *execute procedure p1()
461bf598         13024      -----  
461bf850         12968      -----  
461bfb08         12968      -----  
461bfdc0         13000      -----  
461c0078         12992      -----  
461c0330         12968      -----  
461c05e8         12992      -----  
461c08a0         12968      -----  
461c0b58         12968      -----  
461c0e10         12968      -----  
461c10c8         12968      -----  
461c1380         12968      -----  
461c1638         12968      -----  
461c18f0         12968      -----  
4643f028         12992      -----  
4643f2e0         12992      -----  
4643f598         12992      -----  
4643f850         12968      -----  
4643fb08         12968      -----  
4643fdc0         12968      -----  
46440078         12968      -----  
46440330         12968      -----  
464405e8         12968      -----  
464408a0         12968      -----  
46440b58         12968      -----  
46440e10         12992      -----  
464410c8         12968      -----  
46441380         12968      -----  
46441638         12968      -----  
464418f0         12968      -----  
465f5028         13016      -----  
465f52e0         12968      -----  
465f5598         12968      -----  
...
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC5.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* It appears that statement descriptor blocks for statements   *
* inside                                                       *
* stored procedures may not be getting freed correctly.  This  *
* can                                                          *
* be seen via large amounts of statements in the onstat -g stm *
* output for a session, along with increased memory usage for  *
* the                                                          *
* session.                                                     *
*                                                              *
* onstat -g stm:                                               *
*                                                              *
* IBM Informix Dynamic Server Version 12.10.FC12W1XQ --        *
* On-Line --                                                   *
* Up 00:00:49 -- 549724 Kbytes                                 *
*                                                              *
* session 9                                                    *
* ------------------------------------------------------------ *
* ---                                                          *
* sdblock          heapsz     flags statement ('*' = Open      *
* cursor)                                                      *
* 461bf028         7712       ----- *execute procedure p1()    *
* 461bf2e0         7712       ----- *execute procedure p1()    *
* 461bf598         13024      -----                                                              *
* 461bf850         12968      -----                                                              *
* 461bfb08         12968      -----                                                              *
* 461bfdc0         13000      -----                                                              *
* 461c0078         12992      -----                                                              *
* 461c0330         12968      -----                                              *
* 461c05e8         12992      -----                                              *
* 461c08a0         12968      -----                                              *
* 461c0b58         12968      -----                                              *
* 461c0e10         12968      -----                                              *
* 461c10c8         12968      -----                                              *
* 461c1380         12968      -----                                              *
* 461c1638         12968      -----                                              *
* 461c18f0         12968      -----                                              *
* 4643f028         12992      -----                                              *
* 4643f2e0         12992      -----                                                              *
* 4643f598         12992      -----                                                              *
* 4643f850         12968      -----                                                              *
* 4643fb08         12968      -----                                                              *
* 4643fdc0         12968      -----                                                              *
* 46440078         12968      -----                                              *
* 46440330         12968      -----                                              *
* 464405e8         12968      -----                                              *
* 464408a0         12968      -----                                              *
* 46440b58         12968      -----                                              *
* 46440e10         12992      -----                                              *
* 464410c8         12968      -----                                              *
* 46441380         12968      -----                                              *
* 46441638         12968      -----                                              *
* 464418f0         12968      -----                                              *
* 465f5028         13016      -----                                                              *
* 465f52e0         12968      -----                                                              *
* 465f5598         12968      -----                                                              *
* ...                                                          *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC15 (when available) or    *
* 14.10.xC5.                                                   *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
02.09.2020
28.01.2021
28.01.2021
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
invispix 10x10
invispix 10x10
invispix 10x10
Technical InfoTechnical Info

Technical Info

DocumentationDocumentation

Documentation

IBM NewsletterIBM Newsletter

IBM Newsletter

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

Release NotesRelease Notes

Release Notes

Machine NotesMachine Notes

Machine Notes

Release NewsRelease News

Release News

Product LifecycleProduct Lifecycle

Lifecycle

Media DownloadMedia Download

Media Download

invispix 10x10
Service und SupportService und Support

Service and Support

Informix MonitoringInformix Monitoring

Informix Monitoring

Admin-Scout forInformixAdmin-Scout forInformix

Admin-Scout for Informix

Informix News & InfosInformix News & Infos

Informix News & Infos

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.