Archives of the TeradataForum

Message Posted: Mon, 29 Oct 2007 @ 14:22:46 GMT

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

Good morning,

I have been using SQL Assistant with DB2 ODBC drivers querying DB2 for a long time and all version had been working very well and fast on returning the answer sets. However, after I upgraded from 6.2 to 7.1 and/or 7.2, it has becoming sooo slow fetching an answer set (serval seconds per row) and it will finally crash without completing the fetch.

I have tested the version 7.x on two of my three computers and both have the same behavior. My third computer is still running the 6.2 and returning the same answer set just like a boom and its done; extremely fast!

Is there any special setting I overlooked for the 7.x that causing this mal-behavior? Any suggestion would be greatly appreciated.

Thanks very much.

John

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