Archives of the TeradataForum

Message Posted: Fri, 07 Jun 2013 @ 17:42:18 GMT

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

Here is alternative query for TDWM managed systems. This was put together for TD13.0 but I believe it still works for TD14.0.

-dave.clark

     sel   UserName (FORMAT 'X(12)'),
           SessionID (FORMAT 'Z(9)999'),
           RequestNum (FORMAT 'ZZZ9',TITLE 'Rqst'),
           QueryID (FORMAT 'Z(17)9'),
           WDId (FORMAT 'ZZZ9'),
           NewWDID (TITLE 'New//WDID',FORMAT 'ZZZ9'),
           OpEnvID (TITLE 'OpEnv//ID',FORMAT 'ZZZ9'),
           SysConID (TITLE 'SysCon//ID',FORMAT 'ZZZ9'),
           CAST(ClassificationTime AS DATE) (FORMAT 'MM/DD/YYYY', TITLE 'Classify//Date'),
           CAST(ClassificationTime AS TIME(3)) (TITLE 'Classify//Time'),
           CAST(ExceptionTime AS TIME(3)) (TITLE 'Exception//Time'),
           ExceptionValue (TITLE 'EVal',FORMAT 'ZZZ9'),
           CASE RejectionCat
              WHEN 0 THEN 'W-Exc'
              WHEN 1 THEN 'Filter'
              WHEN 2 THEN 'Throttle'
              WHEN 3 THEN 'W-Class'
            END (FORMAT 'X(7)',TITLE 'Rej Cat'),
           CASE WarningOnly
              WHEN '' THEN 'N'
              ELSE 'Y'
            END (FORMAT 'X',TITLE 'Warn'),
           CASE SUBSTR(ExceptionAction,1,1)
              WHEN 'A' THEN 'Abort'
              WHEN 'C' THEN 'Chg-WD'
              WHEN 'L' THEN 'Log'
              WHEN 'E' THEN 'Ex-Pgm'
              WHEN 'T' THEN 'Alert'
              WHEN 'N' THEN 'None'
              WHEN 'Q' THEN 'Post'
            END (FORMAT 'X(6)',TITLE 'Exc//Action'),
           ExceptionCode (TITLE 'Exc//Code',FORMAT 'ZZZ9'),
           RuleID (FORMAT 'ZZZ9'),
           ErrorText (FORMAT 'X(25)')
     from dbc.tdwmexceptionlog
     where CAST(ClassificationTime AS DATE) > date - 3 order by ClassificationTime;

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