RE: Performance - Informix 5.04
---------- From: Umesh Patel[SMTP:umesh@sun.rols.com] Sent: Wednesday, January 28, 1998 12:41 PM To: Leffler, Jonathan; Matthews, Paul Subject: Performance - Informix 5.04 I have two instance running on Ultra 2 ( SUN) Solaris 2.5.1. Informix 5.04 UC1. This particular instance we are using for qa testing. Output of tbstat -p on other instance is appropriate. Can someone tell me what wrong???? with all these negative numbers. If someone need more info. I can provide it. JL: You didn't run 'tbstat -z' before the 32-bit counters overflowed. JL: I tend to run 'tbstat -z' once a day or once a week, depending on the JL: activity level - I also save the output from tbstat -p before zeroing JL: the statistics, and ensure that the saved files are compressed and removed periodically Yours, Jonathan Leffler (jleffler@visa.com) #include <bother.ms-exchange.h> Output of tbstat -p RSAM Version 5.04.UC1 -- On-Line -- Up 35 days 13:15:28 -- 234208 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 977080 7291727 -358183996 0.00 2619455 2925513 15704027 83.32 isamtot open start read write rewrite delete commit rollbk -697021562 19237869 637699959 -986027999 675918 1404398 2755 24032477 33 ovtbls ovlock ovuser ovbuff usercpu syscpu numckpts flushes 0 0 0 0 250112.97 12406.82 9007 19241 bufwaits lokwaits lockreqs deadlks dltouts lchwaits ckpwaits compress 5283 184416 -167290053 0 0 8096023 536 1690934