Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 25 May 2005 @ 17:08:55 GMT


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


Subj:   Re: DBC.AMPUSAGE and request CPU totals
 
From:   Thomas F. Stanek

AMPUsage (DBC.ACCTG) is updated at the completion of each query step per AMP. If a query fails, the currently processing query step is not recorded in AMPUsage. In other words, if a query has 12 steps and it fails while processing step 7, only the resource consumption for the first 6 steps are recorded in AMPusage. Keep in mind that if some of the AMPs completed processing of step 7 before the query aborted, that resource consumption data would be recorded on those AMPs.

I hope that helps.


Regards,

Thomas F. Stanek
APP Consulting, Inc.



     
  <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