Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   DBQL queries
 
From:   Okell, Alan

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016