15.00 - WAL Checkpoint Interval - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

WAL Checkpoint Interval

Purpose  

Determines the amount of time that elapses between WAL checkpoints.

Field Group

File System

Valid Range

1 through 240 seconds

Default

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.