Beyond Basics
Onstat -p - Most of the fields are contained in sysprofile SMI table along with statistical fields from onstat -l and onstat -F and information about sorts occurring system wide.
Informix Dynamic Server Version 7.30.U -- On-Line -- Up 00:06:08 --23696 Kbytes
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
94 113 660 85.76 11 11 5 0.00
isamtot open start read write rewrite delete commit rollbk
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
ixda-RA idx-RA da-RA RA-pgsused lchwaits