How can I use 32Gb of ram in IDS 9.4

I have IDS9.4 on Suze 8.2 on a IBM 445 with 8 CPU and 32 Gb of ram How Can I use more of the Ram ? I have tried playing around with buffers but if I go past 280000 the instance dosn't come on like and complains : Segment locked: addr=0x44000000, size=1450098688 shmat: [ENOMEM][12]: out of available data space, check system memory parameters (e.g. MAXMEM) My onconfig is : IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 02:37:54 --2026892 Kbytes Configuration File: /app/informix/etc/onconfig.actrol #************************************************************************** # # IBM Corporation # # Title: onconfig.actrol # Description: IBM Informix Dynamic Server Configuration Parameters # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /database/chunk01 # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 2097152 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration # PHYSDBS rootdbs # Location (dbspace) of physical log PHYSDBS physlogdbs # Location (dbspace) of physical log # PHYSFILE 200000 # Physical log file size (Kbytes) PHYSFILE 10000000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 2500 # Number of logical log files LOGSIZE 10000 # Logical log size (Kbytes) # Diagnostics MSGPATH /database/online.log # System message log file path CONSOLE /dev/null # System console message path # To automatically backup logical logs, edit alarmprogram.sh and set # BACKUPLOGS=Y ALARMPROGRAM /app/informix/etc/alarmprogram.sh # Alarm program path TBLSPACE_STATS 1 # Maintain tblspace statistics # System Archive Tape Device TAPEDEV /dev/nst0 # Tape device path # TAPEDEV /dev/null # Tape device path TAPEBLK 128 # Tape block size (Kbytes) TAPESIZE 21470000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/zero # Log tape device path#LTAPEDEV /dev/null # Log tape device path LTAPEBLK 128 # Log tape block size (Kbytes) LTAPESIZE 214700000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server staging area # System Configuration SERVERNUM 0 # Unique id corresponding to a OnLine instance DBSERVERNAME sage # Name of default database server # DBSERVERALIASES sage_tcp,sage_ext,sage_stream # List of alternatedbservernames DBSERVERALIASES sage_tcp,sage_ext # List of alternate dbservernames NETTYPE ipcshm,1,800,CPU # Configure poll thread(s) for nettype # NETTYPE ipcshm,1,400,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,1,600,NET # Configure poll thread(s) for nettype NETTYPE soctcp,1,600,NET # Configure poll thread(s) for nettype # NETTYPE soctcp,1,400,NET # Configure poll thread(s) for nettype # NETTYPE soctcp,1,400,NET # Configure poll thread(s) for nettype # NETTYPE ipcstr,1,400,CPU # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT -1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 4 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters #LOCKS 2000000 # Maximum number of locks LOCKS 2500000 # Maximum number of locks BUFFERS 280000 # Maximum number of shared buffers#BUFFERS 1120000 # Maximum number of shared buffers #BUFFERS 560000 # Maximum number of shared buffers NUMAIOVPS 10 # Number of IO vps PHYSBUFF 256 # Physical log buffer size (Kbytes) LOGBUFF 256 # Logical log buffer size (Kbytes) CLEANERS 3 # Number of buffer cleaner processes SHMBASE 0x44000000 # Shared memory base address#SHMBASE 0x10000000 # Shared memory base address SHMVIRTSIZE 1200000 # initial virtual shared memory segment size SHMADD 200000 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 900 # Check point interval (in sec) LRUS 200 # Number of LRU queues LRU_MAX_DIRTY 5.500000 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 3.500000 # LRU percent dirty end cleaning limit TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 32 # 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. DYNAMIC_LOGS 2 LTXHWM 70 #LTXHWM 92 LTXEHWM 80#LTXEHWM 98 # 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: # Number of parallel worker threads during fast recovery or an offline restore. # ON_RECVRY_THREADS: # Number of parallel worker threads during an online restore. OFF_RECVRY_THREADS 10 # Default number of offline worker threads ON_RECVRY_THREADS 1 # Default number of online worker threads # Data Replication Variables DRINTERVAL 30 # DR max time between DR buffer flushes (in sec) DRTIMEOUT 30 # DR network timeout (in sec) DRLOSTFOUND /app/informix/etc/dr.lostfound # DR lost+found file path # CDR Variables CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional) CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds) CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kbytes) CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max) CDR_SERIAL 0,0 # Serial Column Sequence CDR_DBSPACE # dbspace for syscdr database CDR_QHDR_DBSPACE # CDR queue dbspace (default same as catalog) CDR_QDATA_SBSPACE # List of CDR queue smart blob spaces # CDR_MAX_DYNAMIC_LOGS # -1 => unlimited # 0 => disable dynamic log addition # >0 => limit the no. of dynamic log additions with the specified value. # Max dynamic log requests that CDR can make within one server session. CDR_MAX_DYNAMIC_LOGS 0 # Dynamic log addition disabled by default # Backup/Restore variables BAR_ACT_LOG /app/informix/bar_act.log # ON-Bar Log file - not in /tmp please BAR_DEBUG_LOG /app/informix/bar_dbug.log @@NL

