What is the TDPID and how to do remote connections

Connectivity
Highlighted
Enthusiast

What is the TDPID and how to do remote connections

Hi All,

I'm a newbie so please forgive my silly questions. I really appreciate any assistance.

1. What is the TDPID and can it be changed for different interfaces such as one for the 1GB interface and another for the 10GB interface on a Teradata server?

2. What is the best practice or recommended method to have remote user connections to access Teradata database such that the connections are load balanced across all nodes with failover to the HSN when it comes online due to a node failure? We are trying to setup COPs aliases for CLI and ODBC connections and need some guidance. We are setting up the below (contrived example):

IP -> ANAME -> CNAME (<TDPID>cop<n>

10.30.250.1 -> tdprd01 -> prd1cop1

10.30.250.2 -> tdprd02 -> prd1cop2

10.30.250.3 -> tdprd03 -> prd1cop3

Thanks for your kind assistance.

Tags (1)