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

Teradata® Virtual Storage

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
yje1557098840879.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1179
lifecycle
previous
Product Category
Teradata Vantage™

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.