performance turning help

Hi all, Can anybody help me look at my onconfig file to see something odd need to make a change. My Informix seen to run slow and not taking full CPU resource. I would ppreciate any help I can get on this problem. Thanks In Advance. --Wayne Trieu PS: sorry for the long message. Here is my system configurations: Sun E450, 3CPU, 2Gb mem, 4Gb swap, Solaris 2.6 DB: informix 7.30.uc5-1 database about 16Gid right now Main Application run on this server is BaaN 4c3. Here are some onstat: #onstat -p Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 3 days 08:28:03 -- s Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 10806627 9003967 1302914669 99.17 3255758 4756277 28266535 88.48 isamtot open start read write rewrite delete commit rollbk 329900073 12797250 35718452 160148810 5376094 4449604 535866 1056836 105 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 0 0 0 0 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 72853.42 40452.76 1156 2706 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 725923 13 1445265638 0 0 1143 152783 1408639 ixda-RA idx-RA da-RA RA-pgsused lchwaits 764262 528 1209585 1957320 5126041 ************************************************ onstat -F Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 3 days 08:29:36 -- s Fg Writes LRU Writes Chunk Writes 0 408884 1360967 address flusher state data 590404cc 0 I 0 = 0X0 59040980 1 I 0 = 0X0 59040e34 2 I 0 = 0X0 590412e8 3 I 0 = 0X0 states: Exit Idle Chunk Lru ************************************************************** onstat -g sch Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 3 days 08:30:34 -- s VP Scheduler Statistics: vp pid class semops busy waits spins/wait 1 459 cpu 353 399 9476 2 503 adm 0 0 0 3 504 cpu 27613927 29254640 9715 4 505 lio 2 0 0 5 506 pio 2 0 0 6 509 aio 36 0 0 7 511 msc 218116 0 0 8 512 tli 2009 2244 934 ****************************************************** onstat -g glo Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 3 days 08:31:43 -- s MT global info: sessions threads vps lngspins 75 95 8 56 sched calls thread switches yield 0 yield n yield forever total: 855495948 280012086 688650212 1702378 35649250 per sec: 398 392 1 6 115 Virtual processor summary: class vps usercpu syscpu total cpu 2 70183.35 8208.12 78391.47 aio 1 0.00 0.06 0.06 tli 1 2783.69 32232.65 35016.34 lio 1 0.01 0.06 0.07 pio 1 0.00 0.04 0.04 adm 1 0.22 1.12 1.34 msc 1 17.62 17.75 35.37 total 8 72984.89 40459.80 113444.69 Individual virtual processors: vp pid class usercpu syscpu total 1 459 cpu 24367.72 4126.29 28494.01 2 503 adm 0.22 1.12 1.34 3 504 cpu 45815.63 4081.83 49897.46 4 505 lio 0.01 0.06 0.07 5 506 pio 0.00 0.04 0.04 6 509 aio 0.00 0.06 0.06 7 511 msc 17.62 17.75 35.37 8 512 tli 2783.69 32232.65 35016.34 tot 72984.89 40459.80 113444.69 *************************************************** This is my ONCONFIG.file *************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace nameROOTPATH /dev/rawlinks/rootdbs1 # Path for device containing root dbspace ROOTOFFSET 10 # Offset of root dbspace into device (Kbytes) ROOTSIZE 100000 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirroredroot MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS plogdbs # Location (dbspace) of physical log PHYSFILE 420000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 65 # Number of logical log files LOGSIZE 5000 # Logical log size (Kbytes) # Diagnostics MSGPATH /usr2/informix/online.log # System message log file path CONSOLE /dev/console # System console message pathALARMPROGRAM /usr2/informix/scripts/alarm.sh # Alarm program path #ALARMPROGRAM /usr2/informix/etc/log_full.sh # Alarm program path SYSALARMPROGRAM /usr2/informix/etc/evidence.sh # System Alarm program path TBLSPACE_STATS 1 # System Archive Tape Device #TAPEDEV /dev/null # Tape device path TAPEDEV /dev/nrst36 # Tape device path TAPEBLK 16 # Tape block size (Kbytes)#TAPESIZE 10240 # Maximum amount of data to put on tape (Kbytes) TAPESIZE 65000000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /usr3/ifmx_llogs_bkup/llogfile # Log tape device path #LTAPEDEV /dev/null # Log tape device path LTAPEBLK 16 # Log tape block size (Kbytes) LTAPESIZE 2000000 # Max amount of data to put on log tape (Kbytes)#LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server/Optical staging area # System Configuration SERVERNUM 1 # Unique id corresponding to a DynamicServer instance DBSERVERNAME on_titan # Name of default database server DBSERVERALIASES # List of alternate dbservernames NETTYPE tlitcp,1,100,NET # Configure poll thread(s) for nettype NETTYPE ipcstr,1,100,CPU # Configure poll thread(s) for nettype NETTYPE sqlmux,1,100,CPU # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock indistributed env. RESIDENT 1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 fo