Archives of the TeradataForum

Message Posted: Tue, 28 Oct 2014 @ 16:46:30 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Tuesday, October 28, 2014 10:30 -->

Hard-coding numeric IPs is seldom recommended.

If you use the "COP enumeration" method and specify a "TDPID" prefix for the connection (say DBC) and have corresponding network names (DNS Alias or hosts file entries) DBCCOP1, DBCCOP2, etc. for all your nodes including any hot spares, then the Teradata client drivers provide failover in case a node is down.

If you have some network device (like F5 /BigIP) available to provide a "virtual IP", that can work also. But the native Teradata driver mechanisms don't have the added cost.

	<Prev	Next>		<<First	<Prev	Next>	Last>>