dbTalk Databases Forums  

RE: Long fuzzy checkpoint

comp.databases.informix comp.databases.informix


Discuss RE: Long fuzzy checkpoint in the comp.databases.informix forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Sebastian, Norma J.
 
Posts: n/a

Default RE: Long fuzzy checkpoint - 12-26-2007 , 05:05 PM






Omar,
I don't know the exact details/science, but you could rid yourself of fuzzycheckpoints by just turning them off. Your regular checkpoints will still happen, just not the fuzzy's. In the environment of the user that starts informix, set NOFUZZYCKPT to 1, then stop/start Informix. We were IDS 9.4 (64bit) on Solaris 9. We were running SAP, not that it matters, but were advised by SAP to turn off the fuzzy's.
Norma Jean




================================================== ==========
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
================================================== ==========

Reply With Quote
  #2  
Old   
Gustavo Castro
 
Posts: n/a

Default Re: Long fuzzy checkpoint - 12-26-2007 , 05:54 PM






I think is unlikely that the problem is related to the fact this is a
"fuzzy" checkpoint. If you don't see that the prolem is I/O, maybe th
eproblem is that a thread is in critical section (look in onstat -u for
a thread with the "X" flag). Then try to analyze what is this thread doing.


Gustavo


Omar Muņoz wrote:
Quote:
Hi.

I've seen on my site that sometimes a fuzzy
checkpoint takes more than a minute to end. We have
configured LRU limits in order to activate cleaners (2
and 1% for 384 LRUs. There are 950000 buffers of 2 Kb
each) and 5 minutes of checkpoint interval. Problem
persists, and it doesn't seem to be a writing item. In
fact, there was a 75 sec checkpoint for only about
4000 dirty buffers (on onstat -R), when sometimes
there are more than 9000 and checkpoint doesn't take
more than 10 secs on those cases. I suppose physical
log doesn't have nothing to do also, because the
problem is fuzzy checkpoint. I ask you for your advice
about which other factors may be provoking that
situation, so I can make up configuration.

Everything is about a Solaris 9 Server (8
processors) and IDS 9.40 FC7

Thanks in advace

Omar Muņoz



__________________________________________________ __________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsea...egory=shopping
_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list






Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.