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

Teradata Vantageā„¢ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
July 2021
English (United States)
Last Update
The utility described is not available for as-a-service customers.

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.