Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 17 Nov 2005 @ 14:23:28 GMT


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


Subj:   Re: Excessive Delays between DBQLogTbl's StartTime and FirstStepTime
 
From:   Geoffrey Rommel

     > CollectTimeStamp  LogonDateTime      StartTime          FirstStepTime      FirstRespTime
     > 11/13/05 7:09 AM  11/13/05 12:32 PM  11/13/05 12:32 PM  11/13/05 12:32 PM  11/13/05 12:32 PM

I'm sure Carrie will have something more interesting to say, but the rows for DBQL are sometimes inserted by different AMPs. The AMPs take their timestamps from the clocks on the TPA nodes. If these are not in sync, you will see weird results like this. Your administrator should make sure that the clocks on all nodes are synchronized, probably by running NTP.



     
  <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