IIB v9 ODBC Configuration Setup

IIB v9 ODBC Configuration Setup needs to be followed as mentioned in the v9 Knowledge Center.  Please follow the right set of configuration for each of the Database setup.

1. Setup the ODBCINI path pointing out to ODBC.ini and ODBCINST.ini.

Database information will go and reside in ODBC.ini and Trace path information will be setup in ODBCINST.ini which is used for initializing. Provide valid paths for database.

2. Use mqsisetdbparms command to setup the database parameter

3. Use mqsicvp command to check for Database connection

https://www.ibm.com/support/knowledgecenter/SSMKHH_9.0.0/com.ibm.etools.mft.doc/bk58070_.htm

NOTE: SQL Server driver UKsqls26.so was introduced with IBM Integration Bus V9.0.0.3. If you are at an earlier version than V9.0.0.3, SQL Server driver UKmsss26.so should be used.

Above Note is an important point while configuring on IBM Integration Bus v9.0.0.3 as it may lead to errors while connecting to the Database.