16.20 - Finding the LogicalHostId - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine International Character Set Support

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
User Guide
featnum
B035-1125-162K

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