16.20 - Ferret Commands - Teradata Vantage NewSQL Engine

Teradata Vantage™ - Teradata® Virtual Storage

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
featnum
B035-1179-162K

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.