SELECT HOST - Teradata Vantage - Database Engine 20

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2026-03-26
dita:mapPath
ron1747160181474.ditamap
dita:ditavalPath
ft:empty
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

The SELECT HOST command selects the host number of a group of gateways, and the PEs that have been assigned to those gateways. Subsequent Gateway Global commands will affect only those selected gateways until a new SELECT HOST command is issued. In this context, the specified collection of gateways and PE comprises a host group.

Syntax

{ SELECT | SE } { HOST | HO } host_no

Syntax Elements

host_no
Host group number.

Example: Specifying a host for subsequent Gateway Global commands

To select host group 1, type:

select host 1
IF the Host Group number is... THEN the following message appears...
found Host 1 has been selected.
not found Invalid Host 1 is entered. Please try again!

To deselect a host group, type:

select host 0