Scripting

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.
Last Update: Read in about 2 min

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:
Last Update: Read in about 1 min

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.
Last Update: Read in about 2 min

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.
Last Update: Read in about 2 min

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/
Last Update: Read in about 1 min

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)
Last Update: Read in about 3 min

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.
Last Update: Read in about 2 min

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
Last Update: Read in about 1 min

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.
Last Update: Read in about 3 min

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
Last Update: Read in about 1 min

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.
Last Update: Read in about 1 min