How to disable DNS COP lookup at login

Connectivity

How to disable DNS COP lookup at login

We have Cold Fusion 8 on Linux in the DMZ. Teradata 14 resides in the LAN. Logins from the DMZ (jdbc) are painfully slow. The network admin sees repeated DNS requests when logins are attempted. The DNS server is on the LAN. DNS requests are not allowed through the firewall.

We would like the connection request to use the /etc/hosts COP entries on the Cold Fusion server...without attempting DNS lookups. If the jdbc connection is defined with just an IP address (no COP entries)...it works fine.

Can we disable the DNS portion of logins when using jdbc?

Tags (3)
2 REPLIES
Teradata Employee

Re: How to disable DNS COP lookup at login

Yes, you can define the Teradata Database hostname in an /etc/hosts file and the Teradata JDBC Driver will use that.

You should specify the COP=OFF connection parameter so that the Teradata JDBC Driver does not perform COP Discovery.

http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#URL_COP

You can specify multiple IP address for a single hostname. You should list the IP addresses of each of your Teradata Database nodes, and define them all as the same hostname.

10.0.0.1 tomtera.teradata.com

10.0.0.2 tomtera.teradata.com

10.0.0.3 tomtera.teradata.com

(repeat as needed for all your Teradata Database nodes)

The problem with this approach is that no round-robin or load distribution will occur. All connections will go to the first IP address listed, unless that node is down, in which case the second IP address will be used, and so on.

The best solution would be to fix your firewall so that DNS traffic is properly allowed through.

Re: How to disable DNS COP lookup at login

Thanks for the explanation...exactly what we were looking for.