17.10 - Finding the LogicalHostId - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

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