Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 02 Dec 1999 @ 04:18:35 GMT


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


Subj:   Monitoring queries
 
From:   Gavin Goldsmith

G'Day

Something which has puzzled me; is there a way to monitor what a SQL query is doing?>

MLoad makes quite a bit of info available via Qrysessn, this is not true for standard SQL. As I write I have 2 user queries which have run for many hours longer than expected and I've no idea what they're doing.

A while back we had the DB go down due to a piece of BAD SQL. At the time Support was able to identify the EXACT piece of SQL which caused this. It'd great If one had access to this level of detail.


Thanks

Gavin



     
  <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