Assigning Default Client Character Sets in DBC.HostsInfoV - 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

After determining the LogicalHostId of the host for which you want to specify a default character set, you can make the assignments in the DBC.HostsInfoV view.

  1. Use an INSERT statement to add a row in the DBC.HostsInfoV view for each host, for example:
    INS INTO DBC.HostsInfoV (1076, 'PC_LAN', 'LATIN1_0A');

    where:

    Syntax Element Description.
    1076 LogicalHostId
    'PC_LAN' Host name
    'LATIN1_0A' Default character set
  2. Perform a restart of the database, using the tpareset utility, to activate the defaults.
    IF the restart... THEN...
    successfully activates the default character sets the character set name and identifier for each client system are sent to the appropriate TDP during startup.
    encounters errors with a default character set the system defaults to this host character set:
    • EBCDIC for mainframe clients
    • ASCII for all other clients
  3. Go to /var/log/messages to check for errors associated with loading default character sets into DBC.HostsInfoV.

    When the system attempts to validate the rows in DBC.HostsInfoV, if a character set in the view is not enabled, the system logs an error in the /var/adm/messages log, for example:

    3133: Default Character Set is invalid.
    On Fri Apr 18 10:51:05 2003 on NODE 001-01, VPROC 16383, partition 13, task disabrt
    Default Character Set name:  'Portuguese_EBCDIC             '
  4. If the log contains any errors, correct the problems and re-run steps 2 and 3.