IBM BPM errors after applying Fix Pack 5 for DB2

After applied Fix Pack 5 to my DB2 Express-C install, my IBM BPM 7.5.0.1 Advanced started to throw errors related to Messaging  Engine (ME) not being available when I connected to the server with Process Designer. The status of the Messaging  Engine for the Process Server was "Starting".
First think I did I removed all SIB tables from all schemas (that's what I usually do if I see any ME related errors :) ), but that obviously did not help.

In SystemOut.log of the Messaging cluster I found the following error

DB2 SQL Error: SQLCODE=-443, SQLSTATE=38553, SQLERRMC=SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805, DRIVER=3.61.65

Which appeard to be caused by the following problem

https://www-304.ibm.com/support/docview.wss?uid=swg21449630


After I did the rebinding for all DB2 databases everything started to work.

Upgrading Oracle XE 10g to XE 11g

I've been using Oracle XE with several Lombardi Teamworks and WLE installs on my laptop. In order to run  latest IBM BPM 7.5+ software I need Oracle 11g, so XE 11g instead of XE 10g was a natural choice. Besides, I am a bit tired of DB2 ;)


The upgrade is very straightforward. I pretty much just followed the documentation from Oracle below
http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#autoId25

Here are my notes:

- the script gen_inst.sql creates the sql files in OracleXE bin folder, next to sqlplus command
- there were "object exists" errors during the first import which did not seem to cause any issues later

SOA vs. EAI vs. ESB

Nice writeup about SOA vs. EAI vs. ESB

http://hosteddocs.ittoolbox.com/Enterprise%20Integration%20-%20SOA%20vs%20EAI%20vs%20ESB.pdf

How to create WAS profiles with manageprofiles.sh

/opt/IBM/WebSphere/AppServer/bin/manageprofiles.sh -create -profileName Dmgr01 -profilePath /opt/IBM/WebSphere/AppServer/profiles/Dmgr01 -templatePath /opt/IBM/WebSphere/AppServer/profileTemplates/dmgr -nodeName linvm2CellManager01 -cellName linvm2Cell01 -hostName linvm2.lswsup.ukr

/opt/IBM/WebSphere/AppServer/bin/manageprofiles.sh -create -profileName AppSrv01 -profilePath /opt/IBM/WebSphere/AppServer/profiles/AppSrv01 -templatePath /opt/IBM/WebSphere/AppServer/profileTemplates/managed -nodeName linvm2Node01 -cellName linvm2Node01Cell01 -hostName linvm2.lswsup.ukr

when WAS PMT does not work

Profiles can be created with wasprofile.sh tool
More here
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.express.doc/info/exp/ae/rxml_wasprofile.html

X11 forwarding with ssh

To enable X11 forwarding with ssh when connecting as
ssh -X server

xauth program needs to be installed on the server you connect to.
In RHEL5 xauth is in xorg-x11-xauth rpm

How to delete and recreate WebSphere 6.1 profiles

WAS >6.1.0.13
To delete profiles.

/opt/IBM/WebSphere/AppServer/bin/manageprofiles.sh -unaugment -profileName Dmgr01
/opt/IBM/WebSphere/AppServer/bin/manageprofiles.sh -delete -profileName Dmgr01
/opt/IBM/WebSphere/AppServer/bin/manageprofiles.sh -unaugment -profileName AppSrv01
/opt/IBM/WebSphere/AppServer/bin/manageprofiles.sh -delete -profileName AppSrv01

delete directories;
/opt/IBM/WebSphere/AppServer/profiles/Dmgr01/
/opt/IBM/WebSphere/AppServer/profiles/AppSrv01/

Create new profile with profileManager
/opt/IBM/WebSphere/AppServer/bin/ProfileManagement/pmt.sh

On WAS versions < 6.1.0.13 use
To delete profiles with the same arguments:
/opt/IBM/WebSphere/AppServer/bin/wasprofile.sh

To create profile:

/opt/IBM/WebSphere/AppServer/bin/ProfileCreator/pctLinux.bin