Options That Affect Timing

Checkpoint Interval

SAP Sybase IQ uses checkpoints to generate reference points and other information necessary for recovering databases.

Use the -gc switch to set the maximum number of minutes the database server runs without performing a checkpoint.

When a database server is running with multiple databases, the checkpoint time specified by the first database started is used unless overridden by the -gc switch. If a value of 0 is entered, the default value of 20 minutes is used.

Recovery Time

The -gr parameter lets you set the maximum number of minutes that the database server takes to recover from system failure.

When a database server runs with multiple databases, the recovery time specified by the first database started is used unless -gr overrides that value.