MaxRequestsSaved - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

Specifies the maximum number of request-to-step cache entries that can be saved per PE.

Field Group

Performance

Valid Range

The valid range depends on the amount of memory on the node that runs the control AMP. The control AMP is the lowest numbered ONLINE AMP on the system.

Control AMP Node Memory Valid Range
250 GB or greater 450 through 6000
Less than 250 GB 300 through 2000

The value must be a multiple of 10.

Default

Control AMP Node Memory Default
250 GB or greater 6000
Less than 250 GB 600

Changes Take Effect

After the next Teradata Database restart.