Archives of the TeradataForum

Message Posted: Tue, 22 Jan 2008 @ 16:27:15 GMT

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

I have a user who frequently says they get connection reset by peer messages when running SQL Assistant. Is there a table or log that would contain information for when a connection is reset? I'm trying to tie the times of the resets to SQLs running by this user in the dbqlogtbl table to see if there is a connection to the SQL they are running.

They also mentioned that it seems to occur when they are running SQLs with embedded variables. I've tried running the SQLs they've sent me on my machine (with the same ODBC and SQL Assistant version) and am not able to duplicate the problem.

They say it doesn't always happen during the same SQL.

Has anyone encountered a similar problem or have any ideas as to what else to check?

Thanks

Craig

Craig Ferry
Sr. Database Administrator
WESCO Distribution, Inc.

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