Oninit cdi / Archive
Talk to an expert →

Performance - Informix 5.04

Posted in 1998

Umesh Patel — — source: Informix-list mailing list archive (1991-1998)

--------------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--