Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 13 Jun 2001 @ 19:56:26 GMT

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

Subj:   Re: Session Reporting on Teradata V2R4
From:   David Wellman


IF a lan session equates to a query, then can try the following;

1) set up your Teradata userid's with an accountname which includes &L. This will give you the session logon date/time in the dbc.ampusage accounting rows. This data tells you how much cputime and diskio's are used per amp per session.

2) use dbc.logonoff to find out how long the session was logged on for.

3) join these two pieces of information together on username and logondate and logontime and you get the information that you need.

IF not, then Teradata won't accurately give you the elapsed time of a query. You'd have to write a pre/post sql cli exit (if the exit point is available on unix) and tim eit manually.



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