15.10 - Ferret Commands - Teradata Database

Teradata Database Teradata Virtual Storage

prodname
Teradata Database
vrm_release
15.10
category
Configuration
featnum
B035-1179-151K

You can use the following Ferret utility commands to start an immediate Teradata VS migration, or explicitly set the data temperature of tables, rows, or ranges of rows 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.