15.00 - WAL Buffers - 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 Buffers

Purpose  

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 Teradata 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.