Friday, May 29, 2015

Establish Informix connection in Message Broker

In order to allow WebSphere Message Broker (WMB) establish connection to Informix database, first I must have data source configure in Windows. The configuration was done through ODBC. The very first step is to have Informix driver install in Windows, otherwise there is no room for WMB connect to Informix. Following are the summary steps for the setup:
  1. Install Informix driver.
  2. Go to Control Panel > Administrative Tools > Data Sources (ODBC) > Drivers tab > Verify driver is there.
  3. In system DSN tab > Add new data source.
  4. Setup necessary details and choose 'olsoctcp' protocal.
Once done, the data source has to be register into WMB. Open up WMB command prompt and fire following command:

mqsisetdbparms Broker_Name -n Data_Source_Name -u username -p password

mqsicvp Broker_name -n Data_Source_Name

The last command is to verify the data source is successfully registered into message broker. And for each command entered, BIP8071I: Successful command completion. should be seen. Do take note also if the Windows command prompt is used instead of WMB command prompt, issue C:\IBM\MQSI\\bin\mqsiprofile.cmd before any mqsi_xxx command can be used.

No comments: