DISPLAY GTW - 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ā„¢

Purpose

The DISPLAY GTW command displays all sessions connected to the gateway.

Syntax

{ DISPLAY | DI } GTW { gtwid | ALL }
gtwid
vproc number of the gateway containing the sessions you want to display.
ALL
Keyword that displays all sessions regardless of selected Host Group.
To list all possible values for gtwid, use DISPLAY NETWORK.

Usage Notes

For a specific gtwid, Gateway Global shows:
  • Gateway vproc number
  • Node the gateway vproc is running on, in the format cabinetID-moduleID
  • Number of sessions on the gateway
  • The following information for each session:
    • Session ID number
    • PE vproc number
    • Node the PE vproc is running on, in the format cabinetID-moduleID
    • Local? can be Yes or No. Yes indicates that the PE and gateway vprocs are running on the same node.
    • User name associated with the session
    • Internet address of the originating host for the session
    • Status
    • SP (Client Security Policy)
    • PP (Proxy Security Policy)
    • RNP (Recoverable Network Protocol)
If the ALL keyword is specified, Gateway Global shows:
  • Name of the Teradata Database
  • Total number of sessions for all gateways
  • The following information for each session:
    • Host group number
    • Gateway vproc number
    • Node the gateway vproc is running on, in the format cabinetID-moduleID
    • Session ID number
    • PE vproc number
    • Node the PE vproc is running on, in the format of cabinetID-moduleID
    • Local? can be Yes or No. Yes indicates the PE and gateway vprocs are running on the same node.
    • User name associated with the session
    • Internet address of the originating host for the session
    • Status
    • SP (Client Security Policy)
    • PP (Proxy Security Policy)
    • RNP (Recoverable Network Protocol)

Example: Displaying sessions connected to a specified gateway

To display a gateway (for example, gateway 22528), type:

di gtw 22528

The following appears:

GTW 22528 on node 001-01 has 18 sessions
Session PE    Node   Local? User   IP Adr     Status    SP PP RNP
------- ----- ------ ------ ------ ---------- --------- -- -- ---
1001    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1003    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1005    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1006    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1007    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1008    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1009    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1010    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1011    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1012    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1013    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1014    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1015    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1016    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1017    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1018    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1019    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No
1020    30719 001-01 Yes    TEST   192.0.2.30 CONNECTED N     No

Example: Displaying sessions on all host groups

To display all of the gateway sessions on all host groups, type:

di gtw all

The following appears:

System WUSRH122051-JEA has 1 connected session

HG  GTW   Node   Session PE    Node   Local? User IP Adr     Status    SP PP RNP
--- ----- ------ ------- ----- ------ ------ ---- ---------- --------- -- -- ---
1   22528 001-01 1005    16383 001-01 Yes    TEST 192.0.2.30 CONNECTED N     No