Finding the LogicalHostId - Analytics Database - Teradata Vantage

Teradata Vantage™ - Analytics Database International Character Set Support - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aju1628095815656.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
hqj1472245413611
Product Category
Teradata Vantage

To assign a default character set for a host group, you must know the LogicalHostID for the group. The LogicalHostId is a 16-bit value equal to the host number + the client CPU architecture number.

You can find:
  • All the LogicalHostIds for a database system using the Configuration utility LIST HOST command. The output is similar to:
    HOSTs ARRAY
    ----------------------
    HostNo 	 LogicalHostID  Type   Connected PE Range
    ------ 	 -------------- ----  ------------------
    52          1076        COP   16379-16383
    821 	    821         IBM   16377
    829 	    829         IBM   16378

    For more information, see Teradata Vantage™ - Database Utilities, B035-1102.

  • The LogicalHostId through which an individual client logs on to the database by querying the DBC.SessionInfoV view, for example:
    SELECT hostno, logicalhostid, username FROM DBC.SESSIONINFOV;

    The output is similar to:

     HostNo LogicalHostId UserName
     ------ ------------- --------
     1      2049          MRN01END