Setting options that affect timing

Checkpoint interval

Sybase IQ uses checkpoints to generate reference points and other information that it needs to recover databases. Use the -gc switch to set the maximum number of minutes the database server will run without doing 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 this 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 will take to recover from system failure. When a database server is running with multiple databases, the recovery time specified by the first database started will be used unless overridden by this switch.