16.10 - Overview - Teradata Database

Teradata Database Utilities

Teradata Database
Release Number
June 2017
English (United States)
Last Update

Teradata Database offers several interfaces from which the utilities may be started and run.

Interface Description
Database Window (DBW) DBW is a graphical tool that connects to the Teradata Database console subsystem (CNS). CNS provides console services to utility programs that operate on the database level of Teradata Database. Console utilities should be started from DBW.
Operators must be members of the tdtrusted user group to run console utilities, or must be logged in as root. Non-tdtrused users may be explicitly granted access to the console using the CNS GRANT command. For more information on the GRANT command, see the Database Window chapter of Utilities.

For low bandwidth connections, command-line interfaces to CNS are available, such as cnsterm and cnstool. Online documentation is available for cnsterm and cnstool in the form of Linux man pages.

A subset of the console utilities can be run from the Remote Console portlet of Teradata Viewpoint. For more information, see Teradata Viewpoint User Guide.

Linux command line Utilities that run directly from the command line are primarily those that operate on the PDE level of Teradata Database.

Chapter names in the Utilities and Support Utilities manuals reflect the utility common name followed by the name of the executable utility program enclosed in parentheses. For example, Control GDO Editor (ctl). Use the executable program name to start the utility from the command line or Database Window.

Not all utilities support all available user interfaces. For a listing of supported user interfaces for a utility, see the documentation for that utility.

When started, some utilities present their own interactive command-line or graphical user interfaces. These utilities allow browsing and entering information, and continue running until they are explicitly stopped. Many utilities that present their own command environment are stopped by entering the QUIT command.

Some utilities that run from DBW can be stopped by issuing the stop window_number command from the DBW Supervisor window, where window_number is the numeric identifier of the DBW application window in which the utility is running. For more information on DBW, see the "Database Window (xdbw)" chapter in Utilities.