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