Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 09 Apr 2013 @ 08:48:59 GMT


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


Subj:   Ampusage and dbqlogtbl
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, April 08, 2013 23:47 -->

Hi all,

I did some app development on Vr25 and then moved away. Now, I'm again starting on TD13.0. I remember that we calculated higa ratio on dbc.ampusage to check whether the query was okay or needed retuning.

Our DBA doesn't want to refresh dbc.ampusage and asks us to use dbc.Dbqlogtbl;

Is there a 'norm' like the higa ration -that you folks use to check whether a query is okay using dbqlogtbl? Is it okay to use the same ratio here too? Please let me know. I cant seem to get any good documentation on dbqlogtbl. Will be grateful for any pointers



     
  <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: 15 Jun 2023