Re: Checkpoints up to 137 seconds

Hi, From: Bridget Reitsma <b.reitsma@auckland.ac.nz> > >I'm using informix 730UC5 on a Sequent box, I thought I had everything >set just right, that was till Wednesday this week, when my checkpoints >started rocketing. Normally my checkpoints average at about 4 seconds, >now they are averaging at about 60 seconds. > >My LRU MAX is set to 2 my LRU_MIN is set to 0. The have 17 LRU queues >and 8 CLEANERS. The checkpoint interval was recently changed to 600 >seconds - I have have changed this back to 300 seconds. (I have >attached a copy of my onconfig file.) > >There hasn't been a major increase in users the load is only slightly >higher than normal. It is the end of the month after all. But does >anyone have any ideas of what other step I could take to decrease the >checkpoint interval? I didn't get your whole onconfig file. Have you recently increased the number of BUFFERS? How many CPUs have you got? Try bringing the number of CLEANERS up to 17 as well... HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com