Archives of the TeradataForum

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

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

Dave,

$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.

Regards,

Thomas F. Stanek
TFS Consulting

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