Archives of the TeradataForum

Message Posted: Thu, 04 May 2006 @ 20:18:16 GMT

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

Hi,

The below code can be used to get the TDQM queue information.

     sel   trim(dt) (title 'Date')
     , trim(hr) (title 'Hour')
     ,name (title 'UserName')
     , count(*) (title 'TDQM//Delayed')
     , avg(delay) (title 'Average//Delay')
     , max(delay) (title 'Maximum//Delay')
     , min(delay) (title 'Minimum//Delay')
       from
             (sel trim(extract(month from starttime))||'/'||trim(extract(day from starttime))
             , trim(extract(hour from starttime)) (smallint)
             ,userid
             , firststeptime - starttime hour to second(2)
             from dbc.dbqlogtbl where  tdqmflag='t' ) dt ( dt, hr, uid, delay)
     where uid = dbc.ownerdb.id
     group by 1, 2 ,3
     order by 1 desc;

Thanks,

Sudheer.

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