Re: Minimizing bufwaits

In article <c1.01.2NDPcT$05K@news.asl.ca>, Brian Hampson <brian@ASL.CA> writes >It appears, from an onstat -p, that about my only bottlenecks is >"bufwaits" > >Is there a way that I can reduce the waits? What parameter needs to be >twiddled? > >Onstat -p output (note some numbers have rolled over..showing incorrect >cache numbers) > > >INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 41 days 22:38:10 -- 57984 >Kbytes > >Profile >dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached >25560000 63513837 36185941 29.36 8964466 35165552 122598911 92.69 > >isamtot open start read write rewrite delete commit rollbk >2414132832 27171184 136937552 1757719100 35850121 1755389 473948 1849956 9 > >ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes >0 0 0 441158.86 89765.19 1879 8040 > >bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans >3005610 936 3233912260 2 0 2109 7633098 3122129 3122129 sequential scans?? Are you sure that OPTCOMPIND=0 and indexes are being used where required. To reduce bufwaits increase the number of buffers... > >ixda-RA idx-RA da-RA RA-pgsused lchwaits >6626719 47054 2294107 8903552 524623 > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care