You're not using a 64 bit version. Is there a 9.40.FCn version available? Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of BRETT SIMPSON Sent: Wednesday, May 12, 2010 9:24 PM To: ids@iiug.org Subject: How can I use 32Gb of ram in IDS 9.4 [20124] I have IDS9.4 on Suze 8.2 on a IBM 445 with 8 CPU and 32 Gb of ram How Can I use more of the Ram ? I have tried playing around with buffers but if I go past 280000 the instance dosn't come on like and complains : Segment locked: addr=0x44000000, size=1450098688 shmat: [ENOMEM][12]: out of available data space, check system memory parameters (e.g. MAXMEM) My onconfig is : IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 02:37:54 --2026892 Kbytes Configuration File: /app/informix/etc/onconfig.actrol #*********************************************************************** *** # # IBM Corporation # # Title: onconfig.actrol # Description: IBM Informix Dynamic Server Configuration Parameters # #*********************************************************************** *** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /database/chunk01 # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 2097152 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration # PHYSDBS rootdbs # Location (dbspace) of physical log PHYSDBS physlogdbs # Location (dbspace) of physical log # PHYSFILE 200000 # Physical log file size (Kbytes) PHYSFILE 10000000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 2500 # Number of logical log files LOGSIZE 10000 # Logical log size (Kbytes) # Diagnostics MSGPATH /database/online.log # System message log file path CONSOLE /dev/null # System console message path # To automatically backup logical logs, edit alarmprogram.sh and set # BACKUPLOGS=Y ALARMPROGRAM /app/informix/etc/alarmprogram.sh # Alarm program path TBLSPACE_STATS 1 # Maintain tblspace statistics # System Archive Tape Device TAPEDEV /dev/nst0 # Tape device path # TAPEDEV /dev/null # Tape device path TAPEBLK 128 # Tape block size (Kbytes) TAPESIZE 21470000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/zero # Log tape device path#LTAPEDEV /dev/null # Log tape device path LTAPEBLK 128 # Log tape block size (Kbytes) LTAPESIZE 214700000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server staging area # System Configuration SERVERNUM 0 # Unique id corresponding to a OnLine instance DBSERVERNAME sage # Name of default database server # DBSERVERALIASES sage_tcp,sage_ext,sage_stream # List of alternatedbservernames DBSERVERALIASES sage_tcp,sage_ext # List of alternate dbservernames NETTYPE ipcshm,1,800,CPU # Configure poll thread(s) for nettype # NETTYPE ipcshm,1,400,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,1,600,NET # Configure poll thread(s) for nettype NETTYPE soctcp,1,600,NET # Configure poll thread(s) for nettype # NETTYPE soctcp,1,400,NET # Configure poll thread(s) for nettype # NETTYPE soctcp,1,400,NET # Configure poll thread(s) for nettype # NETTYPE ipcstr,1,400,CPU # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT -1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 4 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters #LOCKS 2000000 # Maximum number of locks LOCKS 2500000 # Maximum number of locks BUFFERS 280000 # Maximum number of shared buffers#BUFFERS 1120000 # Maximum number of shared buffers #BUFFERS 560000 # Maximum number of shared buffers NUMAIOVPS 10 # Number of IO vps PHYSBUFF 256 # Physical log buffer size (Kbytes) LOGBUFF 256 # Logical log buffer size (Kbytes) CLEANERS 3 # Number of buffer cleaner processes SHMBASE 0x44000000 # Shared memory base address#SHMBASE 0x10000000 # Shared memory base address SHMVIRTSIZE 1200000 # initial virtual shared memory segment size SHMADD 200000 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 900 # Check point interval (in sec) LRUS 200 # Number of LRU queues LRU_MAX_DIRTY 5.500000 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 3.500000 # LRU percent dirty end cleaning limit TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 32 # 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. DYNAMIC_LOGS 2 LTXHWM 70 #LTXHWM 92 LTXEHWM 80#LTXEHWM 98 # 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: # Number of parallel worker threads during fast recovery or an offline restore. # ON_RECVRY_THREADS: # Number of parallel worker threads during an online restore. OFF_RECVRY_THREADS 10 # Default number of offline worker threads ON_RECVRY_THREADS 1 # Default number of online worker threads # Data Replication Variables D

