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

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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.