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 V9: Sample IBM Integration Bus ODBC configuration files
WMB V8: Sample WebSphere Message Broker ODBC configuration files

Cross reference information
Segment Product Component Platform Version Edition
Business Integration IBM Integration Bus Database 9.0 All Editions

Historical Number

20386 370 000

Product Alias/Synonym

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

Document information

More support for: WebSphere Message Broker
DB Connectivity / ODBC / JDBC

Software version: 7.0, 8.0

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

Reference #: 1136955

Modified date: 23 September 2013