APAR status
Closed as program error.
Error description
Situation: long running sessions which perform inserts and updates. If the where clause uses the columns of the composite index, then a memory leak is observed. This can be seen if the engine is started with "RALLOC_MODE POOL" and the program paused every 1000 iterations â ¦ onstat -g mem | grep ^31 31.H.sdrebi V 464d3040 4096 640 3 1 31*O0 V 463c9040 4096 768 1 1 31.H.ext V 45e30040 8192 864 23 1 31.H.ext V 46424040 16384 3392 42 1 31.H.sd V 45f95040 16384 3640 45 2 31.H.sd V 464e8040 274432 3280 2076 2 31 V 46459040 77824 4120 107 3 onstat -g afr 0x464e8040 | grep sqalloc.c:1949 | wc -l -> 2014 onstat -g mem | grep ^31 31.H.sdrebi V 46451040 4096 640 3 1 31*O0 V 463c9040 4096 768 1 1 31.H.ext V 45e30040 8192 864 23 1 31.H.ext V 467f9040 16384 3392 42 1 31.H.sd V 45f95040 16384 3640 45 2 31.H.sd V 464e8040 2834432 3280 22076 2 31 V 46459040 77824 4120 107 3 onstat -g afr 0x464e8040 | grep sqalloc.c:1949 | wc -l -> 22014 onstat -g mem | grep ^31 31.H.sdrebi V 46690040 4096 640 3 1 31*O0 V 463c9040 4096 768 1 1 31.H.ext V 45e30040 8192 864 23 1 31.H.ext V 46a06040 16384 3392 42 1 31.H.sd V 45f95040 16384 3640 45 2 31.H.sd V 464e8040 5394432 3280 42076 2 31 V 46459040 77824 4120 107 3 onstat -g afr 0x464e8040 | grep sqalloc.c:1949 | wc -l -> 42014 If the index is dropped, then the leak is not seen. The memory is returned to the server if the session exits.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * 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
IT33797
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-08-05
Closed date
2021-01-22
Last modified date
2024-09-24
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 September 2024