Archives of the TeradataForum

Message Posted: Wed, 08 Nov 2000 @ 19:23:25 GMT

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

Claudia,

I am working with a major retailer and we have implemented the exact type of workload management strategy that you are looking. Priority Scheduler will definitely be able to do what it is you want. The schmon utility allows you to change the configuration of the Priority Scheduler dynamically. The Priority Scheduler has a milestone limit feature that allows you to automatically change an allocation group based on the time of day, but we found this somewhat limiting in that it did not recognize weekends, holidays, month-end requirements, etc. Instead, we set up scheduled UNIX scripts that execute based off a schedule. In fact, one of our systems is configured so that it changes the Priority Scheduler scheme based on triggered events such as nightly batch completing. This has taken a small amount of programming but the results have been excellent.

Regarding switching the definition of an allocation group while a query is running, this is not a problem at all. If you use PMON, you already have the ability to change a priority for a query. In affect, changing the Priority Scheduler Scheme while a query is running has the same affect.

I would strongly suggest that you do a lot of testing before implementing into a production environment. There are a lot of intricacies to setting up the Resource Partitions, Performance Groups, Allocation Groups, etc. Unfortunately, the documentation in the manuals doesn't give you much guidance.

Tom Stanek
TFS Consulting

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