Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 18 Feb 2011 @ 10:14:42 GMT

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

Subj:   Re: Report from dbc.qrylog by MONTH using SQL
From:   sivaji.gv


Always use starttime instead of collecttimestamp when querying DBQL. Both normally differ by few seconds to minutes.

I saw the difference between these two times in hours when the query got delayed for hours by throttled object delay rules.

Starttime represents the time when the query entered into teradata system, whereas the collect timestamp represents DBQL collect time for that buffer.

Just for information, there is another field firststeptime, which represents when the sql started execution.


Sivaji GV

  <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: 15 Jun 2023