Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 01 Feb 2013 @ 11:27:59 GMT


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


Subj:   Re: Query Execute time
 
From:   Dave Wellman

Hi,

If the query has completed then look in DBQLOGTBL or QRYLOG.

The QRYLOG view has a derived column called ELAPSEDTIME. If you are using the raw data then use the same calculation (FIRSTRESPTIME - STARTTIME). This gives you "dbms time" and does not include the tim eit took to return the answer set to the client program. It also does not account for any time the query was delayed by TASM settings. If you want to include that then you have to subtract the DELAYTIME field.

If you want to know how long the query took to send back the answer set then this can only be done on 13.10. You need to set a DBSControl setting to a particular value and then use the RESP rows in DBQLSTEPTBL.


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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