Archives of the TeradataForum
Message Posted: Tue, 19 Mar 2002 @ 12:17:27 GMT
| Subj: || || Access Logging Info |
| From: || || Tony Howe |
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?