Hi,

In one of our customer places, we are facing issue of the
database checkpoint is happening once in an hour(Windows).
There is no specific interval set for checkpoint. It's doing
at one hour (default).

Because of this, on database crash, it took long time for
the database to recover and fully functional. Can somebody
explain why the checkpoint is happening once in an hour, as
in R&D setup it's happening more frequently with a smaller
database.

If we want to change the setting of checkpoint to short
duration what would be the period or what criteria needs to
be considered to set appropriate value.

Thanks and Regards,
Krishna

Krishna,

Please see the section in the documentation entitled "How the database
server decides when to checkpoint":
http://www.ianywhere.com/developer/p...9/00000449.htm

Regards,

knazare (AT) bmc (DOT) com wrote:
--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

Hi Jeff,

Thanks for the response.
In the customer place, the db did not undergo checkpoint for
three hours before it was brought down. And the db had to be
aborted as it did not stop with clean shutdown. This
resulted in long recovery time. The RECOVERY_TIME is also by
default set to 2. In what way we can ensure that the
recovery time is faster and reduce the down time for the
customer. Will setting recovery time will help as it is
currently not set.(that means it will use default)?

Thanks and Regards,
Krishna

Krishna,

You can always manually issue a CHECKPOINT (
http://www.ianywhere.com/developer/p...9/00000348.htm
), provided that the checkpoint log isn't locked for some reason. (For
instance, we will prevent checkpoints from happening if a backup is
currently active).

The default settings should also always force the checkpoints to happen
otherwise - check the database settings mentioned in the article I
highlighted in the documentation.

knazare (AT) bmc (DOT) com wrote:
Can you be more specific - what does:

SELECT DATABASE_PROPERTY('RECOVERY_TIME');

and

SELECT DATABASE_PROPERTY('CHECKPOINT_TIME');

return?

Cheers,

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/