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

Ram

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.

cheers

Steven Schmid
Teradata Australia
Canberra Office