We have clients still on Informix 11.70 on Windows.  All of them were installed with the default settings regarding checkpoints. In fact the only changes to onconfig were to set the TAPEDEV to NUL.

These 2 checkpoint values remain as shown.  Installed by the install program as this:

CKPTINTVL 300
AUTO_CKPTS 1

For most clients this works.  I see regular checkpoints at 5 minute intervals if something else doesn't trip the checkpoint first.

Several months ago, I wrote about a client where we just lost all of the data for a day when the machine went down. As I suspected, and confirmed by others on this group, it was not doing checkpoints.  Our hardware guy said the machine had a faulty memory stick, so I chalked it up to that.  But we had a reboot mid-day again when the machine was accidentally powered down again.  Again we lost data.  I looked at onstat -g ckp and saw that it wasn't doing regular checkpoints.

Also, the onstat -g ckp sometimes reports AUTO_CKPTS=Off, even though it is set to 1 (enabled) and I'm seeing it's been doing regular checkpoints every 5 minutes.

Why might this not be working? Onconfig is set as shown above.  In the meantime, I set up a task scheduler job to force a checkpoint with onmode -c at regular intervals to force a manual checkpoint. But I shouldn't have to do that.  We do not use transaction logging. Anything to look at or check to see why this isn't working?

Wondering if something got corrupted (possibly from the bad memory stick) and I should just uninstall/reinstall the entire database and reload it.  Maybe something in the sysmaster or other system databases/tables. Just wondering if a complete reinstall is the fix.

Hi Joel,

this problem was fixed in 12.10 (xC14) and 14.10 (xC4) more than five years ago: even with AUTO_CKPTS on, we'd now do a safety checkpoint every CKPTINTVL.

