DISPLAY NETWORK - 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 NETWORK command displays information about your network configuration and its associated gateway.

Syntax

{ DISPLAY | DI } { NETWORK | NE } [ { LONG | LON } | host_no ]
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
    • Node the gateway vproc is running on, in the format cabinetID-moduleID
    • 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
  • Node the PE vproc is running on, in the format cabinetID-moduleID
  • 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: Displaying network and gateway configuration information

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 Node   Sessions Logon    Trace
------- ------ -------- -------- --------
8193    001-02 0        Enable   Disable

Host 1 has 20 session(s) over 1 GTW(s) and 2 PE(s)
( 18 Active / 0 Disconnected / 2 Forced)

Gateway Node   Sessions Logon    Trace
------- ------ -------- -------- --------
8192    001-01 18       Enable   Disable

Example: Displaying network and gateway configuration information (long format)

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

di ne long

Host 1 has 0 session(s) over 1 GTW(s) and 2 PE(s)
( 0 Active / 0 Disconnected / 0 Forced)

PE      Node   Sessions
------- ------ --------
30719   001-01 0
30718   001-01 0

Gateway Node   Sessions Logon    Trace
------- ------ -------- -------- --------
22528   001-01 0        Enable   Disable