Advanced SQL Engine | Utilities | Gateway Global (gtwglobal) | Teradata Vantage - Overview - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

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

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

Advanced SQL Engine 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 Advanced SQL Engine system errors.