are you running 32-bit IDS or 64-bit IDS? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu ============================== SLES 10x32 SP2 & IDS 10.00.UC9 “Mostly, when you see programmers, they aren’t doing anything. One of the attractive things about programmers is that you cannot tell whether or not they are working simply by looking at them. Very often they’re sitting there seemingly drinking coffee and gossiping, or just staring into space. What the programmer is trying to do is get a handle on all the individual and unrelated ideas that are scampering around in his head.” – Charles M. Strauss ________________________________________ From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of BRETT SIMPSON [brett.simpson@actrol.com.au] Sent: Wednesday, May 12, 2010 10:24 PM To: ids@iiug.org Subject: How can I use 32Gb of ram in IDS 9.4 [20124] I have IDS9.4 on Suze 8.2 on a IBM 445 with 8 CPU and 32 Gb of ram How Can I use more of the Ram ? I have tried playing around with buffers but if I go past 280000 the instance dosn't come on like and complains : Segment locked: addr=0x44000000, size=1450098688 shmat: [ENOMEM][12]: out of available data space, check system memory parameters (e.g. MAXMEM) My onconfig is : IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 02:37:54 --2026892 Kbytes Configuration File: /app/informix/etc/onconfig.actrol #************************************************************************** # # IBM Corporation # # Title: onconfig.actrol # Description: IBM Informix Dynamic Server Configuration Parameters # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /database/chunk01 # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 2097152 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration # PHYSDBS rootdbs # Location (dbspace) of physical log PHYSDBS physlogdbs # Location (dbspace) of physical log # PHYSFILE 200000 # Physical log file size (Kbytes) PHYSFILE 10000000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 2500 # Number of logical log files LOGSIZE 10000 # Logical log size (Kbytes) # Diagnostics MSGPATH /database/online.log # System message log file path CONSOLE /dev/null # System console message path # To automatically backup logical logs, edit alarmprogram.sh and set # BACKUPLOGS=Y ALARMPROGRAM /app/informix/etc/alarmprogram.sh # Alarm program path TBLSPACE_STATS 1 # Maintain tblspace statistics # System Archive Tape Device TAPEDEV /dev/nst0 # Tape device path # TAPEDEV /dev/null # Tape device path TAPEBLK 128 # Tape block size (Kbytes) TAPESIZE 21470000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/zero # Log tape device path#LTAPEDEV /dev/null # Log tape device path LTAPEBLK 128 # Log tape block size (Kbytes) LTAPESIZE 214700000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server staging area # System Configuration SERVERNUM 0 # Unique id corresponding to a OnLine instance DBSERVERNAME sage # Name of default database server # DBSERVERALIASES sage_tcp,sage_ext,sage_stream # List of alternatedbservernames DBSERVERALIASES sage_tcp,sage_ext # List of alternate dbservernames NETTYPE ipcshm,1,800,CPU # Configure poll thread(s) for nettype # NETTYPE ipcshm,1,400,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,1,600,NET # Configure poll thread(s) for nettype NETTYPE soctcp,1,600,NET # Configure poll thread(s) for nettype # NETTYPE soctcp,1,400,NET # Configure poll thread(s) for nettype # NETTYPE soctcp,1,400,NET # Configure poll thread(s) for nettype # NETTYPE ipcstr,1,400,CPU # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT -1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 4 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters #LOCKS 2000000 # Maximum number of locks LOCKS 2500000 # Maximum number of locks BUFFERS 280000 # Maximum number of shared buffers#BUFFERS 1120000 # Maximum number of shared buffers #BUFFERS 560000 # Maximum number of shared buffers NUMAIOVPS 10 # Number of IO vps PHYSBUFF 256 # Physical log buffer size (Kbytes) LOGBUFF 256 # Logical log buffer size (Kbytes) CLEANERS 3 # Number of buffer cleaner processes SHMBASE 0x44000000 # Shared memory base address#SHMBASE 0x10000000 # Shared memory base address SHMVIRTSIZE 1200000 # initial virtual shared memory segment size SHMADD 200000 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 900 # Check point interval (in sec) LRUS 200 # Number of LRU queues LRU_MAX_DIRTY 5.500000 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 3.500000 # LRU percent dirty end cleaning limit TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 32 # 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. DYNAMIC_LOGS 2 LTXHWM 70 #LTXHWM 92 LTXEHWM 80#LTXEHWM 98 # 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: # Number of parallel worker threads during fast recovery or an offline restore. # ON_RECVRY_THREADS: # Number of parallel worker threads during an online restore. OFF_RECVRY_THREADS 10 # Default number of offline worker threads ON_RECVRY_THREADS 1 # Default number of online worker threads # Data Replication Variables DRINTERVAL 30 # DR max time between DR buffer flushes (in sec) DRTIMEOUT

