Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 26 Nov 2001 @ 17:04:46 GMT

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

Subj:   Re: Priority Scheduler - performance groups in AccountName
From:   Thomas F. Stanek


$Radical$ will be recognized as a performance group with a name of Radical and all queries associated with the logon will behave based on that performance group's settings. If the performance group is not defined, the session will default to the $M default performance group.

You can't "mix" performance groups because a session can only be assigned to one performance group at a time. In your example, the session would be assigned to the $R default performance group. Teradata treats '$R' and '$R$' the same. In your example, the rest of the account string would be treated as text, having no meaning to the priority scheduler.

Just curious, what are you trying to accomplish by mixing default and user-defined performance groups? Perhaps there is a different way to accomplish what you are trying to do. I'm sure you know that a user ID can have multiple account strings defined (Up to 5 I think) with one serving as the default.

Hope this helps.


Thomas F. Stanek
TFS Consulting

  <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