Archives of the TeradataForum

Message Posted: Mon, 04 Oct 2010 @ 19:17:43 GMT

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

Hi,

How long between running your INSERT query and querying DBQLStepTbl ?

Rows are not written to the DBQLxxx tables immediately, they are held in a buffer and written at an interval and/or when the buffer is full. Diffferent DBQLxxx tables have different buffers an so may get written to disk at different times.

If I want to ensure that the DBQLxxx tables have the data I need then I usually issue an "END QUERY LOGGING" command first. This causes DBQLxxx buffers to be flushed.

Regards,

Dave

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

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