Archives of the TeradataForum

Message Posted: Tue, 19 Mar 2002 @ 12:17:27 GMT

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

I currently capture detail information about SELECT queries that are run on our 5250 via access logging. The USER accounts are set up with &I and &T. This gives me a logon time, cpu usage, SQL text etc., but no logoff time/date etc. why??

I have a request from one of my customers, they want to know the elapse time of the query. But I can't find info via the ACCTG or ACCLOGTBL tables that would give me this. If they keep LOGON Time, why not LOGOFF Time?

Thanks, Tony.

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