Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 22 Jan 2008 @ 21:27:35 GMT

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

Subj:   Re: Connection reset by peer
From:   steve.tennant


Co-incidentally, I have been battling with this problem for some months. One thing I can say is that it is not a SQL Assistant setting. It simply appears that SQL Assistant is more sensitive to 'disconnects/timeouts' than other pieces of software.

Thinking I had a Teradata issue I raised lots of problem-records and we got nowhere. I then discovered that other people were having apparently unrelated networking errors. Things like:- network drives momentarily disappearing and other connections (eg Oracle/DB2) dropping out.

I have had a couple of ports monitored for several days and just yesterday one solution seems to have had a positive effect.

There is a tcp/ip setting called MTU (Maximum transmission Unit). The default on W2k is 1500 which is not always a good thing. By adding this to the registry with a lower setting (1440) at least one user has gone from 15-20 peer disconnects last week to none yesterday and today.

You may want to Google for this setting as the defaults for different o/s varies.


Steve T

  <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: 23 Jun 2019