Ferret Commands | Specifying Data Temperatures | Teradata Vantage - 17.10 - Ferret Commands - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Teradata® Virtual Storage

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

You can use the following Ferret utility commands to start an immediate Teradata VS migration, or explicitly set the data temperature of table rows or partitions at any time.

Command Valid SCOPE Options Function
BEGIN OPTIMIZE None Initiates immediate, high-priority migrations necessary to move cylinders modified by the FORCE command to appropriate classes of storage. Normal migration is a background, lower priority process.
CANCEL OPTIMIZE None Halts the immediate migration that was started by the BEGIN OPTIMIZE command, and returns migrations to a lower priority background process.
FORCE Vprocs Sets the classification of cylinders occupied by a table to a specified data temperature value, regardless of table data access history.