Archives of the TeradataForum

Message Posted: Fri, 11 Nov 2005 @ 12:01:15 GMT

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

Terry,

We are on V2R5.1.2.13. We log by account string and, seemingly, haven't stumbled across any cases where SQL is being lost.

Just as a shot in the dark:

Can we see an example of the query you are using to join DBQLogTbl to DBQLSqlTbl? Perhaps the SQL is being lost in the join (via extreme variations between the collect time stamps.) Or, are you simply pulling the QueryID and ProcID from the LogTbl and querying the SQLTbl directly with just those 2 pieces of information?

Thanks,

Clay

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