How to identify TIBCO Data Virtualization users opening a lot of  sessions, resulting in messages that the connection limit has been exceeded?

How to identify TIBCO Data Virtualization users opening a lot of sessions, resulting in messages that the connection limit has been exceeded?

By default, TDV is configured to allow 100 sessions. If the number of client sessions exceeds this number, any new client that attempts to open a connection will receive an error of the type:

-----------------
The connection limit of 100 has been exceeded
-----------------

The error may be resolved by opening TDV Studio and increasing the value of Administration>>Configuration>>Server>>Client Drivers>>Session>>Maximum Session to a value higher than 100.

        
 
It may also be prudent to find out which users are opening a lot of sessions. To obtain this information, the following query may be run in TIBCO Data Virtualization Studio Scratchpad:

-----------------
SELECT * from /services/databases/system/SYS_SESSIONS
where STATUS != 'CLOSED' order by OWNER
-----------------

This output of the query will:

•  list the users who have opened sessions
•  provide detailed information on on each session

As an example, the screenshot below shows that a user named yogesh_gupta has 3 open JDBC sessions.
  
       
    
The LOGIN_TIME field shows the time at which each session was started.