16.20 - Ferret Commands - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - Teradata® Virtual Storage

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Publication ID
English (United States)
Last Update

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.