Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Automating priority for bad queries
 
From:   Maken, Yasir Hassan

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016