MQSeries.net :: View topic - WMB 6.1 - problem in connecting to remote DB2

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 » WMB 6.1 - problem in connecting to remote DB2

WMB 6.1 - problem in connecting to remote DB2

« View previous topic :: View next topic »

Author

Message

Harshalw

Posted: Tue Aug 19, 2008 11:39 pm Post subject: WMB 6.1 - problem in connecting to remote DB2

Voyager

Joined: 23 Jul 2008
Posts: 77

I am using WMB 6.1 on windows and trying to connect to remote DB2 on AIX box. Have made the ODBC connection for the same.

I have created a default configuration manager, broker and broker database on windows. Now if i execute my msg flow , its gives me exception - Text:CHARACTER:[IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

However when i try to connect to ODBC connection , it get connected successfully.

Why the msg flow gives me error for this? Is it expecting user id and password for broker db or something else ?

Thanks
harshalw

AkankshA

Posted: Tue Aug 19, 2008 11:48 pm Post subject:

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

What all have you tried so far ?? and hat are the steps you followed??

did u create a DSN for remote DB2 ??

did u supply pswd using mqsisetdbparms ??
_________________
Cheers

Harshalw

Posted: Wed Aug 20, 2008 12:48 am Post subject:

Voyager

Joined: 23 Jul 2008
Posts: 77

Steps are as follows:
1.Created default configuration manager, broker and broker database through toolkit help .
2. created a simple project having compute node , MQinput node and MQoutput node
3. Created a datasource (ODBC) for remote db2(AIX box).
4. Used the above datasource name in the property box of compute node.

P.S - My broker database and remote database are different. Broker database is created through default configuration and is local on the windows whereas remote db2 which i will be using in my code is remote and on AIX system.
In this case do i have to use mqsisetdbparms ?

Harshalw

Posted: Wed Aug 20, 2008 1:04 am Post subject:

Voyager

Joined: 23 Jul 2008
Posts: 77

used mqsisetdbparms and it worked.

thanks

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WMB 6.1 - problem in connecting to remote DB2

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