MaxRequestsSaved - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
vkz1472241255652
Product Category
Software
Teradata Vantage

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 database restart.