16.10 - DISPLAY NETWORK - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

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

Syntax



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