APAR status
Closed as program error.
Error 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 ----- <SPL(db1:532), stmt(1):SELECT > 461bf850 12968 ----- <SPL(db1:532), stmt(3):SELECT > 461bfb08 12968 ----- <SPL(db1:532), stmt(5):SELECT > 461bfdc0 13000 ----- <SPL(db1:532), stmt(7):SELECT > 461c0078 12992 ----- <SPL(db1:532), stmt(9):SELECT > 461c0330 12968 ----- <SPL(db1:532), stmt(11):SELECT > 461c05e8 12992 ----- <SPL(db1:532), stmt(13):SELECT > 461c08a0 12968 ----- <SPL(db1:532), stmt(15):SELECT > 461c0b58 12968 ----- <SPL(db1:532), stmt(17):SELECT > 461c0e10 12968 ----- <SPL(db1:532), stmt(19):SELECT > 461c10c8 12968 ----- <SPL(db1:532), stmt(21):SELECT > 461c1380 12968 ----- <SPL(db1:532), stmt(23):SELECT > 461c1638 12968 ----- <SPL(db1:532), stmt(25):SELECT > 461c18f0 12968 ----- <SPL(db1:532), stmt(27):SELECT > 4643f028 12992 ----- <SPL(db1:532), stmt(29):SELECT > 4643f2e0 12992 ----- <SPL(db1:532), stmt(1):SELECT > 4643f598 12992 ----- <SPL(db1:532), stmt(3):SELECT > 4643f850 12968 ----- <SPL(db1:532), stmt(5):SELECT > 4643fb08 12968 ----- <SPL(db1:532), stmt(7):SELECT > 4643fdc0 12968 ----- <SPL(db1:532), stmt(9):SELECT > 46440078 12968 ----- <SPL(db1:532), stmt(11):SELECT > 46440330 12968 ----- <SPL(db1:532), stmt(13):SELECT > 464405e8 12968 ----- <SPL(db1:532), stmt(15):SELECT > 464408a0 12968 ----- <SPL(db1:532), stmt(17):SELECT > 46440b58 12968 ----- <SPL(db1:532), stmt(19):SELECT > 46440e10 12992 ----- <SPL(db1:532), stmt(21):SELECT > 464410c8 12968 ----- <SPL(db1:532), stmt(23):SELECT > 46441380 12968 ----- <SPL(db1:532), stmt(25):SELECT > 46441638 12968 ----- <SPL(db1:532), stmt(27):SELECT > 464418f0 12968 ----- <SPL(db1:532), stmt(29):SELECT > 465f5028 13016 ----- <SPL(db1:532), stmt(1):SELECT > 465f52e0 12968 ----- <SPL(db1:532), stmt(3):SELECT > 465f5598 12968 ----- <SPL(db1:532), stmt(5):SELECT > ...
Local fix
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 ----- <SPL(db1:532), * * stmt(1):SELECT * * > * * 461bf850 12968 ----- <SPL(db1:532), * * stmt(3):SELECT * * > * * 461bfb08 12968 ----- <SPL(db1:532), * * stmt(5):SELECT * * > * * 461bfdc0 13000 ----- <SPL(db1:532), * * stmt(7):SELECT * * > * * 461c0078 12992 ----- <SPL(db1:532), * * stmt(9):SELECT * * > * * 461c0330 12968 ----- <SPL(db1:532), * * stmt(11):SELECT > * * 461c05e8 12992 ----- <SPL(db1:532), * * stmt(13):SELECT > * * 461c08a0 12968 ----- <SPL(db1:532), * * stmt(15):SELECT > * * 461c0b58 12968 ----- <SPL(db1:532), * * stmt(17):SELECT > * * 461c0e10 12968 ----- <SPL(db1:532), * * stmt(19):SELECT > * * 461c10c8 12968 ----- <SPL(db1:532), * * stmt(21):SELECT > * * 461c1380 12968 ----- <SPL(db1:532), * * stmt(23):SELECT > * * 461c1638 12968 ----- <SPL(db1:532), * * stmt(25):SELECT > * * 461c18f0 12968 ----- <SPL(db1:532), * * stmt(27):SELECT > * * 4643f028 12992 ----- <SPL(db1:532), * * stmt(29):SELECT > * * 4643f2e0 12992 ----- <SPL(db1:532), * * stmt(1):SELECT * * > * * 4643f598 12992 ----- <SPL(db1:532), * * stmt(3):SELECT * * > * * 4643f850 12968 ----- <SPL(db1:532), * * stmt(5):SELECT * * > * * 4643fb08 12968 ----- <SPL(db1:532), * * stmt(7):SELECT * * > * * 4643fdc0 12968 ----- <SPL(db1:532), * * stmt(9):SELECT * * > * * 46440078 12968 ----- <SPL(db1:532), * * stmt(11):SELECT > * * 46440330 12968 ----- <SPL(db1:532), * * stmt(13):SELECT > * * 464405e8 12968 ----- <SPL(db1:532), * * stmt(15):SELECT > * * 464408a0 12968 ----- <SPL(db1:532), * * stmt(17):SELECT > * * 46440b58 12968 ----- <SPL(db1:532), * * stmt(19):SELECT > * * 46440e10 12992 ----- <SPL(db1:532), * * stmt(21):SELECT > * * 464410c8 12968 ----- <SPL(db1:532), * * stmt(23):SELECT > * * 46441380 12968 ----- <SPL(db1:532), * * stmt(25):SELECT > * * 46441638 12968 ----- <SPL(db1:532), * * stmt(27):SELECT > * * 464418f0 12968 ----- <SPL(db1:532), * * stmt(29):SELECT > * * 465f5028 13016 ----- <SPL(db1:532), * * stmt(1):SELECT * * > * * 465f52e0 12968 ----- <SPL(db1:532), * * stmt(3):SELECT * * > * * 465f5598 12968 ----- <SPL(db1:532), * * stmt(5):SELECT * * > * * ... * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * ****************************************************************
Problem conclusion
Fixed in Informix Server 12.10.xC15 and 14.10.xC5.
Temporary fix
Comments
APAR Information
APAR number
IT34088
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-09-02
Closed date
2021-01-28
Last modified date
2021-01-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Line of Business":{"code":null,"label":null},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]
Document Information
Modified date:
29 January 2021