TIM Cache Load Throttle - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

Determines whether the Teradata Intelligent Memory (TIM) cache preload task is throttled during system startup to allow other I/O operations to complete first.

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 background cache preload process is throttled. It only loads VERYHOT cylinders into cache when the Teradata Database I/O subsystem is idle. This can improve startup performance on busy systems.
FALSE TIM background loading task is unthrottled, and loads VERYHOT cylinders into cache immediately after the system startup sequence reaches the logons-enabled stage. 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

For more information, see TIM Cache Load Disabled.