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.
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
For more information, see TIM Cache Load Throttle.