IBM WebSphere Liberty JMX/PMI JDBC Connection Pool Size

[Babar_Qayyum]

Dear All,

I wanted to have the information about JDBC Connection Pool Size and Hung Threads using the JMX/PMI custom metrics.

I found that there are limited options for the IBM WebSphere Liberty comparatively IBM WebSphere.

Is there any other way to grasp this information and use it for custom anomaly detection?

Regards,

Babar

[ChadTurner]

@Babar_Qayyum did you get any insight into this?

[Babar_Qayyum]

Hello @ChadTurner 

Unfortuatially, not yet. I realized that Dynatrace is not providing much metrics information like the traditional WebSphere. To overcome this limitation, we plan to use Oracle DB Insight to monitor the health/metrics of independent databases.

I read somewhere in the documentation that there will be an enhancement for the liberty processes extraction out of the box as currently, we use the advanced processes properties to extract the processes. I hope they will consider providing additional metrics.

Regards,

Babar

[harald_berger · Accepted solution]

Hi,

Please note that for Websphere Liberty there is out-of-the-box support for built-in connection pools. But the monitoring feature in Liberty has to be turned on manually as documented.

https://www.dynatrace.com/news/blog/simplify-troubleshooting-with-ai-powered-insights-into-connectio...

Details on the IBM site

https://www.ibm.com/docs/en/was-liberty/nd?topic=10-connectionpool-monitoring

Then all connection pool metrics will appear automatically.

Also other metrics like the thread pools or servlet stats will appear then.

Best

Harry

[gopher]

Hi,

For WebSphere Liberty,  It can be fiddly depending on the technology that is implemented for your app. 

For Database calls, I have found that quite commonly in Liberty, people tend to use Hikari drivers rather than standard Oracle / JDBC ones.  In the instance of Hikari, it won't write to JMX unless you enable it within the framework (this is similar to some other popular DB driver frameworks)

You should be able to see what is available via the  standard JMX plugin builder and see if it has what you need. 

Here's a list of the defaults

Reference guide: List of provided MBeans - IBM Documentation

In our instances, we needed to get the devs / build team to enable Hikari -> jmx  config across the liberty apps, and then write a seperate HikariCP jmx plugin.  Between the Liberty jmx plugin and  the Hikari plugin, we got what we needed. 

Best to start by having a chat to the Devs about what frameworks they are using, so you can check if it has JMX outputs.  

Have Fun.

[mdouds]

It was already mentioned in one of the links that harald_bergers provided already, but make sure you have enabled the monitor-1.0 feature in your Liberty applications. This will expose the ConnectionPool Mbean as seen here: https://www.ibm.com/docs/en/was-liberty/core?topic=10-connectionpool-monitoring