Re: Fuzzy checkpoints, then Regular Checkpoints??

Posted in 2008

natebsi@gmail.com — Thu, 30 Oct 2008 12:24:58 -0700 (PDT) — source: Usenet: comp.databases.informix

On Oct 27, 3:21 pm, "Mark Scranton (Xtivia Inc.)" <mark.scran...@gmail.com> wrote: > On Oct 25, 2:09 pm, nate...@gmail.com wrote: > > > > >Informix10.FC7: > > > 09:27:19 Maximum server connections 0 > > 09:32:22 FuzzyCheckpointCompleted: durationwas 0 seconds, 29> > buffers not fl > > ushed. > > 09:32:22 Checkpointloguniq 51, logpos 0x5b52f8, timestamp:> > 0x2c783a49 > > > 09:32:22 Maximum server connections 0 > > 09:37:25 FuzzyCheckpointCompleted: durationwas 0 seconds, 25> > buffers not fl > > ushed. > > 09:37:25 Checkpointloguniq 51, logpos 0x5b6298, timestamp:> > 0x2c804afa > > > 09:37:25 Maximum server connections 0 > > 09:42:28 CheckpointCompleted: durationwas 0 seconds. > > 09:42:28 Checkpointloguniq 51, logpos 0x5b7018, timestamp:> > 0x2c87d57f > > > 09:42:28 Maximum server connections 0 > > 09:47:31 CheckpointCompleted: durationwas 0 seconds. > > 09:47:31 Checkpointloguniq 51, logpos 0x5b8018, timestamp:> > 0x2c8ee6f2 > > > There is nothing snipped between those checkpoints, and I'm seeing > > that in many other places. NOFUZZYCKPT is not set for theInformix > > user. > > > Is this correct for 10.00? Or is something weird going on? > > > Nate > > This is very normal for IDS 9.2 through IDS 10. IDS 11 deprecated > fuzzies because of the rewrite of thecheckpointarchitecture. IF > NOFUZZYCKPT was turned on, then you'd only see "full checkpoints", > although the word "full" won't be found ('cept for when I rewrite the > msg log in my Sanity Check). > > There are many operations that require a fullcheckpoint(archiving, > adding a chunk, etc..., if the next llog to be used is only being > blocked due to a fuzzy, and a few others), not to mention, internally > we don't let "x" number of checkpoints go by with a full occurring. > Last I recall, x=3 or 2, but someone else (ifmx kernel guys) might > chime in here. Do you have questions about fuzzies vs. full? You can > contact me directly if so, and I'll give you the long-winded > version(s) if you like. > > Mark Scranton > Xtivia Inc.www.markscranton.com > mark.scran...@xtivia.com Nope, thats perfect, thanks Mark! And thanks to Art and a couple others that emailed me directly to tell me its 'by-design', and RTFM! :) Nate