Micro Focus Enterprise Developer 3.0 for Eclipse > Programming > Mainframe Programming > SQL Option for DB2 > SQL Option Server Administration Guide > Backup and Recovery > Server Configuration > Checkpoint Frequency

Checkpoint Frequency

Restriction: This topic applies to Windows environments only.

The checkpoint frequency parameter determines the amount of time between automatic logging system checkpoints. These automatic checkpoints cause the contents of log buffer cache to be written to table files on disk, removing the need for applications to issue checkpoints manually. See the SQL Reference for a description of the CHECKPOINT command.

The checkpoint frequency parameter is one of the factors affecting the length of time needed to return location data objects to a logically consistent state after a transient system failure, such as a power outage, or operating system failure. If you increase the checkpoint interval, the system requires more time for log recovery after a transient system failure. Conversely, a shorter checkpoint interval reduces average recovery time, but increases system overhead.

To set the parameter (UNIX):

Add the following to the [XdbLogManager] topic of the xdbsrvco.ini server configuration file:
```
lCheckpointFreq=n
```

To set the parameter (Windows):

Click the Logging tab within the XDB Server Configuration Utility.
Enter the desired checkpoint frequency in seconds in the Checkpoint Frequency text box, or drag the slider.