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