Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 04 Jun 2012 @ 22:53:19 GMT


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


Subj:   Re: TASM Throttle
 
From:   Clark, Dave

For historic information two options come to mind. You can enable DBQL and monitor the view DBC.QryLogTDWM, where DelayTime is not null.

Alternatively, you can use the Viewpoint Rewind feature

For real-time analysis you can use Viewpoint to monitor active sessions or you can use the PMPC API:

     SELECT UserName (TITLE 'User Name', FORMAT 'X(18)'),
            HostId (TITLE 'Host',FORMAT 'ZZZ9'),
            SessionNo (TITLE 'Session'),
            RequestNo (TITLE 'Request',FORMAT 'ZZZ9'),
            RuleName (TITLE 'Rule', FORMAT 'X(18)'),
            RuleId (TITLE 'Rule//ID',FORMAT 'ZZZ9'),
            TotalTimeHeld (TITLE 'Total Time// Held',FORMAT '99:99:99'),
            OverRidable (TITLE 'Over//Ride-able', FORMAT 'X'),
            BlockingCnt (TITLE 'Blocking//Count',FORMAT 'ZZZ9'),
            PEId (TITLE 'Request//PE', FORMAT 'zzzzzzzz9'),
            WDTimeHeld (TITLE 'WD Time// Held',FORMAT '99:99:99'),
            ObjTimeHeld (TITLE 'Object Time// Held',FORMAT '99:99:99'),
            UtilTimeHeld (TITLE 'Utility Time// Held',FORMAT '99:99:99'),
            RuleType (TITLE 'Rule//Type',FORMAT 'ZZZ9')
     FROM TABLE (TDWM.TDWMGetDelayedQueries('A')) AS t1
     ORDER BY 7 DESC;

-dave.clark



     
  <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: 28 Jun 2020