Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 Jul 2006 @ 20:34:42 GMT


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


Subj:   Re: Troubleshooting Teradata Client Connections
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, July 26, 2006 16:32 -->

  Is there a way to tune and/or troubleshoot the connection to teradata from a client via both odbc and oledb. Once we establish a connection, the processing is fast, but sometimes the initial connection can take up to 30 seconds to connect.  


May be your ODBC DSN is configured with multiple cop entries(i.e., the Teradata nodes) under HostName. If one is down, ODBC waits till the timeout (approx 20 seconds) to try the next. So, make sure all hostnames in the ODBC DSN are correct before you check anything else.



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023