Archives of the TeradataForum

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

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

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>>