FastExport and tpdid 1

[rickholc]

I am trying to access a Teradata server across a VPN connection. All of the utilities require the tpdid when connecting. Unfortunatley up until now all I have used is ODBC connections using the TCP/IP address. I am not sure how to establish the tpdid.

Here is what I am trying in fexp.exe:

.logon 192.168.0.1/username,password;

Tried entering 192.168.0.1 in my hosts file and used the name tdc.

.logon tdc/username,password;

Still doesn't work. What am I missing here?

Any help would be appreciated.

Rick

 

[dnoeth]

If you specify "tdc" as tdpid CLI will try to resolve the IP addresses of all the nodes of your system by adding "cop?" to it. "?" is an increasing number starting with 1.
So within your hosts file there must be an entry

192.168.0.1 tdccop1

if it's a multinode system there would be more entries

192.168.0.2 tdccop2
192.168.0.3 tdccop3
192.168.0.4 tdccop4

And if name resolution on your network is slow you can add an OS environment variable:
set tdc = 1
This will stop resolving after tdccop1 has been found.

Dieter

 

[rickholc]

Thank you very much. That worked perfectly. I am now using OleLoad to build scripts. Working fine.

Rick