I wanted to know if there is a way to limit the Number of sessions logged on for one connection in Teradata studio.
Since I have noticed that if a userA logs in using teradata studio, i can see 3/4 sessions taken up by that user, even if there is only one query window opened by that user.
HP, In out latest release of Teradata Studio the minimum number of connections is 2. There is a connection used for the Data Source Explorer gathering of database object metadata and there is a connection for each SQL Editor execution. You can set the maximum number in the Connection Options preference page. The default maximum is 8.