Record DBC.Hosts Information | Teradata Vantage - 17.00 - 17.05 - Recording DBC.Hosts Information - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Node Software Migration Guide

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
Configuration
Installation
featnum
B035-5942-170K

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 Advanced SQL Engine.

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.