With versions missing this fix AND running non-logging databases, it is not recommended to have AUTO_CKPTS on.  (In fact, without logging, so without much to recover with a server restart, there's no point in having it on as your fast recovery will be tiny anyway.)

HTH,
 Andreas

We have clients still on Informix 11.70 on Windows.  All of them were installed with the default settings regarding checkpoints. In fact the only changes to onconfig were to set the TAPEDEV to NUL.

These 2 checkpoint values remain as shown.  Installed by the install program as this:

CKPTINTVL 300
AUTO_CKPTS 1

For most clients this works.  I see regular checkpoints at 5 minute intervals if something else doesn't trip the checkpoint first.

Several months ago, I wrote about a client where we just lost all of the data for a day when the machine went down. As I suspected, and confirmed by others on this group, it was not doing checkpoints.  Our hardware guy said the machine had a faulty memory stick, so I chalked it up to that.  But we had a reboot mid-day again when the machine was accidentally powered down again.  Again we lost data.  I looked at onstat -g ckp and saw that it wasn't doing regular checkpoints.

Also, the onstat -g ckp sometimes reports AUTO_CKPTS=Off, even though it is set to 1 (enabled) and I'm seeing it's been doing regular checkpoints every 5 minutes.

Why might this not be working? Onconfig is set as shown above.  In the meantime, I set up a task scheduler job to force a checkpoint with onmode -c at regular intervals to force a manual checkpoint. But I shouldn't have to do that.  We do not use transaction logging. Anything to look at or check to see why this isn't working?

Wondering if something got corrupted (possibly from the bad memory stick) and I should just uninstall/reinstall the entire database and reload it.  Maybe something in the sysmaster or other system databases/tables. Just wondering if a complete reinstall is the fix.

Hi Joel,

this problem was fixed in 12.10 (xC14) and 14.10 (xC4) more than five years ago: even with AUTO_CKPTS on, we'd now do a safety checkpoint every CKPTINTVL.

With versions missing this fix AND running non-logging databases, it is not recommended to have AUTO_CKPTS on.  (In fact, without logging, so without much to recover with a server restart, there's no point in having it on as your fast recovery will be tiny anyway.)

HTH,
 Andreas

We have clients still on Informix 11.70 on Windows.  All of them were installed with the default settings regarding checkpoints. In fact the only changes to onconfig were to set the TAPEDEV to NUL.

These 2 checkpoint values remain as shown.  Installed by the install program as this:

CKPTINTVL 300
AUTO_CKPTS 1

For most clients this works.  I see regular checkpoints at 5 minute intervals if something else doesn't trip the checkpoint first.

Several months ago, I wrote about a client where we just lost all of the data for a day when the machine went down. As I suspected, and confirmed by others on this group, it was not doing checkpoints.  Our hardware guy said the machine had a faulty memory stick, so I chalked it up to that.  But we had a reboot mid-day again when the machine was accidentally powered down again.  Again we lost data.  I looked at onstat -g ckp and saw that it wasn't doing regular checkpoints.

Also, the onstat -g ckp sometimes reports AUTO_CKPTS=Off, even though it is set to 1 (enabled) and I'm seeing it's been doing regular checkpoints every 5 minutes.

Why might this not be working? Onconfig is set as shown above.  In the meantime, I set up a task scheduler job to force a checkpoint with onmode -c at regular intervals to force a manual checkpoint. But I shouldn't have to do that.  We do not use transaction logging. Anything to look at or check to see why this isn't working?

Wondering if something got corrupted (possibly from the bad memory stick) and I should just uninstall/reinstall the entire database and reload it.  Maybe something in the sysmaster or other system databases/tables. Just wondering if a complete reinstall is the fix.

Hi Joel,

this problem was fixed in 12.10 (xC14) and 14.10 (xC4) more than five years ago: even with AUTO_CKPTS on, we'd now do a safety checkpoint every CKPTINTVL.

With versions missing this fix AND running non-logging databases, it is not recommended to have AUTO_CKPTS on.  (In fact, without logging, so without much to recover with a server restart, there's no point in having it on as your fast recovery will be tiny anyway.)

HTH,
 Andreas

We have clients still on Informix 11.70 on Windows.  All of them were installed with the default settings regarding checkpoints. In fact the only changes to onconfig were to set the TAPEDEV to NUL.

These 2 checkpoint values remain as shown.  Installed by the install program as this:

CKPTINTVL 300
AUTO_CKPTS 1

For most clients this works.  I see regular checkpoints at 5 minute intervals if something else doesn't trip the checkpoint first.

Several months ago, I wrote about a client where we just lost all of the data for a day when the machine went down. As I suspected, and confirmed by others on this group, it was not doing checkpoints.  Our hardware guy said the machine had a faulty memory stick, so I chalked it up to that.  But we had a reboot mid-day again when the machine was accidentally powered down again.  Again we lost data.  I looked at onstat -g ckp and saw that it wasn't doing regular checkpoints.

Also, the onstat -g ckp sometimes reports AUTO_CKPTS=Off, even though it is set to 1 (enabled) and I'm seeing it's been doing regular checkpoints every 5 minutes.

Why might this not be working? Onconfig is set as shown above.  In the meantime, I set up a task scheduler job to force a checkpoint with onmode -c at regular intervals to force a manual checkpoint. But I shouldn't have to do that.  We do not use transaction logging. Anything to look at or check to see why this isn't working?

Wondering if something got corrupted (possibly from the bad memory stick) and I should just uninstall/reinstall the entire database and reload it.  Maybe something in the sysmaster or other system databases/tables. Just wondering if a complete reinstall is the fix.

Thank you.  We're working on the 14.10 upgrade, but we're have FourJs issues that prevented upgrading.  We're progressing though.  But now we're stuck on 11.70.  I'd have to look at what 12.10 can be installed on.  And, whether it works with that version of FourJs.

I did copy all of the onconfig files for our clients so I could do comparisons and grep certain paramaters.  As well as do an onstat -g ckp on each client and see which ones were doing checkpoints and which weren't.  

Turns out, ALL of the clients with RTO_SERVER_RESTART set to a value other than 0 were the ones not doing regular checkpoints.  Apparently this overrides the checkpoint interval to do it's own thing. Only it wasn't doing it's own thing regularly enough.  We're talking several hours of usage.

I don't know why this was set at one place vs another.  The only thing we ever do to the onconfig file after installation is change TAPEDEV to NUL.  Recovery Time Objective sounds like something related to applying log files during recovery. That's something I'm unfamiliar with. The code I've inherited does not use transaction logging. The databases are created without LOG.  It's possible in some of the installs, "Transaction logging supported by applications(s)" on the Database Server Usage screen was checked "Yes".  Maybe that caused the installation to set the RTO_SERVER_RESTART to 60 at these sites?

Apparently 0 means disabled and a value (60 or probably even 1 or 2) means enabled.

I was able to stop the service, set this value to 0, then restart the service and checkpoints started happening.

I did notice that there was sometimes more than 5 minutes. This was like 2am and the database wasn't active. I'm assuming if nothing is "dirty" and has nothing to do, that the every 5 minute checkpoint won't register on the onstat -b ckp? That it's not going to show up if it did nothing, only when it needs to flush cache to disk.

Last night, after changing the RTO_SERVER_RESTART to 0, it was showing checkpoints, not at every 5 minutes.  It was 10 minutes or more.  But now, during the day, with users on the system, it's every 5 minutes, just like the configuration says.

Hi Joel,

this problem was fixed in 12.10 (xC14) and 14.10 (xC4) more than five years ago: even with AUTO_CKPTS on, we'd now do a safety checkpoint every CKPTINTVL.

With versions missing this fix AND running non-logging databases, it is not recommended to have AUTO_CKPTS on.  (In fact, without logging, so without much to recover with a server restart, there's no point in having it on as your fast recovery will be tiny anyway.)

HTH,
 Andreas

We have clients still on Informix 11.70 on Windows.  All of them were installed with the default settings regarding checkpoints. In fact the only changes to onconfig were to set the TAPEDEV to NUL.

These 2 checkpoint values remain as shown.  Installed by the install program as this:

CKPTINTVL 300
AUTO_CKPTS 1

For most clients this works.  I see regular checkpoints at 5 minute intervals if something else doesn't trip the checkpoint first.

Several months ago, I wrote about a client where we just lost all of the data for a day when the machine went down. As I suspected, and confirmed by others on this group, it was not doing checkpoints.  Our hardware guy said the machine had a faulty memory stick, so I chalked it up to that.  But we had a reboot mid-day again when the machine was accidentally powered down again.  Again we lost data.  I looked at onstat -g ckp and saw that it wasn't doing regular checkpoints.

Also, the onstat -g ckp sometimes reports AUTO_CKPTS=Off, even though it is set to 1 (enabled) and I'm seeing it's been doing regular checkpoints every 5 minutes.

Why might this not be working? Onconfig is set as shown above.  In the meantime, I set up a task scheduler job to force a checkpoint with onmode -c at regular intervals to force a manual checkpoint. But I shouldn't have to do that.  We do not use transaction logging. Anything to look at or check to see why this isn't working?

Wondering if something got corrupted (possibly from the bad memory stick) and I should just uninstall/reinstall the entire database and reload it.  Maybe something in the sysmaster or other system databases/tables. Just wondering if a complete reinstall is the fix.

We have clients still on Informix 11.70 on Windows.  All of them were installed with the default settings regarding checkpoints. In fact the only changes to onconfig were to set the TAPEDEV to NUL.

These 2 checkpoint values remain as shown.  Installed by the install program as this:

CKPTINTVL 300
AUTO_CKPTS 1

For most clients this works.  I see regular checkpoints at 5 minute intervals if something else doesn't trip the checkpoint first.

Several months ago, I wrote about a client where we just lost all of the data for a day when the machine went down. As I suspected, and confirmed by others on this group, it was not doing checkpoints.  Our hardware guy said the machine had a faulty memory stick, so I chalked it up to that.  But we had a reboot mid-day again when the machine was accidentally powered down again.  Again we lost data.  I looked at onstat -g ckp and saw that it wasn't doing regular checkpoints.

Also, the onstat -g ckp sometimes reports AUTO_CKPTS=Off, even though it is set to 1 (enabled) and I'm seeing it's been doing regular checkpoints every 5 minutes.

Why might this not be working? Onconfig is set as shown above.  In the meantime, I set up a task scheduler job to force a checkpoint with onmode -c at regular intervals to force a manual checkpoint. But I shouldn't have to do that.  We do not use transaction logging. Anything to look at or check to see why this isn't working?

Wondering if something got corrupted (possibly from the bad memory stick) and I should just uninstall/reinstall the entire database and reload it.  Maybe something in the sysmaster or other system databases/tables. Just wondering if a complete reinstall is the fix.