He's running 32 bit - IBM Informix Dynamic Server Version 9.40.UC7. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Wyza, Jonathon Sent: Wednesday, May 12, 2010 9:46 PM To: ids@iiug.org Subject: RE: How can I use 32Gb of ram in IDS 9.4 [20126] are you running 32-bit IDS or 64-bit IDS? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu ============================== SLES 10x32 SP2 & IDS 10.00.UC9 "Mostly, when you see programmers, they aren't doing anything. One of the attractive things about programmers is that you cannot tell whether or not they are working simply by looking at them. Very often they're sitting there seemingly drinking coffee and gossiping, or just staring into space. What the programmer is trying to do is get a handle on all the individual and unrelated ideas that are scampering around in his head." - Charles M. Strauss ________________________________________ From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of BRETT SIMPSON [brett.simpson@actrol.com.au] Sent: Wednesday, May 12, 2010 10:24 PM To: ids@iiug.org Subject: How can I use 32Gb of ram in IDS 9.4 [20124] I have IDS9.4 on Suze 8.2 on a IBM 445 with 8 CPU and 32 Gb of ram How Can I use more of the Ram ? I have tried playing around with buffers but if I go past 280000 the instance dosn't come on like and complains : Segment locked: addr=0x44000000, size=1450098688 shmat: [ENOMEM][12]: out of available data space, check system memory parameters (e.g. MAXMEM) My onconfig is : IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 02:37:54 --2026892 Kbytes Configuration File: /app/informix/etc/onconfig.actrol #*********************************************************************** *** # # IBM Corporation # # Title: onconfig.actrol # Description: IBM Informix Dynamic Server Configuration Parameters # #*********************************************************************** *** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /database/chunk01 # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 2097152 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration # PHYSDBS rootdbs # Location (dbspace) of physical log PHYSDBS physlogdbs # Location (dbspace) of physical log # PHYSFILE 200000 # Physical log file size (Kbytes) PHYSFILE 10000000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 2500 # Number of logical log files LOGSIZE 10000 # Logical log size (Kbytes) # Diagnostics MSGPATH /database/online.log # System message log file path CONSOLE /dev/null # System console message path # To automatically backup logical logs, edit alarmprogram.sh and set # BACKUPLOGS=Y ALARMPROGRAM /app/informix/etc/alarmprogram.sh # Alarm program path TBLSPACE_STATS 1 # Maintain tblspace statistics # System Archive Tape Device TAPEDEV /dev/nst0 # Tape device path # TAPEDEV /dev/null # Tape device path TAPEBLK 128 # Tape block size (Kbytes) TAPESIZE 21470000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/zero # Log tape device path#LTAPEDEV /dev/null # Log tape device path LTAPEBLK 128 # Log tape block size (Kbytes) LTAPESIZE 214700000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server staging area # System Configuration SERVERNUM 0 # Unique id corresponding to a OnLine instance DBSERVERNAME sage # Name of default database server # DBSERVERALIASES sage_tcp,sage_ext,sage_stream # List of alternatedbservernames DBSERVERALIASES sage_tcp,sage_ext # List of alternate dbservernames NETTYPE ipcshm,1,800,CPU # Configure poll thread(s) for nettype # NETTYPE ipcshm,1,400,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,1,600,NET # Configure poll thread(s) for nettype NETTYPE soctcp,1,600,NET # Configure poll thread(s) for nettype # NETTYPE soctcp,1,400,NET # Configure poll thread(s) for nettype # NETTYPE soctcp,1,400,NET # Configure poll thread(s) for nettype # NETTYPE ipcstr,1,400,CPU # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT -1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 4 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters #LOCKS 2000000 # Maximum number of locks LOCKS 2500000 # Maximum number of locks BUFFERS 280000 # Maximum number of shared buffers#BUFFERS 1120000 # Maximum number of shared buffers #BUFFERS 560000 # Maximum number of shared buffers NUMAIOVPS 10 # Number of IO vps PHYSBUFF 256 # Physical log buffer size (Kbytes) LOGBUFF 256 # Logical log buffer size (Kbytes) CLEANERS 3 # Number of buffer cleaner processes SHMBASE 0x44000000 # Shared memory base address#SHMBASE 0x10000000 # Shared memory base address SHMVIRTSIZE 1200000 # initial virtual shared memory segment size SHMADD 200000 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 900 # Check point interval (in sec) LRUS 200 # Number of LRU queues LRU_MAX_DIRTY 5.500000 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 3.500000 # LRU percent dirty end cleaning limit TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 32 # 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 ne

