Archives of the TeradataForum

Message Posted: Tue, 28 Sep 2005 @ 00:21:58 GMT

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

<-- Anonymously Posted: Tuesday, September 27, 2005 20:18 -->

Hello,

We are in the process of implementing Priority Scheduler settings for our box. We have a requirement to switch performance groups from one Allocation group to another during the day. Did anyone use Time-Of-day milestone to achieve this and is it safe? If Not, Will switching Allocation group for a Performance group via cron multiple times a day is safe and good enough. Is this approach correct, eg: In schmon -p Allocation group and 'V'(priority of group) changes with milestone type as R something like this, 43 and 42 are allocation group numbers, something like this

     cron job at 6:00PM
     schmon -p 12 H1H  1 6 R 0 43
     schmon -p 13 H1H$ 1 7 R 0 43
     schmon -p 14 R1R  1 4 R 0 42
     schmon -p 15 R1R$ 1 5 R 0 42

     cron job at 12:00AM
     schmon -p 12 H1H  1 4 R 0 42
     schmon -p 13 H1H$ 1 5 R 0 42
     schmon -p 14 R1R  1 6 R 0 43
     schmon -p 15 R1R$ 1 7 R 0 43

If not, is there any other option.

Thanks.

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