When using SAS/ACCESS to Teradata, the following error may be encountered:

ERROR: Teradata connection. MOSI: ER_HOST(117) DBC Name not found. Possible HOSTS File problem.

To address this, make sure the TDPID= option is on the LIBNAME statement. Also, check the HOSTS file to make sure the value specified for TDPID is listed and correct.

By default, SAS/ACCESS Interface to Teradata connects to the server that corresponds to the dbccop1 entry in your HOSTS file. When you run only one Teradata server and your HOSTS file defines the dbccop1 entry correctly, specifying TDPID is not necessary. However, if you are running more than one Teradata server, you can use the TDPID option to override the default.

libname ter teradata user=xxx password=zzz tdpid=dbcname;