DBS Control Parameters | Teradata Vantage - DBS Control Parameters for Tuning the Workload Cache Limits for Index and Partition Analysis - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1093
lifecycle
previous
Product Category
Teradata Vantage™

Index processing allocates workload cache for the purpose of caching information retrieved from the QCD and other temporary working structures and needed during Analysis and Validation phases of recommending indexes and partitioning expressions for various SQL workloads.

Two DBS Control performance group parameters control the respective workload cache sizes for the Analysis and Validation phases:
  • IAMaxWorkloadCache
  • IVMaxWorkloadCache

The following table provides some of the details for these parameters. See Teradata Vantage™ - Database Utilities , B035-1102 for further information.

Parameter Purpose Valid Range (megabytes) Default (megabytes)
IAMaxWorkloadCache Defines the maximum size of the workload cache for Analysis operations.

This parameter is applicable to both the INITIATE INDEX ANALYSIS and INITIATE PARTITION ANALYSIS statements.

32 - 256 8
IVMaxWorkloadCache Defines the maximum size of the workload cache for Validation operations. Validation is only performed under the direction of Teradata Support Center personnel. 1 - 32 48