Archives of the TeradataForum
Message Posted: Fri, 01 Feb 2013 @ 11:27:59 GMT
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.
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|