15.00 - DISPLAY GTW - 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

DISPLAY GTW

Purpose  

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

Syntax  

 

Syntax element...

Is the...

gtwid

vproc number of the gateway containing the sessions you want to display.

ALL

keyword that displays all sessions regardless of selected Host Group.

Note: To list all possible values for gtwid, use “DISPLAY NETWORK” on page 647.

Usage Notes  

For a specific gtwid, Gateway Global shows:

  • Gateway vproc number
  • Number of sessions on the gateway
  • The following information for each session:
  • Session ID number
  • PE vproc number
  • 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
  • Session ID number
  • PE vproc number
  • 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  

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

    di gtw 8192
     
    GTW 8192 has 18 sessions
     
    Session PE    User IP Adr          Status    SP PP RNP
    ------- ----- ---- --------------- --------- -- -- ---
    1001    16383 DBC  141.206.35.30   CONNECTED N     No
    1003    16383 DBC  141.206.35.30   CONNECTED N     No
    1005    16383 DBC  141.206.35.30   CONNECTED N     No
    1006    16382 DBC  141.206.35.30   CONNECTED N     No
    1007    16383 DBC  141.206.35.30   CONNECTED N     No
    1008    16382 DBC  141.206.35.30   CONNECTED N     No
    1009    16383 DBC  141.206.35.30   CONNECTED N     No
    1010    16382 DBC  141.206.35.30   CONNECTED N     No
    1011    16383 DBC  141.206.35.30   CONNECTED N     No
    1012    16382 DBC  141.206.35.30   CONNECTED N     No
    1013    16383 DBC  141.206.35.30   CONNECTED N     No
    1014    16382 DBC  141.206.35.30   CONNECTED N     No
    1015    16383 DBC  141.206.35.30   CONNECTED N     No
    1016    16382 DBC  141.206.35.30   CONNECTED N     No
    1017    16383 DBC  141.206.35.30   CONNECTED N     No
    1018    16382 DBC  141.206.35.30   CONNECTED N     No
    1019    16383 DBC  141.206.35.30   CONNECTED N     No
    1020    16382 DBC  141.206.35.30   CONNECTED N     No

    Example  

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

    di gtw all

    System WUSRH122051-JEA has 1 connected session

    HG  GTW   Session PE    User              IP Adr          Status    SP PP RNP
    --- ----- ------- ----- ----------------- --------------- --------- -- -- ---

    1   8193  1005    16383 PERM01            141.206.38.109  CONNECTED N     No