Re: Buffers not flushed???

Version 9 has a new feature called "FUZZY CHECKPOINT". This is now the default. Prior to version 9 all buffers were completely flushed on each checkpoint (full sync checkpoint). The goal of Fuzzy checkpoints is to reduce I/O and improve performance. Check your $INFORMIXDIR/release directory for details about fuzzy wuzzy checkpoints. There is no onconfig param for this, but there is an environment variable to turn it off if you don't like it. >>10:54:45 On-Line Mode >>11:00:13 Fuzzy Checkpoint Completed: duration was 0 seconds, 229 buffers>not f >>lushed. >>11:00:13 Checkpoint loguniq 3, logpos 0x63b764> >What does this mean "buffers not flushed"??? >Is someone able to help me!??!? > >Thanks a lot and have a nice day! > >Serafin >

To disable fuzzy checkpoint, add this undocumented onconfig parameter NOFUZZYCKPT 1 then restart Informix In article <t0bu9s57h152d8@corp.supernews.com>, "Joanne Dority" <joanned@seanet.com> wrote: > Version 9 has a new feature called "FUZZY CHECKPOINT". This is now the > default. Prior to version 9 all buffers were completely flushed on each > checkpoint (full sync checkpoint). The goal of Fuzzy checkpoints is to > reduce I/O and improve performance. > > Check your $INFORMIXDIR/release directory for details about fuzzy wuzzy > checkpoints. There is no onconfig param for this, but there is an > environment variable to turn it off if you don't like it. > > >>10:54:45 On-Line Mode > >>11:00:13 Fuzzy Checkpoint Completed: duration was 0 seconds, 229buffers > >not f > >>lushed. > >>11:00:13 Checkpoint loguniq 3, logpos 0x63b764> > > >What does this mean "buffers not flushed"??? > >Is someone able to help me!??!? > > > >Thanks a lot and have a nice day! > > > >Serafin > > > > Sent via Deja.com http://www.deja.com/ Before you buy.