Re: How to reduce bufwaits in IDS?

How long had the instance been up when you ran this? sleesingchan@my-deja.com wrote: > Here is the output from onstat -g spi | sort -rn +1 | head -20: > > 407 2050012 5036.88 tcb lock, tid = 13 > 277 1475000 5324.91 vproc vp_lock, id = 1 > 2 10000 5000.00 mutex lock, name = AIOreq > 2 10000 5000.00 mutex lock, name = AIOreq > 2 10000 5000.00 mutex lock, name = AIOreq > 2 10000 5000.00 mutex lock, name = AIOreq > 2 10000 5000.00 mutex lock, name = AIOreq > 2 10000 5000.00 mutex lock, name = AIOreq > 1 5000 5000.00 tcb lock, tid = 5 > 1 5000 5000.00 mutex lock, name = vpc aio > 1 5000 5000.00 mutex lock, name = AIOreq > 1 5000 5000.00 mutex lock, name = AIOreq > 1 5000 5000.00 mutex lock, name = AIOreq > 1 5000 5000.00 mutex lock, name = AIOreq > 1 5000 5000.00 mutex lock, name = AIOreq > 1 5000 5000.00 mutex lock, name = AIOreq > 1 5000 5000.00 mutex lock, name = AIOreq > 1 5000 5000.00 mutex lock, name = AIOreq > 1 5000 5000.00 mutex lock, name = AIOreq > 1 5000 5000.00 mutex lock, name = AIOreq > > Samuel. > > In article <39A6855C.5A573483@sabre.com>, > William Rice <William.Rice@sabre.com> wrote: > > Of course it might be helpful if I could type too. > > Anyway, onstat -c would let us look at how you had the system > configured. > > onstat -g spi | sort -rn +1 | head -20> > might be interesting as well. > > > > William Rice wrote: > > > > > It might be helpful if we has the output from onstat -c as well > > > > > > Will > > > > > > sleesingchan@my-deja.com wrote: > > > > > > > Sorry the message got scrambled. > > > > This is much better: > > > > > > > > Hello, > > > > > > > > I'm seeing a problem with my IDS instance (7.31 for Digital Unix > 4.0) > > > > which contains 4 PeopleSoft Financials databases (about 400-600 MB > > > > each) > > > > > > > > There are a large number of bufwaits when I run the onstat > command. See > > > > results below. > > > > > > > > Can anyone suggest ways to reduce this high figure? > > > > > > > > Informix Dynamic Server Version 7.31.FC4A -- On-Line -- Up 30 > days > > > > 05:42:32 -- 458752 Kbytes > > > > > > > > Profile > > > > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits % > cached > > > > 27247923 17395712 2555873294 98.93 915986 2423007 4185287 > 78.11 > > > > > > > > isamtot open start read write rewrite delete > > > > 2329311336 50483831 118027700 1601044582 962372 359135 177949 > > > > commit rollbk > > > > 220032 132 > > > > > > > > gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs > > > > 0 0 0 0 0 0 0 > > > > > > > > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > > > > 0 0 0 215885.50 44764.13 8722 17444 > > > > > > > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress > seqscans > > > > 7892336 82 2565639368 0 0 367 54473 > 2646791 > > > > > > > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > > > > 852324 5813854 13380955 19961138 91 > > > > > > > > Thanks for any help. > > > > Regards, > > > > Samuel Lee > > > > Trinidad. > > > > > > > > Sent via Deja.com http://www.deja.com/ > > > > Before you buy. > > > > > > Sent via Deja.com http://www.deja.com/ > Before you buy.