Setting dataSource/JDBC parameters with wsadmin

Setting the performance tuning parameters for all datasources in WebSphere Application Server (for IBM Connections 4) is a really annoying job with lots of mouse clicks.

I searched a way to make these through wsadmin with a jython script and after some testing i wrote one, which set all parameters for the Connections DataSources as described in IBM Connections 4 Performance Tuning Guide.

I set StatementCacheSize, minConnections and maxConnections with this script.

Download:

changeDataSourceParameters

Using this script

Copy this script to your server and copy & paste it to a wsadmin-Session, or start wsadmin with wsadmin.(sh|bat) -lang jython -username youruser -password password -f path/changeDataSourceParameter.py

I didn’t include error handling. When a DataSource is not configured, then the script will terminate!

Disclaimer

I use this script in several installations without problem, but i’m not responsible, when you break your systems or loose data!

If you find errors, you can comment or send me a mail, but i will not provide support for this script.