In the UNIX environment, there is no ODBC Administrator or Driver Manager. To configure an ODBC data source name (DSN) definition, you must edit the required system information, which is held in a plain text file called .odbc.ini (note that the name of this file starts with a period).
Set the ODBCINI environment variable to point to the file, specifying a full path and file name. If you do not set this variable, the path defaults to $MQSI_REGISTRY/odbc/.odbc.ini for a 32-bit execution group, which is created when WebSphere Event Broker is installed. The file must have file permissions of mqm:mqbrkrs.
A sample template is provided as the file <install_dir>/merant/odbc.ini which contains examples of how to configure a DSN residing in each of the databases supported by WebSphere Event Broker The sample template files for the supported platforms are displayed below. They show the recommended configuration for the supported databases.
The entries in the stanzas that you must configure to match your local requirements are shown in italics (descriptions of these entries are provided in ODBC.ini Parameters). You must retain all the entries shown, but you can remove a complete stanza if you do not require it for your configuration (for example, if you are using an Oracle database, you can remove the stanzas shown for DB2 and Sybase).
Make a copy of the default file, set ODBCINI to point to this copy, and make any changes to the copied file rather than to the default.
Ensure that the appropriate library search path environment variable (LD_LIBRARY_PATH on Solaris and Linux (x86 platform)) is set to reflect the database products to be used. Refer to your database product documentation for more details.
If
you are using Linux (zSeries
platform) or Linux (POWER platform),
you do not need to define an ODBC connection. Instead, the data source name
used in the message flow is the same as the DB2 alias of the database.
If you are using a 64-bit DB2 instance, ensure that
you add <DB2 instance directory>/sqllib/lib32 to the start
of the library search path environment variable. If you are using a 64-bit
Oracle instance, ensure that you add $ORACLE_HOME/lib32 to
the start of the library search path environment variable. If you are using
64-bit execution groups, ensure that you set the environment variable MQSI_LIBPATH64 to
include the regular 64-bit database libraries.
If you are using WebSphere MQ Version
6, refer to the section 'Implications of a 64-bit queue manager' in the WebSphere MQ Quick Beginnings book for your
operating environment.
On AIX, if you are using DB2 as your database, a maximum of 10 connections using shared memory are allowed from a single process. This means that if you deploy more than one or two message flows at the same time, you might see connection failures characterized by the DB2 error message SQL1224N. The connection errors are reported in the system log from the broker's execution group. To avoid this problem, you can use TCP/IP mode to connect to DB2. For detailed instructions on how to do this, see DB2 error message SQL1224N is issued when you connect to DB2.
Here is the sample ODBC.ini information:
[ODBC Data Sources] WBRKBKDB=IBM DB2 ODBC Driver MYDB=IBM DB2 ODBC Driver ORACLEDB=DataDirect 5.0 Oracle SYBASEDB=DataDirect 5.0 Sybase Wire ProtocolSQLSERVERDB
=DataDirect 5.0 SQL Server Wire Protocol
INFORMIXDB
=IBM Informix ODBC Driver
[WBRKBKDB] Driver=/u/db2inst1/sqllib/lib/libdb2.a Description=WBRKBKDB DB2 ODBC Database Database=WBRKBKDB
[MYDB] Driver=/u/db2inst1/sqllib/lib/libdb2.a Description=MYDB DB2 ODBC Database Database=MYDB
[ORACLEDB] Driver=<Your installation directory>/merant/lib/UKor820.so Description=DataDirect 5.0 Oracle ServerName=<YourServerName> EnableDescribeParam=1 OptimizePrepare=1 ProcedureRetResults=1 WorkArounds=536870912
[SYBASEDB] Driver=<Your installation directory>/merant/lib/UKase20.so Description=DataDirect 5.0 Sybase Wire Protocol Database=<Your Database Name> ServerName=<YourServerName> EnableDescribeParam=1 OptimizePrepare=1 SelectMethod=0 NetworkAddress=<YourServerName,YourPortNumber> SelectUserName=1
[SQLSERVERDB]
Driver=<Your installation directory>/merant/lib/UKmsss20.so
Description=DataDirect 5.0 SQL Server Wire Protocol
Address=<Your SQLServer host>,<your SQLServer post>
AnsiNPW=Yes
Database=<Your Database Name>
QuoteId=No
[INFORMIXDB]
Driver=<Your Informix Client directory>/lib/cli/iclit09b.so
Description=IBM Informix ODBC Driver
ServerName=<Your server name>
Database=<Your Datasource>
[ODBC] Trace=0 TraceFile=<A directory with plenty of free space>/odbctrace.out TraceDll=<Your installation directory>/merant/lib/odbctrac.so InstallDir=<Your installation directory>/merant UseCursorLib=0 IANAAppCodePage=4 UNICODE=UTF-8
[ODBC Data Sources] WBRKBKDB=IBM DB2 ODBC Driver MYDB=IBM DB2 ODBC Driver ORACLEDB=DataDirect 5.0 Oracle SYBASEDB=DataDirect 5.0 Sybase Wire ProtocolSQLSERVERDB
=DataDirect 5.0 SQL Server Wire Protocol
INFORMIXDB
=IBM Informix ODBC Driver
[WBRKBKDB] Driver=/u/db2inst1/sqllib/lib/libdb2.sl Description=WBRKBKDB DB2 ODBC Database Database=WBRKBKDB
[MYDB] Driver=/u/db2inst1/sqllib/lib/libdb2.sl Description=MYDB DB2 ODBC Database Database=MYDB
[ORACLEDB] Driver=<Your installation directory>/merant/lib/UKor820.sl Description=DataDirect 5.0 Oracle ServerName=<YourServerName> EnableDescribeParam=1 OptimizePrepare=1 ProcedureRetResults=1 WorkArounds=536870912
[SYBASEDB] Driver=<Your installation directory>/merant/lib/UKase20.sl Description=DataDirect 5.0 Sybase Wire Protocol Database=<Your Database Name> ServerName=<YourServerName> EnableDescribeParam=1 OptimizePrepare=1 SelectMethod=0 NetworkAddress=<YourServerName,YourPortNumber> SelectUserName=1
[SQLSERVERDB]
Driver=<Your installation directory>/merant/lib/UKmsss20.sl
Description=DataDirect 5.0 SQL Server Wire Protocol
Address=<Your SQLServer host>,<your SQLServer post>
AnsiNPW=Yes
Database=<Your Database Name>
QuoteId=No
[INFORMIXDB]
Driver=<Your Informix Client directory>/lib/cli/iclit09b.sl
Description=IBM Informix ODBC Driver
ServerName=<Your server name>
Database=<Your Datasource>
[ODBC] Trace=0 TraceFile=<A directory with plenty of free space>/odbctrace.out TraceDll=<Your installation directory>/merant/lib/odbctrac.sl InstallDir=<Your installation directory>/merant UseCursorLib=0 IANAAppCodePage=4 UNICODE=UTF-8
[ODBC Data Sources] WBRKBKDB=IBM DB2 ODBC Driver MYDB=IBM DB2 ODBC Driver ORACLEDB=DataDirect 5.0 Oracle SYBASEDB=DataDirect 5.0 Sybase Wire ProtocolSQLSERVERDB
=DataDirect 5.0 SQL Server Wire Protocol
INFORMIXDB
=IBM Informix ODBC Driver
[WBRKBKDB] Driver=/u/db2inst1/sqllib/lib/libdb2.so Description=WBRKBKDB DB2 ODBC Database Database=WBRKBKDB
[MYDB] Driver=/u/db2inst1/sqllib/lib/libdb2.so Description=MYDB DB2 ODBC Database Database=MYDB
[ORACLEDB] Driver=<Your installation directory>/merant/lib/UKor820.so Description=DataDirect 5.0 Oracle ServerName=<YourServerName> EnableDescribeParam=1 OptimizePrepare=1 ProcedureRetResults=1 WorkArounds=536870912
[SYBASEDB] Driver=<Your installation directory>/merant/lib/UKase20.so Description=DataDirect 5.0 Sybase Wire Protocol Database=<Your Database Name> ServerName=<YourServerName> EnableDescribeParam=1 OptimizePrepare=1 SelectMethod=0 NetworkAddress=<YourServerName,YourPortNumber> SelectUserName=1
[SQLSERVERDB]
Driver=<Your installation directory>/merant/lib/UKmsss20.so
Description=DataDirect 5.0 SQL Server Wire Protocol
Address=<Your SQLServer host>,<your SQLServer post>
AnsiNPW=Yes
Database=<Your Database Name>
QuoteId=No
[INFORMIXDB]
Driver=<Your Informix Client directory>/lib/cli/iclit09b.so
Description=IBM Informix ODBC Driver
ServerName=<Your server name>
Database=<Your Datasource>
[ODBC] Trace=0 TraceFile=<A Directory with plenty of free space>/odbctrace.out TraceDll=<Your installation directory>/merant/lib/odbctrac.so InstallDir=<Your installation directory>/merant UseCursorLib=0 IANAAppCodePage=4 UNICODE=UTF-8
[ODBC Data Sources] WBRKBKDB=IBM DB2 ODBC Driver MYDB=IBM DB2 ODBC Driver ORACLEDB=DataDirect 5.0 Oracle SYBASEDB=DataDirect 5.0 Sybase Wire ProtocolSQLSERVERDB
=DataDirect 5.0 SQL Server Wire Protocol
INFORMIXDB
=IBM Informix ODBC Driver
[WBRKBKDB] Driver=/u/db2inst1/sqllib/lib/libdb2.so Description=WBRKBKDB DB2 ODBC Database Database=WBRKBKDB
[MYDB] Driver=/u/db2inst1/sqllib/lib/libdb2.so Description=MYDB DB2 ODBC Database Database=MYDB
[ORACLEDB] Driver=<Your installation directory>/merant/lib/UKor820.so Description=DataDirect 5.0 Oracle ServerName=<YourServerName> EnableDescribeParam=1 ProcedureRetResults=1 OptimizePrepare=1 WorkArounds=536870912
[SYBASEDB] Driver=<Your installation directory>/merant/lib/UKase20.so Description=DataDirect 5.0 Sybase Wire Protocol Database=<Your Database Name> ServerName=<YourServerName> EnableDescribeParam=1 OptimizePrepare=1 SelectMethod=0 NetworkAddress=<YourServerName,YourPortNumber> SelectUserName=1
[SQLSERVERDB] Driver=<Your installation directory>/merant/lib/UKmsss20.so Description=DataDirect 5.0 SQL Server Wire Protocol Address=<Your SQLServer host>,<your SQLServer post> AnsiNPW=Yes Database=<Your Database Name> QuoteId=No
[INFORMIXDB]
Driver=<Your Informix Client directory>/lib/cli/iclit09b.so
Description=IBM Informix ODBC Driver
ServerName=<Your server name>
Database=<Your Datasource>
[ODBC] Trace=0 TraceFile=<A Directory with plenty of free space>/odbctrace.out TraceDll=<Your installation directory>/merant/lib/odbctrac.so InstallDir=<Your installation directory>/merant UseCursorLib=0 IANAAppCodePage=4 UNICODE=UTF-8
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ah14444_ |