Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 06 Oct 2009 @ 20:19:58 GMT


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


Subj:   Re: TDMW filter/throttle question
 
From:   Ballinger, Carrie

It sounds like you would like a hybrid between a filter and a throttle. Unfortunately, throttles apply their limits on the objects under their control without consideration of query characteristics (except for the step time threshold, which considers estimated time). And filters which do consider query characteristics such as type of join never delay, only reject.

The only thing I can think of that would be sort of close to what you want to do (assuming you are using TASM) is to use a queryband (T12)set with the same specific value for all product join queries. Then you would need to set up classification so that all queries whose queryband carries that value will classify to a single workload by themselves. Then define a workload throttle on that workload, with a query limit of 3.

This would require some logic before query submission that could intelligently set the query band value.


Thanks, -Carrie



     
  <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: 15 Jun 2023