DataSource Monitoring 

Use

This function enables you to obtain information about the connections created by a particular DataSource.

Features

This function is available in both the Visual Administrator and the Console Administrator.

In the Visual Administrator you can obtain a dynamic view of the number of free and used connections. It is reported to the tool and updated on the screen on a regular basis.

In the Console Administrator you can obtain static information about the number of free and used connections. In addition, the tool provides you information about the IDs of the connections and the connection handles associated to them.

Activities

To monitor the free and used connections in the Visual Administrator, go to the Runtime tab of the JDBC Connector Service, select a DataSource from the Resources → DataSources → <applicationName> tree, and then go to the Monitoring tab. The number of free connections is represented by a green line, and the number of used connections is represented by a red line.

To display information about the connections in the Console Administrator, use the following commands:

·        get_free_conn

·        get_used_conn

·        list_conn

For more information about these commands, see DBPOOL.