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

Purpose  

The DISPLAY NETWORK command displays information about your network configuration and its associated gateway.

Syntax  

 

Syntax element...

Is the...

host_no

host group number (in decimal).

LONG

display of the gateway statistics for the particular network.

Usage Notes  

The default setting for the DISPLAY NETWORK command is the short form report, which gives this information for the specified host group, or for each host group in Teradata Database:

  • Host group number(s)
  • Total number of sessions on the host group
  • Total number of gateways assigned to host group
  • Total number of PEs assigned to host group
  • Total number of active sessions on the host group
  • Total number of disconnected sessions on the host group
  • Total number of forced off (killed) sessions on the host group
  • The following information about each gateway in the host group:
  • Vproc number of the gateway
  • Total number of sessions connected to the gateway
  • Logon information (either Enabled or Disabled)
  • Tracing information (either Enabled or Disabled)
  • The long form displays the following information about each PE in a host group in addition to the information displayed in the short form report for the network:

  • Vproc number of the PE
  • Total number of sessions connected to the PE
  • If host_no is used to request a specific host group number, the long form cannot be requested.

    Example  

    To display information about your network configuration and its associated gateway in the short form, type:

    di ne 
     
    Host 2 has 0 session(s) over 1 GTW(s) and 1 PE(s)
    ( 0 Active / 0 Disconnected / 0 Forced)
     
    Gateway Sessions Logon    Trace
    8193    0        Enable   Disable
     
    Host 1 has 20 session(s) over 1 GTW(s) and 2 PE(s)
    ( 18 Active / 0 Disconnected / 2 Forced)
     
    Gateway Sessions Logon    Trace
    8192    18       Enable   Disable

    Example  

    To display information about your network configuration and its associated gateway in the long form, type:

    di ne long
     
    Host 52 has 10 session(s) over 1 GTW(s) and 2 PE(s)
    ( 10 Active / 0 Disconnected / 0 Forced)
     
    PE       Sessions
    16382     5       
    16383     5       
     
    Gateway   Sessions  Logon     Trace   
     8192     10        Enabled   Enabled