0

When connecting to Teradata via JDBC, we can supply any of the account ids available for the user we are connecting with. e.g. if my user has Account=$SINCITY$,$H,$Mon&H$ Then this connection string: jdbc:teradata://ccbez/account=$SINCITY$

connects with the Account String = $SINCITY$ which will also appear as this in the DBQL's AcctString column and if TDWM is disabled, then this user's session will be mapped to a Performance Group (in PSA), named SINCITY.

The question is, can we make this user session to map to multiple account ids? (and therefore to multiple PGs), e.g. jdbc:teradata://ccbez/account='$SINCITY$','$Mon&H$'

(when I provided this second example, the account string being selected is $SINCITY$)

flag

1 Answer

0

You can assign multiple accounts to a user. The account which an SQL statement is submitted under is controlled by the user's profile, default account setting on the user or the the results of the SET SESSION ACCOUNT = '*account_id*' FOR SESSION/REQUEST; statement.

As you can see the SET SESSION ACCOUNT statement affords you the scope of either the current request or the entire session. This allows you to determine the performance group and resulting chargeback (if such a billing process is in place) for a specific statement or group of statements.

The account string that is being used in the SET SESSION ACCOUNT statement must be one of the accounts assigned to the user in the DBC.Accounts table.

link|flag
A single session can have no more than one account string. right? – Monis Iqbal Mar 18 at 12:23
1 
 Correct, a session can not have more than one account string active. A user can be assigned many account strings, one of which is their default account. – Rob Paller♦ Mar 18 at 14:49

Your Answer

Get an OpenID
or

Not the answer you're looking for? Browse other questions tagged or ask your own question.