skip to main content
Reference : Supported SQL Statements and Extensions : Set Checkpoint Defrag
  

Try DataDirect Drivers Now

Set Checkpoint Defrag

Purpose

The Set Checkpoint Defrag statement is used in conjunction with the Checkpoint statement. Set Checkpoint Defrag sets the threshold for triggering a Checkpoint Defrag.

Syntax

SET CHECKPOINT DEFRAG size
where:
size
specifies the threshold size.

Notes

*When a Checkpoint statement is performed, either as a result of the .log file reaching the limit set by Set Logsize or by the user issuing a Checkpoint statement, the amount of abandoned space in the database data (.data) file is checked. If it is larger than the value of size, a CHECKPOINT DEFRAG, which eliminates the abandoned space, is performed instead of CHECKPOINT.