Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 24 Nov 2011 @ 23:45:41 GMT

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

Subj:   Re: QRYLOG issue
From:   Schmid, Steven


The END and then BEGIN query log statement will flush the DBQL buffer writing the data to the DBC DBQL tables. Therefore you don't need to wait the predefined time (usually 10 minutes by default) or until the buffers are full before data is written to the DBC tables. You may still need a delay, as the data load would not be instantaneous, best to run some manual tests outside of the macro to see how long it takes to get to DBC tables.


Steven Schmid
Teradata Australia
Canberra Office

  <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