IBM Support

BIP2322E Problems connecting to a broker

Technote (troubleshooting)


Problems connecting to IBM Integration Bus (IIB) or WebSphere Message Broker (WMB). The following error is returned when the mqsicvp command is run:

BIP2322E: Database error: SQL State 'IM004'; Native Error Code '0'; Error Text '[DataDirect][ODBC lib] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed'. The error has the following diagnostic information: SQL State 'IM004' SQL Native Error Code '0' SQL Error Text '[DataDirect][ODBC lib] Driver's SQLAllocHandle on SQL_HANDLE_ENV

This message can be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.

Resolving the problem

Ensure that you have run both DB2 profile and sample profile for the broker's service id. You can also source both profiles in the brokers service id .profile.
Note: Ensure that you are using the correct ODBC driver as documented in the online information:
IIB: Sample IBM Integration Bus ODBC configuration files
WMB: Sample WebSphere Message Broker ODBC configuration files

Cross reference information
Segment Product Component Platform Version Edition
Business Integration WebSphere Message Broker AIX, HP-UX, Linux, Solaris 7.0, 8.0

Product Alias/Synonym

WMB MB WebSphere Message Broker MQ Integrator WBIMB WBI-MB MQSI WMQI

Document information

More support for: IBM Integration Bus

Software version: 9.0, 10.0

Operating system(s): AIX, HP-UX, Linux, Solaris

Reference #: 1136955

Modified date: 02 December 2016

Translate this page: