Re: onconfig advise please

Thanks, I'll look into the changes you suggested. the checkpoints are occuring every 5 min. Ray In article <q1Rt5.4747$XR1.65486@news4.atl>, "Doug Agnew" <dagnew@charlottepipe.com> wrote: > A couple of things: > > You should have as many cleaners as you have LRUs. Cleaners are used at > checkpoint time to write pages. More cleaners should reduce checkpoint > time. > > Change LRU_MAX_DIRTY/LRU_MIN_DIRTY to 2/1 or something similar... This will > result in pages being rewritten between checkpoints and fewer being written > during checkpoints. At the present time, you could be re-writing as many as > 20000 pages in a checkpoint. > > Can you afford to allocate more buffers? Your ovbuf (in onstat -p) is WAY > too high, indicating an unacceptable amount of foreground writes (use > onstat -F|head to see this). You are forcing transactions to waitwhile > buffers are being written to make space for buffers to be read. > > Is OPTCOMPIND 2 what you really want? Have you compared performance with > OPTCOMPIND 0? I don't have a SUN, so I don't know the preferences there. 0 > works better than 2 on some boxes. > > Are your checkpoints occurring every 5 minutes or more frequently? > onstat -m would help determine that.> > HTH, > Doug > > <r_pastore@my-deja.com> wrote in message news:8p8jcf$2u9 $1@nnrp1.deja.com... > > Hi all, > > > > I've been folloowing the forum for a little while and now it's my turn > > to ask for configuration advise. > > We're having checkpoints averaging in the low teens during peak times > > with spikes to as high as 40 or 50 seconds. I've included a copy of the > > onconfig file as well as the onstat -p and -d. Is anything else needed? > > > > The system is SUN E10000 and we're planning to upgrade to Informix > > 9.x soon. > > > > Ray > > > > <<< SNIP >>> Sent via Deja.com http://www.deja.com/ Before you buy.