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.
- Log in to the destination system Control Node over the network.
- Start BTEQ and log in.
-
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_OUThis shows the 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.
You must use the DBC.HostsInfo view for the information to display correctly. - Save the DBC.Hosts query results to a text file for later reference.