How to identify TIBCO Data Virtualization overloaded requests because when heavy load requests occur, the users are unable to log in to TIBCO Data Virtualization Studio to view the request list.

This article will walk through the users on the list of requests without logging in to the TIBCO Data Virtualization Studio or Web Manager.

All Supported Environments

The user can make use of SYS_REQUEST table which is one of the system tables in TIBCO Data Virtualization for querying the request list. This table provides a list of current and recent requests and their current status.

There is also a jdbc service utility for querying this table. Please refer below steps : 

 1. Open command prompt and navigate to <TDV_HOME_DIR>\TDV Server 8.5\apps\jdbc using following command: 
    cd <TDV_HOME_DIR>\TDV Server 8.5\apps\jdbc.

 2. Use the following query format :

    jdbcSample.bat <Data Service Name> localhost <base port + 1> <username> <password> <Domain Name> "select * from<Catalog_Name>.<Schema_Name>.<ViewName>

e.g  jdbcSample.bat system localhost 9401 admin admin123 composite "select * from SYS_REQUESTS"