Start a Utility from Linux Command Line | Vantage - Starting a Utility from the Linux Command Line - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™
Operators must be members of the tdtrusted user group or have root access to run console utilities. Other users can run the utilities only if they have been explicitly granted access using the GRANT command. For more information on the GRANT command, see Database Window in Teradata Vantage™ - Database Utilities , B035-1102 .

Some utilities cannot be run from the Linux command line. They must be run from DBW or an equivalent tool, such as cnsterm or cnstool.

To start a utility from the Linux command line:

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

    tdatcmd

    at the Linux command line.

  2. On the command line type:

    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.

Utilities started from the Linux command line run in the node vproc. For some operations, some utilities require that they be run on an AMP vproc. In these cases, run the utility from DBW or an equivalent tool.

Unicode support on the Linux command line requires a locale that supports UTF8 encoding. The output display screen must use a font that supports the required Unicode glyphs. For example, the following command sets an xterm window to use a common font that supports all Unicode glyphs:

xterm -fn '-efont-fixed-*-r-*-*-16-*-*-*-*-*-iso10646-1'