Archives of the TeradataForum

Message Posted: Tue, 07 Sep 2004 @ 22:57:13 GMT

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

With ODBC connection strings you are required to set:

     DBCName=cop1;DBCName2=cop2;DBCNameN=copN;

For the JDBC connection URL, you only send jdbc:teradata://<systemname>/

The driver handles the load balancing.

From "Teradata Driver for the JDBC Interface User Guide" Chapter 2, Page 4:

COP Selection
The use of aliases and DNS round robin can be used to more evenly distribute connections across COP entries. Unlike the type 3 driver, the type 4 driver looks up the server name that was passed by the application in the DNS and connects to that host. Round robin is used to select the host to make the connection, but if that host is not available, there is no retry and the connection fails.

Adam Stout
A Teradata Certified Master, V2R5
Certified CFMX Adv. Developer

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