Hosts file and tdpid... on XP

[greaver]

Hi Guys,

I just installed Teradata Demo on my Windows XP box and the database works great. I'm having some problems with the BTEQ and Arc utility though. In both cases I get the error message when I attempt to logon:

*** CLI error: MTDP: EM_NOHOST(224): name not in HOSTS file or names database.

*** Return code from CLI is: 224
*** Error: Logon failed!

My hosts file currently has the entry:

127.0.0.1 localhost DemoTDATcop1

What entry do I need to add to the hosts file to make this work?

In addition, does anyone know where I can get/set the tpdid?


Sonny.

 

[greaver]

Found the answer. The tdpid is encoded in the alias given in the third column.

xxxcop?

Where ? can be any integer. So the tdpid in my case is DemoTDAT. FYIW, I copied the line and created a new tdpid (tdp1) that was easier to remember with the line


127.0.0.1 localhost tdp1cop1

Sonny.

 

[tdatgod]

Hi,
For future reference

You can have as many aliases as you want and you shouldn't really have duplicate IPaddresses on seperate lines. Some programs don't like that. You can just put them all on the same line.


127.0.0.1 localhost DemoTDATcop1 tdp1cop1 dbccop1


typically dbccop1 is the default TDPID.

if you type

.logon
username: <user>
password: <passwd>

Bteq will by default look for DBCcop1.


also the ? in cop? can not be ANY INTEGER. It must be an integer between 1 and the number of TPA nodes you have on your system. Being that you only have one node because it is the demo the ? in cop? must always be 1.

----