Archives of the TeradataForum

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

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

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>>