DISPLAY GTW - Analytics Database - Teradata Vantage

Database Utilities
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantage™

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

Syntax

{ DISPLAY | DI } GTW { gtwid | ALL }

Syntax Elements

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 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