16.10 - SHOW HOST - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

Purpose

The SHOW HOST command displays the host number, logical host ID, host type, and vproc numbers of connected PEs.

Syntax



HN = nnnn
the host number.
The host number ranges from 1 to 1023.
FROM or F
Use this to specify the map that contains the information you want to list:
  • CURRENT or C is the current configuration map. This is the default if you do not specify FROM or F.
  • NEW or N is the new configuration map, which will be in effect only after you run the Reconfiguration utility.
  • mapname or mapnumber identifies a contiguous map.

Example: Displaying information about a specified host

To display information from the current configuration map about host 10, type:

show host hn = 10

An example output generated by the SHOW HOST command is shown below:

HOSTs ARRAY
___________________
HostNo     Logical HostID        Type      Connected PE
___________________________________________________
10            17                IBM       16383
10            17                IBM       16382
10            17                IBM       16381