PPT Slide
Cache %ages, seq scans, etc.
Informix Dynamic Server Version -- On-Line -- Up 21 days 01:44:25 -- 7.31.UC6X4 598864 Kbytes
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
1523701737 342785587 6678280 0.43 185927856 135703629 701843122 73.51
isamtot open start read write rewrite delete commit rollbk
2037307281 11267271 1087600826 2652039125 154371784 196942196 20119095 21512971 47
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
253351331 19 3497542899 0 0 29520 3034173 717546
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 1176094 5222078.89 7058313.98 2998 6020
Diagnosing problems: Dig, Dig, Dig