IBM Sametime 9 Gateway cannot create DB2 connection for adding communities


After installing an IBM Sametime 9 Gateway I wanted to configure communities to link them. During the try to add the first ( the internal ) community, I always received the following error:

Problem by accessing the data source

So there was a problem for the gateway to establish a connection to the DB2 database. Although the test of the “GatewayDS” returned to be successful.

After opening a PMR ( 31608,999,618 ) I received the information that JMS has to be set for the STGW 9.

This can be done by running the following scripts:


Setting up JMS in Sametime Gateway
The Java™ Messaging Service (JMS) replaces the IBM® WebSphere® dynamic cache event notification mechanism, which was used in previous versions of WebSphere. Perform these steps after you have installed and registered the Sametime® Gateway Server or Sametime Gateway clusters.
About this task
If you are using a single server, set up JMS on the WebSphere Server on which the Sametime Gateway Server runs. If you are using a clustered environment, set up JMS on the deployment manager. You begin by creating the service integration bus, which is the virtual place where messages are exchanged. Use these steps to run the script to set JMS provider properties:
Procedure
    Restart the server or cluster.
    For a single server deployment, restart the server.
    For a clustered deployment, restart the Sametime Gateway cluster environment rather than each Gateway Server.
    On the Gateway Server, navigate to the /bin directory.
    For a single server deployment, the directory is /profiles/RTCGW_Profile/bin.
    For a clustered deployment, the directory is /profiles/DM_Profile/bin.
    Copy the gw_config_jms.py and gw_jms_tuning.properties files from the Sametime Gateway Server installation image in the postInstall directory to the /bin directory.
    Run the wsadmin script.
    AIX® and Linux
    ./wsadmin.sh -username user -password password d -lang jython -f gw_config_jms.py gw_jms_tuning.properties
    Windows
    wsadmin.bat -username user -password password d -lang jython -f gw_config_jms.py gw_jms_tuning.properties
    Restart the server or cluster.
    For a single server deployment, restart the server.
    For a clustered deployment, restart the Sametime Gateway cluster environment rather than each Gateway Server.

The 2 mentioned files can be downloaded here:
gw_config.jms.py
gw_jms_tuning.properties

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s