How to log Websphere connection pool information like active connections in spring boot application

Question

We are using Websphere liberty 20.0.0.12 and spring boot (parent) version 2.0.5.

I can find the connection pool information in the JConsole.

How can I print Websphere connection pool information in application logs?

(Read comments of approved answer if using liberty server instead of traditional websphere application server)

Answer 1

IBM support doc at https://www.ibm.com/support/pages/how-enable-connection-pool-trace-websphere-application-server describes how to enable printing of various connection pool stats in the trace log for traditional WAS, for Liberty, you'll use the same trace specification WAS.j2c=all:RRA=all(you don't need Transaction) and put a logging element in your server config file (typically server.xml). See Liberty doc at https://openliberty.io/docs/latest/log-trace-configuration.html for more info.