Today i read a question in the IBM Connections Forum about setting the EMPLOYEE_EXTENDED role to all users in a Connections deployment. It would be easy to set it directly in the database, but that’s not supported by IBM. I wrote a little script some weeks ago, because i had the same request, but never published it. The good thing here it only uses supported commands. So i use this question to add it as a new script to my GitHub Repository. Here you see the source, it is simple a join of the tables emp_role_map and employee:

Read more

Missing command history on Linux is a little problem when using command line utilities like wsadmin, db2, sqlplus and so on. I found a solution for this today. You can use rlwrap to get command history for all applications on the console and it is possible to recall and edit the commands. Rlwrap uses readline. Installation on CentOS: yum install readline-static gcc make tar -xvzf rlwrap-0.41.tar.gz cd rlwrap-0.41 ./configure make make install Call rlwrap with wsadmin: rlwrap -r /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/bin/wsadmin.sh -lang jython -username wasadmin -password password rlwrap and db2 rlwrap -r db2 Use rlwrap everytime with alias vim ~/.

Read more

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

Read more

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.

Read more

Looks very interesting! Hope i get new stuff for configuring Lotus Traveler HA and IBM Connections.  High Availability and Disaster Recovery Options for DB2 Linux, UNIX, and Windows

Read more