Today i spoke at Social Connections V User Group Meeting in Zurich. What should i say. It was a pleasure and i enjoyed it very much. Hope we can discuss more scripts the next weeks.

Session Slides

Here you can watch the session slides:

Saving my time using scripts #soccnx #soccnxv

Scripts Download

You can download all scripts without warranty and on your own risk on:

http://www.github.com/stoeps13/ibmcnxscripting

Please download the master branch, develop and bugfix can contain not ready scripts.

After skripting jdbc and j2ee on WebSphere i was interested to fasten the DB2 configuration after a Connections installation.

There are two ways to get valid source xml-Files for automatic maintenance in DB2. I use automatic maintenance, because i can set a maximum backup time and how many dumps of one database should be stored. DB2 deletes old backups (which i have in a filebackup each night) automatically.

You can’t script this settings directly, IBM provides two system calls for this: sysproc.automaint_set_policyfile and sysproc.automaint_set_policy.

I use the file variant here, because i think it easier to handle files than blob content.

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

Klaus Bild provided two scripts for setting Connections Admins through jython and wsadmin.

I want to add one detail, when you want to add multiple Admins, then you can use pipe | as delimiter.

First line would be

connwasadmin='wasadmin|conadmin'

Thanks Klaus, i like to set the admins through a script, because fixpack installations often set the j2ee roles to default.