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