Informix - Problem description
Problem IT18274 | Status: Closed |
LOW MEMORY MANAGER: LOWMEMORYRECONFIG USES THE WRONG VALUE FOR SHMTOTAL | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
In the LowMemoryManager function, LowMemoryReconfig, we calculate shm values in order to activate actions when specific memory conditions are met. Unfortunately we use the wrong value for SHMTOTAL in these calculations. The function is defined as IF stop_threshold < start_threshold THEN LET stop_threshold = start_threshold * 2 ; END IF SELECT cf_effective INTO sh_total FROM sysmaster:sysconfig WHERE cf_name="SHMTOTAL"; LET used_limit = sh_total - (stop_threshold * 1024); SELECT sum(seg_blkused)*4096 INTO used_memory FROM sysmaster:sysseglst WHERE seg_class != 3; IF caller = "LMM" OR used_memory > used_limit THEN ..... so we calculate the threshold value for the memory which is in bytes. We calculate the used memory in the instance which is finally in bytes. And we select the value for SMHTOTAL from sysconfig but this value is in KB! The if clause for the trigger of activities when the memory is too low is more or less activated in each system all the time. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All current users of Informix 12.10.xC8 or older. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 12.10.xC9 when available * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.12.2016 10.07.2017 10.07.2017 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |