15.00 - TIM Cache Load Disabled - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

TIM Cache Load Disabled

Purpose  

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.

Note: This setting 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 Database 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 Database system restart.

Usage Notes  

Frequency of data access is monitored by Teradata Database. 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 Topics

See “TIM Cache Load Throttle” on page 473.