Explain Checkpoints And Why In 9.4 They Were Better Than In Previous

1.	Explain Checkpoints And Why In 9.4 They Were Better Than In Previous Versions Of The Engine?
Answer» You are still using 9.4 ? It’s out of support for 3 years … . We upgraded from 10.00FC6 to 11.50FC7 last year. The first Informix database I started to administrate was IDS 10.00FC4. So my BEST guess is that 9.4 introduced partially non blocking checkpoints (FUZZY checkpoints ?), these being superseded in the latter versions. The checkpoint is the MOMENT when Informix will flush the CONTENTS from the bufferpool to disks.

Explain Checkpoints And Why In 9.4 They Were Better Than In Previous Versions Of The Engine?

Answer»

You are still using 9.4 ? It’s out of support for 3 years … . We upgraded from 10.00FC6 to 11.50FC7 last year.
The first Informix database I started to administrate was IDS 10.00FC4. So my BEST guess is that 9.4 introduced partially non blocking checkpoints (FUZZY checkpoints ?), these being superseded in the latter versions.
The checkpoint is the MOMENT when Informix will flush the CONTENTS from the bufferpool to disks.