15.00 - Appendix B Starting the Utilities - Teradata Database

Teradata Database Utilities

Teradata Database
Release Number
Content Type
Publication ID
English (United States)
Last Update


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




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.

Note: 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 Database Window (DBW).

For low bandwith connections, command-line interfaces to CNS are available, such as cnsterm and cnstool. Information on cnsterm and cnstool is available in man page online documentation.

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.

Host Utility Console (HUTCNS)

HUTCNS runs a subset of utilities from a mainframe-attached host terminal. It runs only on the z/OS operating system.

Chapter names in the 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.

Note: Not all utilities support all available user interfaces. For a listing of supported user interfaces for each utility, see the documentation for each 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.