the TDWM is set up so that it generates an alert if a query runs for longer than 10 minutes. When I looked at the Qry log it shows me that the elapsed time is only 4 minutes.
It seems that TDWM will send an alert when the “sum over all nodes” exceeds 5000 seconds and the query respnse time is greater than 10 minutes. Then why does the Qry log show the elapsed time as only 4 minutes? What tables should I look at to ensure that the query really ran for more than 10 minutes?
Please provide some additional details: How exactly is your exception defined? Is it based on CPU time, Elapsed time or both? What release of Teradata are you running? Is this query subject to throttle delays?