16.10 - LIST 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 LIST HOST command displays all hosts in the current or new configuration, or in a specified contiguous map.

Syntax



SHORT
Displays summarized information from the configuration or contiguous map. This is the default.
LONG
Displays detailed information from the configuration or contiguous map.
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 all hosts in a configuration

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

HOSTs ARRAY
_______________________
HostNo    LogicalHostID        Type    Connected PE Range
______    _____________        ____    __________________
 52            1076            COP     16379-16383
 821           821             IBM     16377
 829           829             IBM     16378
HOSTs ARRAY
_______________________
HostNo    LogicalHostID        Type    Connected PE Range
______    _____________        ____    __________________
 52            1076            COP     16379
                                       16380
                                       16381
                                       16382
                                       16383
821             821            IBM     16377
829             829            IBM     16378

For information about the ranges of logical host IDs for all supported hosts, see Hosts.