Archives of the TeradataForum

Message Posted: Fri, 24 Mar 2006 @ 20:36:42 GMT

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

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.

Thanks, -Carrie

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