ASA Database Administration Guide

Database Options

Alphabetical list of options

CHECKPOINT_TIME option [database]

Function 

Set the maximum number of minutes that the database server will run without doing a checkpoint.

Allowed values 

Integer

Scope 

Can be set only for the PUBLIC group. DBA authority is required to set the option. You must shut down and restart the database server for the change to take effect.

Default 

60

Description 

This option is used with the RECOVERY_TIME option to decide when checkpoints should be done.

For information on checkpoints, see Checkpoints and the checkpoint log.

See also 

RECOVERY_TIME option [database]

SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.