HELP I'm in crisis
Posted in 1996
Hello,
System: HP HP9000 E35, 132MB RAM, Online 7.12.UC3
These are my NEW Shared Memory Parameters:
LOCKS 2000 # Maximum number of locks
BUFFERS 30000(old=5000) # Maximum number of shared buffers
NUMAIOVPS # Number of IO vps
PHYSBUFF 32 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 6 # Maximum number of logical log files
CLEANERS 6 # Number of buffer cleaner processes
SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 60000(old=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 12 # Number of LRU queues
LRU_MAX_DIRTY 70 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 60 # 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)
I've migrated from Informix-SE 5.04 to Informix-OnLine 7.12.UC3
With SE, the system was slow, but I never had problems. Now
After 20-30 users are using the system(with the same client/server
application) OnLine adds new shared memory segment (size 8388608)
continuosly!!!
After some hours, the system "sits" down and I need to take OnLine
OFF Line. I'm taking the OnLine 7.12 "on-line"with the NEW above values.
I've change BUFFERS from 5000 to 30000 and SHMVISTSIZE from 8000
to 60000. It seems that the application that was running OK on
SE, now does not release memory until it doesn't disconnetcs
from the Database engine....Why???? Are my new parameters ok?
I've got 30 users complaining !!!!! HELP!!!!
Please help. I'm doing this installation away from my office.
fernando.collalti@orbit.net