Re: Extended checkpoint times

anonymous wrote: > <snip> > We are trying to investigate a series of overly long checkpoints on one > of our informix databases, here is > a snippet of the online.log file detailing the events: > > <snip> > 21:55:42 Checkpoint Completed: duration was 3 seconds. > 22:03:22 Checkpoint Completed: duration was 155 seconds.> > In general we have checkpoint times around the 6-7 second region, but > recently we've seen several occurances > were informix goes catatonic on us whilst doing a 400 second checkpoint! > <snip> Mark, I have seen even bigger problem "Blocked Checkpoint", we haven't got any satisfactory solution for this yet. This blocked checkpoint waits for ever !!!. This "Blocked Checkpoint" is not like any of the cases that we saw in customer support registry. BTW, if you are afraid of spammers, add a "mailto" in your message text, because some of us don't like to goof out on technical issues, with anonymous guys, what is the guarantee that you are not my boss, with an anonymous mask. -- Have a nice day Felix K. Mathews mailto:fmathews@systems.dhl.com