Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 10 Mar 2008 @ 21:28:42 GMT


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


Subj:   Concurrency of TDWM Query
 
From:   White, Linda

Our query to determine account concurrency at any one time is here. I have changed usage of StartTime to be the firststeptime based on responses in this forum. The nabled TDWM query limit for the CSGBO accounts is 15 and yet the results of this query show that there are more active queries than the limit of 15.

     Select AcctString, YY, MM, DD, HHH, MINU,SECO, Count(*) As
     ConcurrentQueries
       From
     (
     Select AcctString, extract(year From firststeptime) As YY,
     extract(month From firststeptime) As MM,
     extract(day From firststeptime) As DD,
     extract(minute From firststeptime) As MINU,
     extract(second From firststeptime) as SECO,
     Cast(collecttimestamp As date) As Logdate
     , CAST((extract(hour
       From firststeptime)) *3600 + (extract(minute
       From firststeptime)) *60 + (extract(second
       From firststeptime) ) AS DEC(8,2)) As Startsecs,
     CAST(extract(hour
       From FirstRespTime)*3600 + extract(minute
       From FirstRespTime)*60 + extract(second
       From FirstRespTime) AS DEC(8,2)) As Endsecs
       From
     dba_data.ge_qry_logV a
     Group By 1,2,3,4,5,6,7,8,9
     Having endsecs-startsecs >= 0) m
     , (sel csum(1,1) As pos
     ,(pos - 1) * 60 As PIT
     ,( pit / 3600) As HHH
       From sys_calendar.CALENDAR
     Qualify csum(1,1) <= 1440
     ) x
     Where ( logdate > '2008-02-11' )
     And AcctString like '%CSGBO%'
     And startsecs <= PIT
     And Endsecs > PIT
     Group By 1, 2,3,4,5,6,7
     Order By 1,2,3,4,5,6;


     
  <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