Start of Content Area

Object documentation CKPTINTVL (Informix)  Locate the document in its SAP Library structure

Definition

The CKPTINTVL parameter in the Informix ONCONFIG file specifies the frequency, expressed in seconds, at which the database server checks to determine whether a checkpoint is needed. When a checkpoint occurs, pages in the shared-memory buffer pool are written to disk.

Use

For up-to-date recommendations, see SAP Note 41360.

Do not set this value too high because this causes very long fast recoveries after power loss or other disruptions. The SAP default value is 900 seconds.

 

See also:

Checkpointing (Informix)

Monitoring Checkpoints (Informix)