Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 29 Sep 2000 @ 18:38:33 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Access logging and utilities
From:   David Wellman


(sorry for the delay, I've been offline for a while)

You've had lots of useful info in this thread, but one point I'd like to add. You mention about tracking how long queries run for.

The Teradata Access Log doesn't do this directly. It records a start date/time, but not end date/time or elapsed time etc (not even in v2r4). In specific circumstances, you may be able to say that the time difference between two consecutive queries for the same session gives the elapsed time for the first, but that requires knowledge of your application.



P.S. love the "tuna fish" !

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016