Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 05 Mar 2008 @ 11:20:41 GMT


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


Subj:   Re: DBQL - Query Id in Objects table but not in QueryLog
 
From:   DWellman

Hi,

Is this possibly a timing issue. Each DBQL table is populated from different memory areas (buffers). Those buffers are written to disk at different times.

Is it possible that the Objects data was written and queried before the main QryLog table ?

If you restart the TD system (not always possible !) or wait 'long enough' then you may find the the Queryid now appears.

I couldn't find the original post to know how long after the real query you were querying the DBQl tables.


Cheers,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )



     
  <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