16.20 - Recording DBC.Hosts Information - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Node Software Migration Guide

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
Configuration
Installation
featnum
B035-5942-162K

The system DBC.Hosts table contains the logical host ids, host names and default character sets for each network and host connection. This information is specific to the destination system environment and was configured during the installation of the Teradata Database.

During the migration, the DBC.Hosts file of the source system is transferred to the destination system, overwriting the destination system configuration data. The source system settings may not be correct for the destination system environment and may need to be updated.

Assuming that the destination system hosts table is set up correctly, the information must be saved before migrating the data from the other system which will overwrite it. The HostsInfo view must be used to display the information in a readable format.

  1. Log on to the destination system Control Node over the network.
  2. Start BTEQ and log in.
  3. Find the contents of the current DBC.HostsInfo: SELECT * FROM dbc.hostsinfo;

    The response is similar to:

    LogicalHostId HostName    DefaultCharSet
    ------------- ----------- -------------------
    101           MVS1        KANJIEBCDIC5035_0I
    1025          COP         KANJIEUC_OU

    The output shows columns for Logical Host ID, Host Name, and Default Character Set for each host system configured in the destination system environment. COP is the network connection you logged in through for this session. In this example, the Default Character Set used for the network sessions is KANJIEUC_0U. This example also shows there is a Channel-connected host, MVS1, connected to the destination system.

  4. Save the DBC.Hosts query results to a text file for later reference.