16.10 - Overview - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

The Gateway Global utility, gtwglobal, allows you to monitor and control the sessions of Teradata Database workstation-connected users. The gateway software runs as a separate operating system task and is the interface between the network and the Teradata Database.

Client programs that communicate through the gateway to the Teradata Database can be resident on the Teradata Database system, or they can be installed and running on network-attached workstations. Client programs that run on mainframe-attached hosts bypass the gateway completely.

Teradata Database supports multiple gateways per node. The gateways must belong to different host groups and listen on different IP addresses.

The number of supported sessions is based on the following:

  • The number of allotted Parsing Engines (PEs)
  • Usage (resources consumed)
  • Maximum number of sessions per gateway setting in Gateway Control

Each logical network attachment requires at least one PE. Each PE can support up to 120 sessions.

When all the PEs in the DBS configuration are offline, Gateway Global exits, and the following message appears:

gtwglobal cannot proceed as no PEs are online.

When all of the PEs in any host group are offline, Gateway Global skips the group and continues to process information for the host groups with at least one PE online.

The number of sessions per gateway is defined using the gtwcontrol utility. For information on configuring gateway options, see Gateway Control (gtwcontrol).

Gateway errors are handled in the same manner as other Teradata Database system errors.