Archives of the TeradataForum
Message Posted: Mon, 26 Nov 2001 @ 17:04:46 GMT
$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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|