Online 7.12 Tunning [more info]

Hello, Following the tips from this group (which I thank), I have already had improvements on the performance. But I think it can be improved even more. So I'm sending some more input which was asked. Thanks in advance for your help and the help already given. Serafim Fonseca Machine: Risc6000 with 128MB RAM, 2 hard disk of 2GB each, 1 CPU. output from UNIX commands: ========================== #sar -r 1 3 AIX dpx20 2 3 002015805700 09/19/97 13:32:49 slots cycle/s fault/s odio/s 13:32:51 29304 0,00 15,20 0,00 13:32:52 29304 0,00 0,81 0,00 13:32:53 29304 0,00 0,00 0,00 Average 29304 0 5 0 # ps -aux UID PID TTY TIME CMD 209 14972 9 0:00 ucalc 223 18117 0:00 <defunct> 233 19476 pts/3 0:01 SOFGO 224 21432 15 0:00 fglgo 276 22299 pts/11 0:01 SOFGO 215 25147 11 0:05 SOFGO 208 26524 pts/13 0:00 SOFGO 211 35031 pts/18 0:00 SOFGO 214 35553 17 0:00 SOFGO 231 37136 pts/4 0:00 SOFGO 253 39202 pts/6 0:07 SOFGO 224 40099 pts/21 0:41 SOFGO 224 41149 15 0:19 fglgo 210 41468 8 0:01 ucalc 238 41513 pts/5 0:00 SOFGO 223 43093 6 0:01 SOFGO 221 50486 pts/12 0:00 fglgo 232 51631 10 0:00 SOFGO 248 57721 0:00 <defunct> 259 59303 14 0:19 SOFGO 258 60487 16 0:03 SOFGO 0 62242 pts/14 0:00 newmail 268 63127 pts/9 3:41 SOFGO 221 63799 pts/12 0:00 fglgo # vmstat 2 10 procs memory page faults cpu ----- ----------- ------------------------ ------------ ----------- r b avm fre re pi po fr sr cy in sy cs us sy id wa 0 0 33186 316 0 0 0 2 9 0 241 535 276 16 4 64 16 0 0 33186 315 0 0 0 0 0 0 257 469 364 10 5 68 17 0 0 33186 313 0 0 0 0 0 0 215 1055 404 14 8 64 14 0 0 33186 311 0 1 0 0 0 0 957 202 196 1 9 77 13 0 0 33186 311 0 0 0 0 0 0 1085 424 261 5 7 76 12 1 0 33188 294 1 6 0 0 0 0 1071 908 330 11 18 18 53 0 0 33100 395 0 0 0 0 0 0 797 762 477 11 8 30 50 0 0 33138 347 0 0 0 0 0 0 243 866 362 7 11 61 20 0 1 33372 133 0 0 6 24 143 0 253 19314 375 14 37 40 8 0 0 33311 211 0 0 0 0 0 0 247 1125 260 6 11 70 13 # lsvg -o|lsvg -i -l (logical volumes) rootvg: LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT hd6 paging 45 45 1 open/syncd N/A hd61 paging 15 15 2 open/syncd N/A hd5 boot 2 2 1 closed/syncd /blv hd7 sysdump 2 2 1 open/syncd N/A hd8 jfslog 1 1 1 open/syncd N/A hd4 jfs 2 2 1 open/syncd / hd2 jfs 93 93 1 open/syncd /usr lv02 jfs 30 30 1 open/syncd N/A rlv05 jfs 350 350 1 open/syncd N/A lv01 jfs 108 108 2 open/syncd /softel hd3 jfs 5 5 1 open/syncd /tmp dbstemp jfs 25 25 1 open/syncd N/A lv06 jfs 80 80 1 open/syncd N/A hd9var jfs 4 4 1 open/syncd /var hd1 jfs 110 110 1 open/syncd /home lv03 jfs 10 10 1 open/syncd N/A lv00 jfs 45 45 1 open/syncd /tmp2 lv08 jfs 15 15 1 open/syncd /online7 lv04 jfs 10 10 1 open/syncd N/A Output from Informix commands: $ onstat -p INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 1 days 17:10:29 -- 57904 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 5192521 7647572 85909766 93.96 158606 823588 2714645 94.16 isamtot open start read write rewrite delete commit rollbk 100791012 2186959 4623724 83013139 601834 185741 66406 23184 36 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 16730.50 2727.50 262 988 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 350803 1 60071594 0 0 208 109437 144712 ixda-RA idx-RA da-RA RA-pgsused lchwaits 423353 3758 4201547 4626920 222 $ onstat -F INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 1 days 17:11:07 -- 57904 Kbytes Fg Writes LRU Writes Chunk Writes 0 1495 56829 address flusher state data 40022444 0 I 0 = 0X0 40022878 1 I 0 = 0X0 40022cac 2 I 0 = 0X0 states: Exit Idle Chunk Lru $ onstat -u INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 1 days 17:11:38 -- 57904 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites 40022010 ---P--D 0 informix - 0 0 0 541 2147 40022444 ---P--F 0 informix - 0 0 0 0 0 40022878 ---P--F 0 informix - 0 0 0 0 0 40022cac ---P--F 0 informix - 0 0 0 0 0 400230e0 ---P--B 8 informix - 0 0 0 38 691 40023514 ---P--D 0 informix - 0 0 0 0 0 40023948 Y--P--- 4351 ar tty11 412ce18c 0 1 26 13 40023d7c Y--P--- 3643 luis tty12 40dc3f44 0 1 38 0 400241b0 Y--P--- 4510 profit 22 404112a8 0 0 0 0 400245e4 Y--P--- 2861 jm 6 40709354 0 1 45 0 40024a18 Y--P--- 3991 mj 21 409cef28 0 1 74 112 40025280 Y--P--- 2797 fernanda tty10 40752010 0 1 205 7 400256b4 Y--P--- 2785 lc - 4086b9d0 0 1 63 0 40025ae8 Y--P--- 4441 paulag 5 4068243c 0 1 7 4 40025f1c Y--P--- 3026 paulamrt tty4 4070e1d0 0 1 86 3 40026350 Y--P--- 4490 fernanda tty10 40752fe8 0 1 27 2 40026bb8 Y--P--- 4481 ad 13 4099cb6c 0 1 1 0 40026fec Y--P--- 2863 jm 6 406fe8b8 0 1 475 95 40027420 Y--P--- 2795 mj tty15 406c9978 0 1 219 101 40027854 Y--P--- 4500 analise 10 409959c4 0 1 2 0 40027c88 Y--P--- 4432 he tty17 4076d634 0 1 11 1 400284f0 Y--P--- 4438 antoniet 4 409cf8fc 0 1 41 0 40028924 Y--P--- 4489 ad 13 40831570 0 1 12 0 40028d58 Y--P--- 3051 pq 9 408b89cc 0 1 53 0 4002918c Y--P--- 4307 ar tty11 40f652a8 0 1 28 1 400295c0 Y--P--- 3056 pq 9 40ed390c 0 1 3369 2707 400299f4 Y--P--- 4384 fi 18 406fe5b8 0 1