Archives of the TeradataForum
Message Posted: Fri, 24 Mar 2006 @ 20:36:42 GMT
| Subj: || || Re: Abort a query if it exceeds time limit |
| From: || || Ballinger, Carrie |
Unfortunately, the basic workload management options today (TDQM, TDWM) that might provide some governing capability are based on NOT starting
the query if the explain estimates suggest it will be a long-running query, rather than aborting it if it actaully exceeds a limit of time. Both
TDQM and TDWM relinquish control over the query when it begins to execute.
The capability to abort a query after a specified amount of time has passed is included in TASM (Teradata Active System Management)
functionality. By defining exception conditions on the workload definition that the query will be mapped to, you can specify that the query will
be aborted, or moved to a different priority if you wish, based on elapsed time reaching a defined threshold.