Start a Utility from Database Window | Vantage - 17.10 - Starting a Utility from Database Window - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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 database environment by typing:

    tdatcmd

    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 &

    or

    xdbw -display 192.0.2.24:0.0 &

    The DBW main window opens.

    Database Window (DBW) main window

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

    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 Teradata Vantage™ - Database Utilities, B035-1102.

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 Database Window in Teradata Vantage™ - Database Utilities, B035-1102.