Increasing RAM Problems

Thanks to : bayati@tmcso.com, Art S. Kagel, com@netinfo-moldova.com I have problems when I increased RAM from 64MB to 128MB; Here are more details: Operating System: SCO Open Server 5.04d + 25 Users License + SMP Support; DBMS: Informix-Online Dynamic Server 7.23 UC1; Hardware: Dual Intel Pentium 133 MHz; informix.log looks like: 08:45:36 Event alarms enabled. ALARMPROG = '/oms/InformixOn/etc/log_full.sh' 08:45:39 DR: DRAUTO is 0 (Off) 08:45:40 INFORMIX-OnLine Initialized -- Shared Memory Initialized. 08:45:40 Physical Recovery Started. 08:45:40 Physical Recovery Complete: 0 Pages Restored. 08:45:40 Logical Recovery Started. 08:45:43 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 08:45:43 Dataskip is now OFF for all dbspaces 08:45:43 On-Line Mode 08:45:43 Checkpoint Completed: duration was 0 seconds. 08:46:10 Assert Failed: Internal Error - Segmentation Violation 08:46:10 Who: Session(17, sumenk@ats301, 1586, -2109331148) Thread(38, sqlexec, 824421f4, 3) 08:46:10 Results: OnLine must abort 08:46:10 Action: Reinitialize shared memory 08:46:10 See Also: /tmp/af.2274b0, shmem.267412.0 08:46:17 rsinit.c, line 9949, thread 38, proc id 1515, Segmentation Violation. 08:46:17 PANIC: Attempting to bring system down Here is file /tmp/af.2274b0: 08:46:48 08:46:48 Assert Failed: Internal Error - Segmentation Violation 08:46:48 Who: Session(7, sumenk@ats301, 2006, -2109332608) Thread(34, sqlexec, 82440cc8, 3) 08:46:48 Results: OnLine must abort 08:46:48 Action: Reinitialize shared memory 08:46:48 See Also: /tmp/af.2274b0, shmem.2274b0.0 08:46:48 Stack for thread: 34 sqlexec base: 0x8263c014 len: 36864 pc: 0x00274801 tos: 0x826445e8 0x8264464c ***unknown*** (0x8257d028, 0x825ec938, 0x43e4b8, 0x82440cc8) 0x0027422e mt_affail (0x8259e6e4, 0x8247ec10, 0x82571fe0, 0x82440cc8) 0x0019f295 rsam_affail (0x8259e6e4, 0x8247ec10, 0x82571fe0, 0x82440cc8) 0x000104f7 hang_thread (0x402644, 0x8259e6e4, 0xb, 0x82644eec) 0x000103bf afsig_segv (0xb, 0x0, 0x0, 0x1f) 0x003a81ac sigismember (0x825ecd24, 0x825ec938, 0x825ed304, 0x825ec350) 0x000f2af2 sel2cb (0x825ecd24, 0x825ec350, 0x0, 0x0) 0x000f25ff qblk2cb (0x825ecd5c, 0x825ec350, 0x825ec350, 0x82644f84) 0x000edaf2 stmt2cb (0x825ecd7c, 0x825ec350, 0x0, 0x484af8) 0x000ed962 p_sp2cb (0x825ecd7c, 0x825ec350, 0x0, 0x1) 0x000c1b95 parsecmd (0x1, 0x400884, 0x4819a0, 0x1) 0x000c1804 sqcmd (0x1, 0x0, 0xc, 0x1) 0x000c16bc sq_cmnd (0x0, 0x484d0c, 0xa, 0x8259e0b4) 0x000d11a3 sqmain (0x0, 0x0, 0x0, 0x0) 0x0025eeb8 startup (0x25, 0x82645060, 0x8263c000, 0x4c) 0x00000000 ***unknown*** 08:46:48 ------------------ End of assertion failure 0 ----------------- Here is onconfig file: #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig.301 # Description: INFORMIX-OnLine Configuration Parameters # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace nameROOTPATH /dev/online_root # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 240000 # 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 PHYSFILE 3000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 6 # Number of logical log files LOGSIZE 5000 # Logical log size (Kbytes) # Diagnostics MSGPATH /oms/InformixOn/online.log # System message log file path CONSOLE /dev/console # System console message path ALARMPROGRAM /oms/InformixOn/etc/log_full.sh # Alarm program path # System Archive Tape Device TAPEDEV /dev/rStp0 # Tape device path TAPEBLK 16 # Tape block size (Kbytes) TAPESIZE 1200000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/rStp0 # Log tape device path LTAPEBLK 16 # Log tape block size (Kbytes) LTAPESIZE 1200000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB ,1 # INFORMIX-OnLine/Optical staging area # System Configuration SERVERNUM 0 # Unique id corresponding to a OnLineinstance DBSERVERNAME online_301 # Name of default database server DBSERVERALIASES shmem_301 # List of alternate dbservernames 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 formulti-processor NUMCPUVPS 2 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps toone NOAGE 0 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters LOCKS 2000 # Maximum number of locks BUFFERS 200 # Maximum number of shared buffers NUMAIOVPS 4 # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 9 # Maximum number of logical log files CLEANERS 1 # Number of buffer cleaner processes SHMBASE 0x82000000 # Shared memory base address SHMVIRTSIZE 8000 # initial virtual shared memory segment size SHMADD 8192 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 300 # Check point interval (in sec) LRUS 8 # Number of LRU queues LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit LTXHWM 50 # Long transaction high water markpercentage LTXEHWM 60 # Long transaction high water mark (exclusive) TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 32 # Stack size (Kbytes) # System Page Size # BUFFSIZE - OnLine no longer supports this configuration parameter. #