We are using JDBC template to estatblsih connection bewteen Application and Teradata,but it's taking more than 15 sec to establish connection. Anyone can help us to solve this.
You can specify the LOG=TIMING connection parameter, which will log to System.out the elapsed time for each of the steps of establishing the socket connection and logging on to the Teradata Database.
I don't know about JDBC, but this seems to be related to the network speed, locally it's 30 ms but on the server 300 ms to get a response, check ping/traceroute timings.
I agree with Dieter that the network speed differs between the two connections.
For the "server" connection, how far away from each other are the client and server machines? For example, is one machine in Europe, and the other in North America?