17.10 - Console Utilities - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Teradata Viewpoint
Teradata Workload Management
Release Number
Release Date
October 2021
Content Type
User Guide
Publication ID
English (United States)
Information about available console utilities is listed below. You can access only the following subset of Teradata Database utilities.
Utility Description
Abort Host Cancel all outstanding transactions running on a failed host until the system restarts the host.
Check Table Check for inconsistencies between internal data structures, such as table headers, row identifiers, and secondary indexes.
Configure Define AMPs, PEs, and hosts, and describe their interrelationships for Teradata Database.
DBS Control Display and modify the DBS Control Record fields.
Ferret Define the scope of an action, such as a range of tables or selected vprocs, display the parameters and scope of the action, and perform the action. The action is to either move data to reconfigure data blocks and cylinders, or display disk space and cylinder free space percent in use.
Gateway Global Monitor and control the sessions of Teradata Database LAN-connected users.
Lock Display Display a snapshot capture of all real-time database locks and their associated currently running sessions.
Operator Console Run supervisor commands to manage the programs that perform Teradata Database operations.
Priority Scheduler Create, modify, and monitor Teradata Database process prioritization parameters. All processes have an assigned priority based on their Teradata Database session. Priority Scheduler allocates CPU and I/O resources based on the priority.
Query Configuration Display the current Teradata Database configuration, including the node, AMP, and PE identification and status.
Query Session Monitor the state of selected Teradata Database sessions on selected logical host IDs.
Recovery Manager Display information used to monitor progress of a database recovery.
Show Locks Display locks placed by archive and recovery, and by table rebuild operations on databases and tables.
Teradata DWM Dump Display information about active Teradata Dynamic Workload Manager (Teradata DWM) rules on a Teradata system.
Update Space Recalculates the permanent, temporary, or spool space used by a single database or by all databases in a system.
Vproc Manager Manage the vprocs including obtaining the status of specified vprocs, initializing vprocs, forcing a vproc to restart, and forcing a database restart.

Information on how to use a majority of these utilities is located in Teradata® Database Utilities. Information on how to use Teradata DWM Dump is in Teradata® Dynamic Workload Manager User Guide. Information on how to use Operator Console is in Graphical User Interfaces: Database Window and Teradata® MultiTool.

You can access these documents at: https://docs.teradata.com/.