Re: Help I'm in crisis

"Collalti, Fernando" wrote: System: HP HP9000 E35, 132MB RAM, Online 7.12.UC3 These are my NEW Shared Memory Parameters: 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 Hi - we have an ICL box with about .6 Gb RAM on it your cleaning limits seem very high, we have LRU_MAX_DIRTY set to 6 and LRU_MIN_DIRTY to 3. If your checkpoints are long - this is the cause because most of your disk writes of dirty pages are occuring during a checkpoint. If the values are set low the cleaners are writing to disk most of the time thus giving a more consistent performance. Tony Reynolds, NEC Group, Birmingham , UK 8-))