Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 09 Mar 2016 @ 18:04:15 GMT


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


Subj:   Aborted Queries - Query Logging
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, March 09, 2016 12:59 -->

I did notice that queries that are aborted by the end user ? AMPCPUTIME of these queries doesn?t seem to have been captured correctly in DBQlogtbl. Has anyone else noticed this too? I was monitoring a query run by a user which was using more than 100K CPU and sent some recommendation to the user, he aborted the query, when I went back to DBQLogtbl? it shows the query used only 1012 AMPCPUTIME which is weird !



     
  <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