16.10 - Finding the LogicalHostId - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K

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 details, see Utilities.

  • 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