Archives of the TeradataForum

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

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

Craig,

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.

Regards,

Steve T

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