SuSE 8.2 is by default maxed to 4 GB (if I remember that number right, long time since I ran this release) so Kernel has to be tuned, better: go to a more current SuSE version, because 8.2 is out of patches since several years now. As already said, you need a 64Bit Informix release regards Joerg Volz ------------------------------------------------------------------------ ----- -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Knox, Ernest Sent: Thursday, May 13, 2010 4:48 AM To: ids@iiug.org Subject: RE: How can I use 32Gb of ram in IDS 9.4 [20127] He's running 32 bit - IBM Informix Dynamic Server Version 9.40.UC7. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Wyza, Jonathon Sent: Wednesday, May 12, 2010 9:46 PM To: ids@iiug.org Subject: RE: How can I use 32Gb of ram in IDS 9.4 [20126] are you running 32-bit IDS or 64-bit IDS? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu ============================== SLES 10x32 SP2 & IDS 10.00.UC9 "Mostly, when you see programmers, they aren't doing anything. One of the attractive things about programmers is that you cannot tell whether or not they are working simply by looking at them. Very often they're sitting there seemingly drinking coffee and gossiping, or just staring into space. What the programmer is trying to do is get a handle on all the individual and unrelated ideas that are scampering around in his head." - Charles M. Strauss ________________________________________ From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of BRETT SIMPSON [brett.simpson@actrol.com.au] Sent: Wednesday, May 12, 2010 10:24 PM To: ids@iiug.org Subject: How can I use 32Gb of ram in IDS 9.4 [20124] I have IDS9.4 on Suze 8.2 on a IBM 445 with 8 CPU and 32 Gb of ram How Can I use more of the Ram ? I have tried playing around with buffers but if I go past 280000 the instance dosn't come on like and complains : Segment locked: addr=0x44000000, size=1450098688 shmat: [ENOMEM][12]: out of available data space, check system memory parameters (e.g. MAXMEM) My onconfig is : IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 02:37:54 --2026892 Kbytes Configuration File: /app/informix/etc/onconfig.actrol #*********************************************************************** *** # # IBM Corporation # # Title: onconfig.actrol # Description: IBM Informix Dynamic Server Configuration Parameters # #*********************************************************************** *** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /database/chunk01 # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 2097152 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration # PHYSDBS rootdbs # Location (dbspace) of physical log PHYSDBS physlogdbs # Location (dbspace) of physical log # PHYSFILE 200000 # Physical log file size (Kbytes) PHYSFILE 10000000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 2500 # Number of logical log files LOGSIZE 10000 # Logical log size (Kbytes) # Diagnostics MSGPATH /database/online.log # System message log file path CONSOLE /dev/null # System console message path # To automatically backup logical logs, edit alarmprogram.sh and set # BACKUPLOGS=Y ALARMPROGRAM /app/informix/etc/alarmprogram.sh # Alarm program path TBLSPACE_STATS 1 # Maintain tblspace statistics # System Archive Tape Device TAPEDEV /dev/nst0 # Tape device path # TAPEDEV /dev/null # Tape device path TAPEBLK 128 # Tape block size (Kbytes) TAPESIZE 21470000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/zero # Log tape device path#LTAPEDEV /dev/null # Log tape device path LTAPEBLK 128 # Log tape block size (Kbytes) LTAPESIZE 214700000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server staging area # System Configuration SERVERNUM 0 # Unique id corresponding to a OnLine instance DBSERVERNAME sage # Name of default database server # DBSERVERALIASES sage_tcp,sage_ext,sage_stream # List of alternatedbservernames DBSERVERALIASES sage_tcp,sage_ext # List of alternate dbservernames NETTYPE ipcshm,1,800,CPU # Configure poll thread(s) for nettype # NETTYPE ipcshm,1,400,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,1,600,NET # Configure poll thread(s) for nettype NETTYPE soctcp,1,600,NET # Configure poll thread(s) for nettype # NETTYPE soctcp,1,400,NET # Configure poll thread(s) for nettype # NETTYPE soctcp,1,400,NET # Configure poll thread(s) for nettype # NETTYPE ipcstr,1,400,CPU # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT -1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 4 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters #LOCKS 2000000 # Maximum number of locks LOCKS 2500000 # Maximum number of locks BUFFERS 280000 # Maximum number of shared buffers#BUFFERS 1120000 # Maximum number of shared buffers #BUFFERS 560000 # Maximum number of shared buffers NUMAIOVPS 10 # Number of IO vps PHYSBUFF 256 # Physical log buffer size (Kbytes) LOGBUFF 256 # Logical log buffer size (Kbytes) CLEANERS 3 # Number of buffer cleaner processes SHMBASE 0x44000000 # Shared memory base address#SHMBASE 0x10000000 # Shared memory base address SHMVIRTSIZE 1200000 # initial virtual shared memory segment size SHMADD 200000 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared

