17.10 - WAL Checkpoint Interval - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

Determines the amount of time that elapses between WAL checkpoints.

Field Group

File System

Valid Range

1 through 240 seconds


60 seconds

Changes Take Effect

After the DBS Control Record has been written.

Usage Notes

A WAL checkpoint is used to indicate the oldest part of the WAL log that must be scanned when recovering from a system crash. It differentiates the WAL log records that have been written to disk from the records that must be applied during system recovery. The checkpoint is used as the starting point for the Redo forward scan of the WAL log during recovery.