Best Tune for Online 5.02

Hello, I have an Informix Online 5.02.UC6 installation running on a RISC6000 with 128MB Ram, with about 30 users. The production database is about 400MB. I'm having performance problems. Could someone suggest me some tunning tips. The config is as follows: # Root Dbspace Configuration ROOTNAME rlv02 # Root dbspace name ROOTPATH /dev/rlv02 # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 122880 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing root dbspace mirror MIRROROFFSET 0 # Offset into mirror device (Kbytes) # Physical Log Configuration PHYSDBS rlv02 # Name of dbspace that contains physical log PHYSFILE 10240 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 8 # Number of logical log files LOGSIZE 5120 # Size of each logical log file (Kbytes) # Message Files MSGPATH /usr/informix/online.log # OnLine message log pathname CONSOLE /dev/console # System console message pathname # Archive Tape Device TAPEDEV /dev/rmt0 # Archive tape device pathname TAPEBLK 512 # Archive tape block size (Kbytes) TAPESIZE 1227776 # Max amount of data to put on tape (Kbytes) # Logical Log Backup Tape Device LTAPEDEV /dev/null # Logical log tape device pathname LTAPEBLK 16 # Logical log tape block size (Kbytes) LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes) # Identification Parameters SERVERNUM 0 # Unique id associated with this OnLine instance DBSERVERNAME dpx20 # Unique name of this OnLine instance # Shared Memory Parameters RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)USERS 70 # Maximum number of concurrent user processes TRANSACTIONS 70 # Maximum number of concurrent transactions LOCKS 50000 # Maximum number of locks BUFFERS 6144 # Maximum number of shared memory buffersTBLSPACES 700 # Maximum number of active tblspaces CHUNKS 8 # Maximum number of chunks DBSPACES 8 # Maximum number of dbspaces and blobspaces PHYSBUFF 1536 # Size of physical log buffers (Kbytes) LOGBUFF 1024 # Size of logical log buffers (Kbytes)LOGSMAX 12 # Maximum number of logical log files CLEANERS 3 # Number of page-cleaner processes SHMBASE 0x30000000 # Shared memory base address CKPTINTVL 300 # Checkpoint interval (in seconds) LRUS 8 # Number of LRU queues LRU_MAX_DIRTY 60 # LRU modified begin-cleaning limit (percent) LRU_MIN_DIRTY 50 # LRU modified end-cleaning limit (percent) LTXHWM 80 # Long TX high-water mark (percent) LTXEHWM 90 # Long TX exclusive high-water mark (percent) # Machine- and Product-Specific Parameters DYNSHMSZ 0 # Dynamic shared memory size (Kbytes) GTRID_CMP_SZ 32 # Number of bytes to use in GTRID comparision DEADLOCK_TIMEOUT 60 # Max time to wait for lock in distributed env. TXTIMEOUT 300 # Transaction timeout for I-STAR (in seconds)SPINCNT 0 # No. of times process tries for latch STAGEBLOB # Reserved for INFORMIX-OnLine/Optical # System Page Size BUFFSIZE 4096 # Page size (do not change!) -------- TIA Serafim Fonseca ========================================================================== Serafim Fonseca e-mail: sf@growela.pt Growela Portuguesa Calcado, Lda. phone : +351 2 9820510 S. Pedro Avioso, Castelo fax : +351 2 9812212 4470 Maia - PORTUGAL