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. |