Archives of the TeradataForum

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

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

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>>