17.10 - WAL Buffers - 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 number of WAL append buffers allocated by the File System.

Field Group

File System

Valid Range

5 through 40

Default

20

Changes Take Effect

After the next database restart.

Usage Notes

A larger number of buffers increases the chance that there will be an available buffer to hold a WAL log record when a task needs to append a WAL log record.

A smaller number of buffers risks that buffers may be unavailable because they are full and writes are pending.