Options That Affect Timing

Several command line options control when certain database server events occur.

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.