Archives of the TeradataForum

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

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

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