15.00 - Chapter 15 Gateway Global (gtwglobal) - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

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 Chapter 14: “Gateway Control (gtwcontrol).”

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

    Scenarios Runs From

  • Database Window or comparable interface to the Teradata Database console subsystem, such as cnsterm
  • Linux command line
  • Teradata Viewpoint Remote Console portlet
  • For general information on starting the utilities from different interfaces, see Appendix B: “Starting the Utilities” For information on Viewpoint, see Teradata Viewpoint User Guide.

    Syntax

     

    Syntax Element

    Description

    -u

    User names are treated as UTF-8 character encoding for input and output. Use this startup option if you have a display capable of showing UTF-8 characters.

    Usage Notes

    By default, Gateway Global treats user names as ISO 8859-1 (Latin-1) encoding. Characters that cannot be represented in 7-bit ASCII, or that are non-printable are represented using the Unicode delimited identifier format.

    User names that contain no characters that would require the use of Unicode delimited identifier syntax, but that contain characters that would require quoting in SQL (such as names containing a space character), can be represented by simple double-quote character (“) delimited identifiers, for example “john doe”. Unicode delimited identifiers and identifiers enclosed in double quotation marks are described in SQL Fundamentals.