You've heard it all before, cont.

I'm posting some other onstat commands that may help. Informix Dynamic Server Version 7.31.FC4 -- On-Line -- Up 3 days 09:44:13 -- 2545024 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 261671478 74154240 9591835411 97.27 55502789 51443264 212025414 73.82 isamtot open start read write rewrite delete commit rollbk 8587085144 43126935 172567752 4682012886 56281592 10069964 3147447 22054673 42895 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 1187 151984.04 65843.13 967 1934 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 16758474 48898 5081207577 0 0 18077 2029819 642171 ixda-RA idx-RA da-RA RA-pgsused lchwaits 92314484 3084372 1919689 97237545 3309121 MT global info: sessions threads vps lngspins 114 324 12 434 sched calls thread switches yield 0 yield n yield forever total: 1913107135 1490724804 426169445 16877225 694531053 per sec: 0 0 0 0 0 Virtual processor summary: class vps usercpu syscpu total cpu 7 151956.74 65772.65 217729.39 aio 1 2.74 12.17 14.91 lio 1 2.12 7.70 9.82 pio 1 2.09 7.85 9.94 adm 1 14.27 34.33 48.60 msc 1 6.08 8.43 14.51 total 12 151984.04 65843.13 217827.17 Individual virtual processors: vp pid class usercpu syscpu total 1 28505 cpu 27636.92 18176.92 45813.84 2 28506 adm 14.27 34.33 48.60 3 28507 cpu 25982.39 16773.92 42756.31 4 28508 cpu 30565.32 17020.38 47585.70 5 28509 cpu 16064.93 3393.09 19458.02 6 28510 cpu 20905.27 4161.71 25066.98 7 28511 cpu 17043.99 3418.54 20462.53 8 28512 cpu 13757.92 2828.09 16586.01 9 28513 lio 2.12 7.70 9.82 10 28514 pio 2.09 7.85 9.94 11 28515 aio 2.74 12.17 14.91 12 28516 msc 6.08 8.43 14.51 tot 151984.04 65843.13 217827.17