Tuning and Troubleshooting Teradata Virtual Storage | Teradata Vantage - 17.10 - Tuning and Troubleshooting Teradata Virtual Storage - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Teradata® Virtual Storage

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

This section provides information on using DBS Control and Ferret utilities to tune and troubleshoot Teradata VS. See Teradata Vantage™ - Database Utilities, B035-1102 for more information on working with the DBS Control and Ferret utilities.

The Virtual Storage collector and TVS Monitor portlet of Teradata Viewpoint allow you to collect and view statistics on data temperature and storage grade of cylinders allocated in Teradata VS. Statistics reflect current relationships between data temperature and storage grade, and historical trends in the management of storage grades based on data temperature. Temperature and grade metrics can help assess storage requirements for data, as well as aid in fine tuning the balance between disk performance and data-access demands. For more information about the TVS Monitor portlet, see Teradata® Viewpoint User Guide, B035-2206.

Teradata Virtual Allocation Manager (tvam program) is a tool for managing storage optimization and data migration aspects of Teradata VS. It should be used only under the direction of Teradata Support Center personnel. Documentation for tvam includes a man page and online help.