Archives of the TeradataForum

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

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

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>>