APAR status
Closed as program error.
Error description
If a stored procedure is dropped and recreated while it is being executed by a different session, a stale entry can remain in the stored procedure cache. If this happens often and for a long time a huge memory leak can be produced in the procpool. onstat -g mem: Pool Summary: name class addr totalsize freesize #allocfrag #freefrag procpool V 33c17f040 7840239616 252531824 6298788 560734 onstat -g prc: UDR Cache: Number of lists : 31 PC_POOLSIZE : 127 UDR Cache Entries: list# id ref_cnt dropped? heap_ptr udr name -------------------------------------------------------------- 0 5064 1 1 10cf96838 d@shmprot:.p1 0 5051 2 1 10e774838 d@shmprot:.p1 0 5018 2 1 10e73ec38 d@shmprot:.p1 0 4973 1 1 10e71f038 d@shmprot:.p1 0 4964 3 1 10e717038 d@shmprot:.p1 ... 1 5046 2 1 10e770838 d@shmprot:.p1 1 5001 3 1 10e73a838 d@shmprot:.p1 1 4968 3 1 10e719438 d@shmprot:.p1 1 4946 3 1 10e702438 d@shmprot:.p1 ... ... 30 5036 2 1 10e767838 d@shmprot:.p1 30 5023 2 1 10e756038 d@shmprot:.p1 30 4990 3 1 10e734038 d@shmprot:.p1 ... Total number of udr entries: 37263 Number of entries in use : 37089
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * User running create and drop procedure in a loop or using * * multiple sessions * **************************************************************** * PROBLEM DESCRIPTION: * * When user runs create and drop procedure in a loop, server * * can leak memory and SPL entry still shows in the server * * cache. * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.50.xC8. * ****************************************************************
Problem conclusion
Fixed in 11.50.xC8.
Temporary fix
Comments
APAR Information
APAR number
IC70752
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-08-24
Closed date
2011-01-20
Last modified date
2011-01-20
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
IBM IDS ENTRP E
Fixed component ID
5724L2304
Applicable component levels
RB15 PSN
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":"B15","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
20 January 2011