16.10 - Starting a Utility from Database Window - Teradata Database

Teradata Database Utilities

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

Database Window (DBW) is an X client program that requires an X server to be running on the local machine. DBW supports standard X Windows display forwarding. To ensure that the graphical user interface displays properly, you can use the standard -display option to specify the host name or IP address of the local machine.

To start a utility from Database Window:

  1. If not already done, set up the Teradata Database environment by typing:


    at the Linux command line.

  2. Open DBW from the Linux command line by typing:

    xdbw –display displayspec &

    where displayspec is the name or IP address of the local machine, followed by a colon and the server number, typically 0 or 0.0. For example:

    xdbw -display myworkstation.mycompany.com:0.0 &


    xdbw -display &

    The DBWmain window opens.

  3. Click the Supvr button to open the Supervisor (supv) window.

  4. Under Enter a command type:

    start utilityname [ options ]

    where utilityname is the name of the utility, and options can include any of the available command-line options and arguments of that utility. utilityname is not case-sensitive.

    The following message appears:

    Started ' utilityname ' in window x

    where x is the number of one of the four available application windows DBW provides.

Utilities started from DBW run in the control vproc, usually vproc 0, unless the VPROC option of the START command is used to specify a different vproc. For more information, see the Database Window utility documentation in Utilities.

Each utility started runs in one of the four application windows. The title bar of the application window and the corresponding button in the DBW main window change to reflect the name of the running utility. When the utility stops running, the application window and main window button revert to the default text title (that is, Appl1, Appl2, and so forth).

Up to four utilities can be run concurrently in DBW. The message All Interactive Partitions are busy!! indicates that all four application windows are occupied. In this case, you must quit from one of the four running utilities before another can be started.

For more information on DBW and CNS commands, and on options that are available with the START command, see the “Database Window (xdbw)” chapter in Utilities.