Archives of the TeradataForum

Message Posted: Thu, 05 Feb 2009 @ 21:10:15 GMT

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

Anom,

You will be able to do it once you enable TASM on your system. You can classify your queries into various workloads while before they start execution. What you can do is to create high and low priority workloads. If a query which has been classified into a workload of high priority starts consuming X Spool or CPU etc, it can be automatically demoted to run in low priority workload. What you need to do is to set EXCEPTION CRITERA on the basis of SPOOL or CPUTIME or CPUmsperIO etc and then set the EXCEPTION ACTION as "Change WORKLOAD" to make remaining query run in a low priority workload.

Regards,

Yasir H Maken

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