Memory Utilisation goin to 99 % in Informix

Hi , This is Mohan from LogicaCMG,Bangalore working in Reliability Engineering Team. I was referred to you by Mukesh Rijhwani. We have a problem with Informix 10FC5 on a Linux Setup.There are two Applications and Database(4 cpus) server. We find that the memory usage on the Database server is reaching out 99%. The memory size is 8GB and the virtual memory is set to 7GB,but still we find that the memory utilization reaches 99%.We have the same setup and patch level with HP-UX and we find that the memory utilization on Informix reaches only 75%. I will now attach the Onconfig file in this system. Please let me know if you require further details on the server. Thanks Mohan This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.

Hi, Attached the file! -Mohan. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Chandrasekaran, Mohan Sent: Friday, October 05, 2007 2:53 PM To: ids@iiug.org Subject: Memory Utilisation goin to 99 % in Informix [10047] Hi , This is Mohan from LogicaCMG,Bangalore working in Reliability Engineering Team. I was referred to you by Mukesh Rijhwani. We have a problem with Informix 10FC5 on a Linux Setup.There are two Applications and Database(4 cpus) server. We find that the memory usage on the Database server is reaching out 99%. The memory size is 8GB and the virtual memory is set to 7GB,but still we find that the memory utilization reaches 99%.We have the same setup and patch level with HP-UX and we find that the memory utilization on Informix reaches only 75%. I will now attach the Onconfig file in this system. Please let me know if you require further details on the server. Thanks Mohan This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

