Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 22 Nov 2005 @ 18:16:18 GMT


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


Subj:   Re: Excessive Delays between DBQLogTbl's StartTime and FirstStepTime
 
From:   Ballinger, Carrie

Can I expand this point from my previous email slightly?

  In your case, after the upgrade, the DBQL cache was initialized at system startup, so the collectstamps for all entries in that first cache will be the time the system became active, not the time the user queries were actually executed.  


To be more accurate, DBQL caches are actually initialized at NODE startup, not system startup. I am assuming that is why, Mark, you had light differences in collecttimestamps in your sample, 1 second or so apart.


Thanks, -Carrie



     
  <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