Re: Performance - Informix 5.04

Umesh, I had a similar problem with this on NCR. Informix said that the numbers had wrapped around and were showing negative. It causes no problems but makes performance monitoring difficult. Jason On Wed, 28 Jan 1998 12:40:55 -0800, Umesh Patel <umesh%sun.rols.com@ebay.sun.com> wrote: > >--------------7F7B41BFE28FD92E4E7F08CC >Content-Type: text/plain; charset=us-ascii >Content-Transfer-Encoding: 7bit > >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. > >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 > > >Thanks-- >=============================================================== >Umesh Patel Email: mailto:umesh.patel@usa.net >=============================================================== >On Assignment with Caliber Logistics- >--------------------------------------------------------------- > > > >--------------7F7B41BFE28FD92E4E7F08CC >Content-Type: text/html; charset=us-ascii >Content-Transfer-Encoding: 7bit > ><HTML> >I have two instance running on&nbsp; Ultra 2 ( SUN) Solaris 2.5.1. Informix >5.04 UC1. ><BR>This particular instance we are using for qa testing. Output of tbstat >-p on other ><BR>instance is appropriate. ><BR>Can someone tell me what wrong???? with all these negative numbers. ><BR>If someone need more info. I can provide it. > ><P>Output of tbstat -p > ><P>RSAM Version 5.04.UC1&nbsp;&nbsp; -- On-Line -- Up 35 days 13:15:28 >-- 234208 Kbytes > ><P>Profile ><BR>dskreads pagreads bufreads&nbsp;&nbsp;&nbsp; %cached&nbsp;&nbsp;&nbsp;&nbsp; >dskwrits&nbsp;&nbsp;&nbsp; pagwrits&nbsp;&nbsp;&nbsp; bufwrits&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; >%cached ><BR>977080&nbsp;&nbsp;&nbsp; 7291727&nbsp; <B><U>-358183996</U>&nbsp;&nbsp; ><U>0.00</U></B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2619455&nbsp;&nbsp;&nbsp;&nbsp; >2925513&nbsp;&nbsp;&nbsp; 15704027&nbsp;&nbsp;&nbsp; 83.32 > ><P>isamtot&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; open&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; >start&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; read&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; >write&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rewrite&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; >delete&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; commit&nbsp;&nbsp;&nbsp;&nbsp; >rollbk ><BR><B><U>-697021562</U></B> 19237869 637699959 <B><U>-986027999</U></B> >675918&nbsp;&nbsp; 1404398&nbsp;&nbsp;&nbsp;&nbsp; 2755&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; >24032477&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33 > ><P>ovtbls&nbsp;&nbsp; ovlock&nbsp;&nbsp; ovuser&nbsp;&nbsp; ovbuff&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; >usercpu&nbsp;&nbsp;&nbsp; syscpu&nbsp;&nbsp;&nbsp;&nbsp; numckpts&nbsp;&nbsp; >flushes ><BR>0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; >0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; >0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; >250112.97 12406.82&nbsp;&nbsp; 9007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; >19241 > ><P>bufwaits lokwaits lockreqs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; >deadlks&nbsp; dltouts&nbsp; lchwaits ckpwaits compress ><BR>5283&nbsp;&nbsp;&nbsp;&nbsp; 184416&nbsp;&nbsp; -167290053&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; >0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; >0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8096023&nbsp; 536&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; >1690934 ><BR>&nbsp; ><PRE>Thanks--&nbsp; >=============================================================== >Umesh Patel&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Email: <A HREF="mailto:umesh.patel@usa.net">mailto:umesh.patel@usa.net</A> >=============================================================== >On Assignment with Caliber Logistics- >---------------------------------------------------------------</PRE> >&nbsp;</HTML> > >--------------7F7B41BFE28FD92E4E7F08CC-- >