Diagnosing - Data Sources

The “Data Sources” tab displays the “Data Sources Summary” table, which contains statistical information about the data sources defined in the Virtual DataPort server. The statistics about the pool of connections are only available for JDBC and ODBC data sources.

Data Sources tab of a diagnostic or diagnostic interval

Data Sources tab of a diagnostic or diagnostic interval

The fields that are available in the “Data Sources Summary” table are:

  • VDP Database: Name of the Virtual DataPort database that the data source belongs to.
  • Type: Type of the data source.
  • Name: Name of the data source.
  • Max Active Requests: Maximum number of simultaneous requests to the data source.
  • Min Active Requests: Minimum number of simultaneous requests to the data source.
  • Avg Active Requests: Average number of concurrent requests to the data source.
  • Max Total Requests: Maximum number of requests to the data source processed since the launch of the Virtual DataPort server.
  • Min Total Requests: Minimum number of requests to the data source processed since the launch of the Virtual DataPort server.
  • Avg Total Requests: Average number of requests to the data source processed since the launch of the Virtual DataPort server.
  • Max Active Connections: Maximum number of active connections in the pool (only for JDBC and ODBC data sources). An empty value means there is no pool.
  • Min Active Connections: Minimum number of active connections in the pool (only for JDBC and ODBC data sources). An empty value means there is no pool.
  • Avg Active Connections: Average number of active connections in the pool (only for JDBC and ODBC data sources). An empty value means there is no pool.
  • Max Idle Connections: Maximum number of inactive connections in the pool (only for JDBC and ODBC data sources). An empty value means there is no pool.
  • Min Idle Connections: Minimum number of inactive connections in the pool (only for JDBC and ODBC data sources). An empty value means there is no pool.
  • Avg Idle Connections: Average number of inactive connections in the pool (only for JDBC and ODBC data sources). An empty value means there is no pool.
  • Max Pool Size: Maximum size of the connections pool (only for JDBC and ODBC data sources). An empty value means there is no pool.
  • Min Pool Size: Minimum size of the connections pool (only for JDBC and ODBC data sources). An empty value means there is no pool.
  • Avg Pool Size: Average size of the connections pool (only for JDBC and ODBC data sources). An empty value means there is no pool.
  • Max Pool Load: Maximum ratio of active connections to the pool size (only for JDBC and ODBC data sources). An empty value means there is no pool.
  • Min Pool Load: Minimum ratio of active connections to the pool size (only for JDBC and ODBC data sources). An empty value means there is no pool.
  • Avg Pool Load: Average ratio of active connections to the pool size (only for JDBC and ODBC data sources). An empty value means there is no pool.

You can right-click on a data source and click image1 Data Source Graph to open a new tab with a couple of graphs that present the historical evolution of the collected data for that data source.

Data Source tab with the evolution of its data presented as graphs

Data Source tab with the evolution of its data presented as graphs

Furthermore, you can obtain the state of the data sources at a specific date. You can get this in two different ways:

  1. In the “Data Sources Summary” table, click the icon image2 located at the header. A dialog will appear asking for the date. Enter a date and click View Data Sources.

    Dialog to obtain the data sources at a specific date

    Dialog to obtain the data sources at a specific date

  1. In any of the graphs that show the historical evolution for a particular data source, you can select a date by clicking on the graph. Then, click on the icon image2 located at the header of the graph.

As a result, a new tab will appear with the state of all the data sources at the selected date.

Data Sources tab with the state of the data sources at a specific date

Data Sources tab with the state of the data sources at a specific date

You can find a detailed explanation of the measures in the graphs and the fields in the table on the section Monitoring - Data Sources.