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.



Discussion

No Comment Found