Archives of the TeradataForum

Message Posted: Thu, 30 Mar 2006 @ 19:14:07 GMT

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

Following our recent implementation of DBQL (V2R5.1), I have a couple of queries that I'm hoping somebody may be able to answer. We are currently logging all queries with objects. I'll start with the basics:

1. Best columns to join on - I am currently joining on ProcId, QueryId and CollectTimeStamp (+ or - 12 hours). I had read something somewhere about 'long' Query Id - is this of use and if so, how do I switch it on?

2. I seem to be experiencing missing data in terms of certain statements appearing on QueryLog not appearing on QryLogObjects. I'm sure there are others but 'Exec Mload DatabaseName.Tablename' is on QryLog but 'DatabaseName.Tablename' does not appear on QryLogObjects. Is this just a 'feature' ?

3. A number of columns are unpopulated that would be useful, particularly NumResultRows, ResultRowSize and SpoolUsage to name but 3. Is this a future version ?

Regards,

Alan Okell

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