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

Teradata Vantage™ - Teradata® Virtual Storage

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Configuration
Publication ID
B035-1179-170K
Language
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.