TIM Cache Load Disabled - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

Determines whether the Teradata Intelligent Memory (TIM) cache preload task is enabled.

When enabled, the TIM preload task loads the most frequently accessed data into the TIM cache (a portion of FSG cache) during system startup, after the logons-enabled stage. This allows faster access to this data.

This field applies only when FSG cache is not otherwise preserved across a system reset, such as when the tpareset -x or -f options are used to force a reset.

Field Group

Storage

Valid Settings

Setting Description
TRUE TIM preloading task is disabled.

Data is not preloaded into cache during Teradata system startup.

FALSE TIM preloading task is enabled.

TIM preloads the most frequently accessed data into FSG cache during system startup. This is the default.

Default

FALSE

Changes Take Effect

During the next Teradata system restart.

Usage Notes

Frequency of data access is monitored by Vantage. Cylinders containing the most frequently accessed data are designated to have a data temperature of VERYHOT. These cylinders are loaded into the TIM cache during system startup.

Related Information

For more information, see TIM Cache Load Throttle.