Space Usage View - Teradata Workload Management - 16.20

Teradata® Viewpoint User Guide

prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K

The Space Usage view displays information about databases and nodes on the selected system. For Teradata Database systems, the view displays a summary of perm, spool, and temp space for each database on the selected system. Use this information to see if you need to reallocate disk space to maximize space usage.

For Teradata Aster systems, the view displays the number of tables and amount of space used for each database on the selected system.

For Teradata Hadoop systems, the view displays the host names, total space, current space, percent in use and available space for each node on the selected system.

The following list describes the features in this view:

Selection Menus
Displays the system and space usage report. You can choose a different system and report.
Threshold Filter Bar
Displays the number of databases on the system and the number of databases whose space usage exceeds set thresholds. This feature is available only for Teradata Database systems.
You can set the thresholds in the Settings view.
Filters
Shows only rows that match your filter criteria.
Table Actions
This feature is available only for Teradata Database systems.
Clear Filters removes any content in the filter boxes.
Configure Columns allows you to choose the columns to display and set thresholds.
Export creates a .csv file containing all available data. If filters are applied, only filtered data is exported

For more information, see Summary Table Controls.

Add Space
Reallocates permanent disk space from one database to another. This feature is available only for Teradata Database systems.
Summary Table
Displays summary information for the space usage report. The table is configured in the Configure Columns dialog box. Click a row in the table to see details.

Following is an example of the Space Usage view that appears when you select a Teradata Database system from the selection menu.



Following is an example of the Space Usage view that appears when you select a Teradata Aster system from the selection menu. The Teradata Hadoop system view shares the same features as the Teradata Aster system.