Archives of the TeradataForum
Message Posted: Tue, 22 Jan 2008 @ 21:27:35 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|