Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 02 Oct 2003 @ 09:47:31 GMT


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


Subj:   Re: PSF Milestone Question
 
From:   Thomas F. Stanek

Clay,

The Milestone Type Parameter is set at the Performance Group, not at the Allocation Group. Therefore, assuming no manual intervention through the PM/API, the query will be assigned to the Allocation Group associated with the Performance Group at logon and then be handled according to the Milestone Type rules defined.

One possible exception to this case might be a situation whereby you implement a process that switches your PSF schemes, either based on some event or at regular time intervals. If, in this scenario, you were to "redefine" your Performance Group such that you change the Milestone Type from Time to Query, I'm not sure what would happen to any "in-flight" queries. I'm not recommending that, but I'm guessing that it's possible. Does anyone have any thoughts or insights into this situation? Does PSF continually re-evaluate the definition of Performance Groups and/or Allocation Groups when computing the relative weighting?

Having said that (and drifted off track), I'm not sure if that answers your question regarding PSF getting "confused" while managing multiple queries from a single session. If not, fire of a response to this and let us know.

Thomas F. Stanek
TFS Consulting, Inc.

www.tfsconsulting.com



     
  <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