Archives of the TeradataForum
Message Posted: Thu, 05 Feb 2009 @ 21:10:15 GMT
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.
Yasir H Maken
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|