MQSeries.net :: View topic - Creating 6.1 broker with 32-bit database instance

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Creating 6.1 broker with 32-bit database instance

Creating 6.1 broker with 32-bit database instance

« View previous topic :: View next topic »

Author

Message

n1ghtrain

Posted: Fri Nov 14, 2008 10:30 pm Post subject: Creating 6.1 broker with 32-bit database instance

Apprentice

Joined: 23 Mar 2006
Posts: 48
Location: Bangalore

I am facing some ODBC connection problems while creating WMB 6.1 broker on Aix. Broker database is planned on DB2 v8.1 with fixpak 17.

The user id that i'm using is part of mqm,mqbrkrs and i used the same id to create the database and connect to it. I tried the following steps.

1) Set ODBCINI32 variable to odbc32.ini and then set MQSI_LIBPATH32 variable to add 32 bit libraries as given in
[url]
http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r1m0/index.jsp?topic=/com.ibm.etools.mft.doc/ah25530_.htm[/url]

Code:

mqsicreatebroker DVMB02 -i user -a password -q DVEP02 -n DV02BRKR -u user -p password

Error complaining

BIP8222E: Unable to find ODBCINI file ''.
Could not find the ODBCINI file '', which is specified by the ODBCINI environment variable.
Ensure that the ODBCINI environment variable points to an existing ODBCINI file.
IOT/Abort trap (core dumped)

----
odbc.ini section looks like

# DB2 version 8 stanza
[DV02BRKR]
Driver=/data1/opt/db2_08_01/lib/libdb2.a
Description=DB2V8DB DB2 ODBC Database
Database=DV02BRKR

2) Set ODBCINI variable also to odbc32.ini and tried to create the broker

BIP2322E: Database error: SQL State ''IM003''; Native Error Code '0'; Error Text ''[DataDirect][ODBC lib] Specified driver could not be loaded''.The error has the following diagnostic information: SQL State ''IM003'' SQL Native Error Code '0' SQL Error Text ''[DataDirect][ODBC lib] Specified driver could not be loaded''

BIP8040E: Unable to connect to the database.

3) SET ODBCINI to odbc64.ini though the db2 instance is 32.

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 failed''
---

Am i doing it totally wrong.?

m4c0

Posted: Mon Nov 17, 2008 3:52 am Post subject: Re: Creating 6.1 broker with 32-bit database instance

Novice

Joined: 07 Nov 2008
Posts: 17

n1ghtrain wrote:

odbc.ini section looks like

# DB2 version 8 stanza
[DV02BRKR]
Driver=/data1/opt/db2_08_01/lib/libdb2.a
Description=DB2V8DB DB2 ODBC Database
Database=DV02BRKR

I guess you must reference the libdb2.SO dynamic library, not the libdb2.A static library.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Creating 6.1 broker with 32-bit database instance

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP