Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 02 Apr 2003 @ 18:49:14 GMT


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


Subj:   Re: Pinpointing queries affecting performance
 
From:   Chris Coffing

Is there a way to populate all queries sent to the warehouse into one table???

Does PMON have a command line or API that would capture all the queries into one table?

I know there are tools, if used, will consolidate the queries sent through using the particular tool but may not capture all of the queries sent to Tdat.

The Accesslogging table may truncate large queries and the accesslog table is a hog with a bad index.... So, my question stands... Is there a way to consolidate all the queries into a single table?

Thanks for your thoughts and comments. I understand the V2R5 will have this resolved for future use so maybe I should simply wait...



     
  <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