Re: checkpoint interval

Sahrul The drop in performance could be a problem with not having done UPDATE STATISTICS in a while. For the high checkpoint duration, look at the output of onstat -F to see what kind of writes you are getting. If you are getting all your writes as Chunk Writes, increase the CKPTINTVL so approximately 50% of the writes get done by LRU writes. If you are getting F/G writes, try increasing the number of LRUs. For LRUs the Informix recommendation is MAX(4, NUMCPUVPS). HTH Sujit Pal ______________________________ Reply Separator _________________________________ Subject: checkpoint interval Author: Sahrul Hidayat <Sahrul_Hidayat@fmi.com> at Internet Date: 4/24/98 10:22 AM Dear All, I'm running INF 7.23UC1 with total database is 76 GB. We are happy with our configuration, but since Last Monday, our online perfomance going down and also interval of checkpoin sometime took so long, about 50-170 second. We have checked no big transaction, no long transaction that caused checkpoint interval like this. all transaction is on normal condition. Could somebody give some suggestion, what are the parameter relation with checkpoint interval, what is exacly the problem, if we face problem like this ? here is our online param : LRUS = 8 CLEANER=12 LRU_MAX_DIRTY=3 LRU_MIN_DIRTY=1 reply and suggestion are greatly appreciated...... rgds sahrul