WAL Buffers - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.