17.10 - MaxRequestsSaved - 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)

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.