title: Monitoring JDBC Connection Pools on WebSpere 7
body: <p>Recently we started in production with a new application hosted in several WebSphere Aplication Server and would be nice to have them monitored/graphed with more or less the same parameters we monitor/graph our Jboss servers.</p>
  
  <p>Right now I managed to monitor several points with wsadmin using jython scripts:</p>
  
  <ul>
  <li>Java HEAP</li>
  <li>Issue a "Test connection" to all datasources</li>
  </ul>
  
  <p>However I'm not able to find the way to monitor <strong>JDBC Connection Pools</strong>, to check PoolSize, WaitingThreadCount, and FreePoolSize values. I can monitor them on RealTime using <em>Tivoli Performance Viewer</em> included in the WAS DMGR:</p>
  
  <p><img src="https://i.stack.imgur.com/5mWEp.png" alt="Tivoli Performance Viewer JDBC connection pool"></p>
  
  <p>But I didn't find the way to get it through wsadmin (or any other way) so I can obtain the values and add to Cacti/RRD to obtain graphs like we already have with Jboss:</p>
  
  <p><img src="https://i.stack.imgur.com/QgfHU.png" alt="enter image description here"></p>
  
  <p>Does anyone managed to get this data from websphere with wsadmin or any other tools?</p>