Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 14 Feb 2007 @ 20:34:52 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Need to know difference between dbc.ampusage and DBCMNGR.LogSchmonSystem
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, February 14, 2007 14:48 -->

Where to start... They are fundamentally different in so many ways.

AMPUsage is a CUMULATIVE accounting table. An AMP updates the accounting totals for the corresponding VPROC/User/Account combination when it finishes processing a step. If you are using Account String Expansion (and from the wording of your question you expect that to be the case) the expansion is done only at the start of each request and not changed for each step, even if it contains time components.

LogSchmonSystem is a collection of point-in-time snapshots of Priority Scheduler data, taken by the Teradata Manager service and inserted into the database. The CPU figures in this table represent AVERAGE consumption over the immediately preceding "age period".

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020