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

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
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