I haven’t touched the Connections scripts for a long time, but I recently made some minor updates to fix compatibility issues with newer versions and added small scripts to speed up configuration. I also got the documentation script running from the menu.

As preparation for Social Connections VI in Prague next week i redesigned the Administration Scripts for IBM Websphere .

Some highlights:

• all scripts are moved to a subfolder with DMGR/bin (folder name: ibmcnx)

• tested in multinode environments

• added some classes everybody can use for his own scripts

• adding policies to libraries (personal and communities) are using search now

New scripts:

• documentation of all jvm settings of each application server

• create a file with all documentation in one step

• create cluster members for additional nodes

Sharon created a document with the content of all of our presentations and collected several tipps all around connections and community scripts. She will share this next time. We started to share parts of this document and more documentations (installation, usage) for scripts and IBM Connections on:

This week i attended Engage in Breda . I had a session with famous Sharon Bellamy , we covered an update of our Connect 2014 session about BP307 – Practical Solutions for Connections Administrators – Tips and Scripts for Your Daily Busines .

I enjoyed it very much to be with lovely community guys, old and new friends. I want to thank Theo Heselman , he and his crew did and does a really great job to get us all together (350 attendees, 30 IBM Champions, 65 speakers).

Kitty and Warren Elsmore were with us again and made lovely copies of ourself in lego. Thanks to you too.

It was little bit quiet here after Connect 2014. I had lots of projects and no time to add new scripts or even do bug fixing.

I promised at Connect, that i will fix the JDBC drivers, that they will load on Windows too. See cnxMemberCheckExIDByEmail.py as an example.

Loading JDBC Drivers within jython scripts

Jan Riedel sent me a solution for SLES and i tested his proposal today within Windows. He points me in the right direction, i mustn’t load the path or jar within the script, it is better to load on starting wsadmin. You have to add the JDBC Driver path to WAS_EXT_DIRS.

I added several plugins to my Eclipse, so i can access the scripts on GitHub and edit through an IDE:

Jython and Python Development

PyDev: http://pydev.org/updates

Markdown (Documentation within Github)

Markdown: http://winterwell.com/software/updatesite/

Access GitHub:

EGIT: http://download.eclipse.org/egit/updates

Shellscript Editor

EasyShell: http://pluginbox.sourceforge.net

ShellEd: http://sourceforge.net/projects/shelled/files/shelled/update/

SQL Scripts

SQL Explorer: http://eclipsesql.sourceforge.net/

The IBM Connections Product Documentation is only available as a set of Wiki Documents and in a accessible version (5 single html documents) .

I don’t like both versions. Searching is hard and printing only single documents (to paper or pdf) is a torture. The format is only for a complete display, no mobile version and using only half of a display do not wrap the text.

So i want to have a converted document which is searchable, has numbered headlines and can be converted to mobi or kindle format.

You want this too? How?

Requirements

• Linux VM (e.g. Knoppix or other Live Linux)

Because of a delay of some hours on my flight back from Social Connections V on saturday, i had time to rewrite the jython script for backing up and restore security roles in WebSphere Application Server.

I updated the master branch on GitHub , which now contains a db2 initscript and the two new scripts securityrolebackup.py and securityrolerestore.py !

You can call the scripts through wsadmin.sh|bat and they do following.

securityrolebackup.sh

cd $WAS_HOME/profiles/Dmgr01/bin
./wsadmin.sh -lang jython -username admin -password password -f "path/securityrolebackup.sh" "../temp"

This will save the security roles for each installed application to $WAS_HOME/profiles/Dmgr01/temp to single files named: Application.txt.

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.

Slidedownload soccnx

More Slides on http://www.slideshare.net/soccnx

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

Using this script

Copy this script to your server and copy & paste it to a wsadmin-Session, or start wsadmin with

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.