Sets the maximum interval between checkpoints.

Syntax

{ dbsrv11 | dbeng11 } -gc minutes ...

Applies to

All operating systems and database servers.

Remarks

Set the maximum length of time in minutes that the database server runs without doing a checkpoint on each database.

The default value is the setting of the checkpoint_time database option, which defaults to 60 minutes. If a value of 0 is entered, the default value of 60 minutes is used.

Checkpoints generally occur more frequently than the specified time.

See How the database server decides when to checkpoint.

See also

• checkpoint_time option [database]
• Understanding the checkpoint log
• How the database server decides when to checkpoint