Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   How To restrict the number of rows returned by a user's queries
 
From:   Joseph V D silva

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016