You can't use much more without switching to a 64bit version of Informix. Since 9.40 us out of support as of last September, and has been out-of-sales for over a year prior to that, you'll have to upgrade. The current 64bit release is 11.50.FC6W3 Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, May 12, 2010 at 10:24 PM, BRETT SIMPSON <brett.simpson@actrol.com.au > wrote: > I have IDS9.4 on Suze 8.2 on a IBM 445 with 8 CPU and 32 Gb of ram > > How Can I use more of the Ram ? > > I have tried playing around with buffers but if I go past 280000 the > instance > dosn't come on like and complains : > > Segment locked: addr=0x44000000, size=1450098688 > shmat: [ENOMEM][12]: out of available data space, check system memory > parameters (e.g. MAXMEM) > > My onconfig is : > > IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 02:37:54 --> 2026892 Kbytes > > Configuration File: /app/informix/etc/onconfig.actrol > #************************************************************************** > # > # IBM Corporation > # > # Title: onconfig.actrol > # Description: IBM Informix Dynamic Server Configuration Parameters > # > #************************************************************************** > > # Root Dbspace Configuration > > ROOTNAME rootdbs # Root dbspace name > ROOTPATH /database/chunk01 # Path for device containing root dbspace > ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) > ROOTSIZE 2097152 # Size of root dbspace (Kbytes)> > # Disk Mirroring Configuration Parameters > > MIRROR 0 # Mirroring flag (Yes = 1, No = 0) > MIRRORPATH # Path for device containing mirrored root > MIRROROFFSET 0 # Offset into mirrored device (Kbytes)> > # Physical Log Configuration > > # PHYSDBS rootdbs # Location (dbspace) of physical log > PHYSDBS physlogdbs # Location (dbspace) of physical log > # PHYSFILE 200000 # Physical log file size (Kbytes) > PHYSFILE 10000000 # Physical log file size (Kbytes)> > # Logical Log Configuration > > LOGFILES 2500 # Number of logical log files > LOGSIZE 10000 # Logical log size (Kbytes)> > # Diagnostics > > MSGPATH /database/online.log # System message log file path > CONSOLE /dev/null # System console message path> > # To automatically backup logical logs, edit alarmprogram.sh and set > # BACKUPLOGS=Y > ALARMPROGRAM /app/informix/etc/alarmprogram.sh # Alarm program path > TBLSPACE_STATS 1 # Maintain tblspace statistics> > # System Archive Tape Device > > TAPEDEV /dev/nst0 # Tape device path > # TAPEDEV /dev/null # Tape device path > TAPEBLK 128 # Tape block size (Kbytes) > TAPESIZE 21470000 # Maximum amount of data to put on tape (Kbytes)> > # Log Archive Tape Device > > LTAPEDEV /dev/zero # Log tape device path> #LTAPEDEV /dev/null # Log tape device path > LTAPEBLK 128 # Log tape block size (Kbytes) > LTAPESIZE 214700000 # Max amount of data to put on log tape (Kbytes)> > # Optical > > STAGEBLOB # Informix Dynamic Server staging area > > # System Configuration > > SERVERNUM 0 # Unique id corresponding to a OnLine instance > DBSERVERNAME sage # Name of default database server > # DBSERVERALIASES sage_tcp,sage_ext,sage_stream # List of alternate> dbservernames > DBSERVERALIASES sage_tcp,sage_ext # List of alternate dbservernames > NETTYPE ipcshm,1,800,CPU # Configure poll thread(s) for nettype > # NETTYPE ipcshm,1,400,CPU # Configure poll thread(s) for nettype > NETTYPE soctcp,1,600,NET # Configure poll thread(s) for nettype > NETTYPE soctcp,1,600,NET # Configure poll thread(s) for nettype > # NETTYPE soctcp,1,400,NET # Configure poll thread(s) for nettype > # NETTYPE soctcp,1,400,NET # Configure poll thread(s) for nettype > # NETTYPE ipcstr,1,400,CPU # Configure poll thread(s) for nettype > DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. > RESIDENT -1 # Forced residency flag (Yes = 1, No = 0) > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor > NUMCPUVPS 4 # Number of user (cpu) vps > SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one > > NOAGE 1 # Process aging > AFF_SPROC 0 # Affinity start processor > AFF_NPROCS 0 # Affinity number of processors> > # Shared Memory Parameters > > #LOCKS 2000000 # Maximum number of locks > LOCKS 2500000 # Maximum number of locks > BUFFERS 280000 # Maximum number of shared buffers> #BUFFERS 1120000 # Maximum number of shared buffers > #BUFFERS 560000 # Maximum number of shared buffers > NUMAIOVPS 10 # Number of IO vps > PHYSBUFF 256 # Physical log buffer size (Kbytes) > LOGBUFF 256 # Logical log buffer size (Kbytes) > CLEANERS 3 # Number of buffer cleaner processes > SHMBASE 0x44000000 # Shared memory base address> #SHMBASE 0x10000000 # Shared memory base address > SHMVIRTSIZE 1200000 # initial virtual shared memory segment size > SHMADD 200000 # Size of new shared memory segments (Kbytes) > SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited > CKPTINTVL 900 # Check point interval (in sec) > LRUS 200 # Number of LRU queues > LRU_MAX_DIRTY 5.500000 # LRU percent dirty begin cleaning limit > LRU_MIN_DIRTY 3.500000 # LRU percent dirty end cleaning limit > TXTIMEOUT 0x12c # Transaction timeout (in sec) > STACKSIZE 32 # 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. > > DYNAMIC_LOGS 2 > LTXHWM 70 > #LTXHWM 92 > LTXEHWM 80> #LTXEHWM 98 > > # 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: > # Number of parallel worker threads during fast recovery or an offline > restore. > # ON_RECVRY_THREADS: > # Number of parallel worker threads during an online restore