ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WBIMB v5 broker with Remote Database

Post new topic  Reply to topic
 WBIMB v5 broker with Remote Database « View previous topic :: View next topic » 
Author Message
lbart
PostPosted: Fri Mar 16, 2007 2:29 am    Post subject: WBIMB v5 broker with Remote Database Reply with quote

Novice

Joined: 18 May 2006
Posts: 13
Location: Manchester
Dear all,

Hopefully somebody can help me. I have a broker environment setup in v5 and my broker needs to use a DB2 (v8.2) Database that is remote to the broker. I have configured the Database to be accessible via my local DB2 Control Centre but I seem to need someway of telling my broker the user id and password for that database.

I have even created the ODBC / System DSN link supplying the userid / password and tested the connection. I then created a simple message flow which attempted to select the number of rows in a table. This fails with an error indicating that the userid/password is incorrect. I have tried restarting my PC & still get the same problem.

The database is visible from my local machine in DB2 Control Centre which has the broker environment on it and I can see it from the db2cmd interface and it does list out but still asks for a user id and password for me to successfully connect to the remote database.

So my question, is there a correct way to connect to a Remote DB2 database from WBIMB v5 ??

Many thanks
Lee
Back to top
View user's profile Send private message MSN Messenger
jefflowrey
PostPosted: Fri Mar 16, 2007 3:52 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981
mqsisetdbparms
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
lbart
PostPosted: Fri Mar 16, 2007 8:14 am    Post subject: Thank Reply with quote

Novice

Joined: 18 May 2006
Posts: 13
Location: Manchester
I thought it was that but it wasn't clear from the manual. Should of tried it first I guess. Many thanks for the response.
Back to top
View user's profile Send private message MSN Messenger
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WBIMB v5 broker with Remote Database
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
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.