Archives of the TeradataForum

Message Posted: Fri, 24 Jun 2005 @ 16:03:13 GMT

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

Hi All,

To make short of my problem, our websphere is crashing because some where in the pages there are queries which are fetching quiet a lot of rows from teradata which kinds of eats up all the memory available (attempts to search on queries are ending up to be tedious as we have quiet a lot of webpages)

So my question is ....... is there a way by which we can restrict the number of rows returned by the queries for a particular user id (may be abort those queries) , we are hoping to identify the reports causing the problem that way.

Does teradata dynamic query manager (TDQM) do any such work ?

Thanks,

Joseph Vinish D'silva

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