Archives of the TeradataForum
Message Posted: Fri, 29 Aug 2003 @ 18:43:16 GMT
| Subj: | | Re: Query time |
| |
| From: | | Mandoda, Hamesh |
I dont' know if you can do this or what app you're running it with but if you are using ODBC you can always turn on tracing via the ODBC
administrator. This will give you a log of everything that passes through ODBC and I am pretty sure it includes time frames. I guess this
only helps if you're running some form of windows though...
I need to be able to capture the length of time that a query executes on teradata v2r4. Would setting the accountname of the user to &I
and using accesslog and ampusage give me what I need? Or is there another way?
| 
