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
|Business Integration||IBM Integration Bus||Database||9.0||All Editions|
20386 370 000
WMB MB WebSphere Message Broker MQ Integrator WBIMB WBI-MB MQSI WMQI