Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Feb 2007 @ 18:34:44 GMT


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


Subj:   Need to know difference between dbc.ampusage and DBCMNGR.LogSchmonSystem
 
From:   Md, Asifuddin

Hi ,

1.Can anyone detailly explain, what is the exact use of dbc.ampusage and DBCMNGR.LogSchmonSystem.

2. And also the sum(cpu) from following selection differs.


DBCMNGR.LogSchmonSystem

     SELECT thedate,cast(TheTime/10000 As integer) TheHour,
                  PGsAffected,
                  Sum(cpu)
     FROM     DBCMNGR.LogSchmonSystem
     WHERE TheDate = (Current_Date - INTERVAL '3' DAY)
             AND     THEDATE < CURRENT_DATE
             and PGsAffected like '%H2%'
     GROUP   BY thedate,TheHour,PGsAffected
     Order   By thedate,thehour;

DBC.AMPUSAGE

     SELECT
     substr(accountname,8,6),Substr(accountname,14,2),substr(accountname,2,2)
     ,
     Sum(CPUTime)
      from
     dbc.ampusage
     where substr(accountname,2,2) like '%H%'
     Group   By 1,2,3
     Order   By 1,2;

Can anyone point out why there is a difference?


Thanks,

Asif.



     
  <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