Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 09 May 2003 @ 15:27:31 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Account string
From:   Ballinger, Carrie

As suggested by both Phil and Raghav, you can use priority scheduler to automatically change the priority of a group of users based on time of day, without any changes to the account string.

Here's briefly how it works: Within the performance group definition for LTEST you could define two performance periods of the 'T' (time) type. Once you define the milestone type of 'T', each performance period has two parameters: a time of day and an allocation group ID. The time of day is an upper limit--until that time is reached the specified allocation group and its characteristics (such as assigned weight) will be in effect for that performance group. Once the time of day threshold for the first performance period is reached, the second performance period takes control, and the allocation group it is associated with will determine the priority of all users in the performance group. Then when the second performance period milestone time is reached the first period again takes control. It continues to wrap around, and if you wanted more than two different priorities, up to 5 changes in time supportable today.

One of the limitations of this approach is that it does not support day of week differentiations.

Looking head, in V2R5.1, the T milestone type will support day of week in addition to time of day, and you will be allowed to have up to 8 different performance periods per performance group.

Thanks, --Carrie

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020