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:
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.