The Attachment is not coming thru ....find the file #*********************************************************************** *** # # Licensed Material - Property Of IBM # # "Restricted Materials of IBM" # # IBM Informix Dynamic Server # (c) Copyright IBM Corporation 1996, 2005 All rights reserved. # # Title: onconfig.std # Description: IBM Informix Dynamic Server Configuration Parameters # #*********************************************************************** *** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace nameROOTPATH /home/informix/databaselinks/rootdbs # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 262144 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirroredroot MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS rootdbs # Location (dbspace) of physical log PHYSFILE 16384 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 341 # Number of logical log files LOGSIZE 65536 # Logical log size (Kbytes)LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL, CONT) # Tablespace Tablespace Configuration in Root Dbspace TBLTBLFIRST 0 # First extent size (Kbytes) (0 = default) TBLTBLNEXT 0 # Next extent size (Kbytes) (0 = default) # Security # DBCREATE_PERMISSION: # By default any user can create a database. Uncomment DBCREATE_PERMISSON to # limit database creation to a specific user. Add a new DBCREATE_PERMISSION # line for each permitted user. #DBCREATE_PERMISSION informix # DB_LIBRARY_PATH: # When loading a (C or C++) shared object (for a UDR or UDT), IDS checks that # the user-specified path starts with one of the directory prefixes listed in # the comma-separated list of prefixes in DB_LIBRARY_PATH. The string # "$INFORMIXDIR/extend" must be included in DB_LIBRARY_PATH in order for # extensibility and IBM supplied blades to work correctly. # DB_LIBRARY_PATH $INFORMIXDIR/extend # IFX_EXTEND_ROLE: # 0 (or off) => Disable use of EXTEND role to control who can register # external routines. # 1 (or on) => Enable use of EXTEND role to control who can register # external routines. This is the default behaviour. # IFX_EXTEND_ROLE 1 # To control the usage of EXTEND role. # Diagnostics MSGPATH /home/informix/online.log # System message log file path CONSOLE /dev/console # System console message path # To automatically backup logical logs, edit alarmprogram.sh and set # BACKUPLOGS=Y ALARMPROGRAM /home/snadmin/bin/log_full.sh # Alarm program path ALRM_ALL_EVENTS 0 # Triggers ALARMPROGRAM for any eventoccur TBLSPACE_STATS 1 # Maintain tblspace statistics # System Archive Tape Device #TAPEDEV /usr/dbbackup/BMsubdetsdata # Tape device path #TAPEDEV /var/level0backup/level2backup #TAPEDEV /usr/dbbackup/bmlive22Junebkp #TAPEDEV /backup/dbbackup/27JunBM1DBBkp #TAPEDEV /level0backup/27JunBM1DBBkp #TAPEDEV /level0backup/03JulBM11DBBkp2 #TAPEDEV /level0backup/04JulBM11DBBkp3 #TAPEDEV /level0backup/09JulBM12AdlBkp3 #TAPEDEV /usr/dbbackup/09JulBM12AdlBkp3 #TAPEDEV /dbbackup2/dbbackup/18JulBMNoBlBk1 #TAPEDEV /dev/null #TAPEDEV /dbbackup/level0backup/psa4.0Lfree TAPEDEV /dbbackup/level0backup/psa4.0LPTbackup #TAPEDEV /level0backup/01JulBM11DBBkp TAPEBLK 64 # Tape block size (Kbytes) TAPESIZE 0 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device #LTAPEDEV /var/tmp/logicallogs # Log tape device path #LTAPEDEV /level0backup/lglogBM11Jul3bkp # Log tape device path #LTAPEDEV /dev/null # Log tape device path LTAPEDEV /dbbackup/level0backup/psa4.0Llogicallog # Log tape device path LTAPEBLK 64 # Log tape block size (Kbytes) LTAPESIZE 0 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server staging area # System Configuration SERVERNUM 1 # Unique id corresponding to a OnLineinstance DBSERVERNAME aeshm # Name of default database server DBSERVERALIASES aesoc # List of alternate dbservernames #NETTYPE soctcp,4,100,CPU # Configure pollthread(s) for nettype NETTYPE soctcp,4,100,NET # Configure pollthread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock indistributed env. RESIDENT 1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor NUMCPUVPS 4 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vpsto one NOAGE 0 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters #LOCKS 100000 # Maximum number of locks LOCKS 50000 # Maximum number of locks#BUFFERS 200000 BUFFERPOOL size=2K,buffers=1500000,lrus=64,lru_min_dirty=0.500000,lru_max_dirty=1.000000 BUFFERPOOL size=default,buffers=1500000,lrus=64,lru_min_dirty=0.500000,lru_max_dirt y=1.000000 NUMAIOVPS 16 # Number of IO vpsLOGSMAX 1024 PHYSBUFF 256 # Physical log buffer size (Kbytes) LOGBUFF 256 # Logical log buffer size (Kbytes) CLEANERS 16 # Number of buffer cleaner processes SHMBASE 0x44000000L # Shared memory base address#SHMVIRTSIZE 131072 # initial virtual shared memory segment size SHMVIRTSIZE 1632835 # initial virtual shared memory segmentsize #SHMADD 65536 # Size of new shared memory segments (Kbytes) SHMADD 1632835 # Size of new shared memory segments (Kbytes) EXTSHMADD 8192 # Size of new extension shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 300 # Check point interval (in sec) TXTIMEOUT 300 # Transaction timeout (in sec) STACKSIZE 64 # Stack size (Kbytes) # Dynamic Logging # DYNAMIC_LOGS: # 2 : server automatically add a new logical log when necessary. (ON) # 1 : notify DBA to add new logical logs when necessary. (ON) # 0 : cannot add logical log on the fly. (OFF) # # When dynamic logging is on, we can have higher values for LTXHWM/LTXEHWM, # because the server can add new logical logs during long transaction rollback. # However, to limit the number of new logical logs being added, LTXHWM/LTXEHWM # can be set to smaller values. # # If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values # to avoid long transaction rollback hanging the server due to lack of logical # log space, i.e. 50/60 or lower. # # In case of system configured with CDR, the difference between LTXHWM and # LTXEHWM should be atleast 30% so that we could minimize log overrun issue. DYNAMIC_LOGS 2 LTXHWM 70 LTXEHWM 80 # System Page Size # BUFFSIZE - OnLine no longer supports this configuration parameter. # To determine the page size used by OnLine on your platform # see the last line of output from the command, 'onstat -b'. # Recovery Variables # OFF_RECVRY_THREADS:@@