MQSeries.net :: View topic - using DB2 for broker, and Oracle for Application databases

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 » using DB2 for broker, and Oracle for Application databases

using DB2 for broker, and Oracle for Application databases

« View previous topic :: View next topic »

Author

Message

ydsk

Posted: Thu Feb 05, 2009 8:57 am Post subject: using DB2 for broker, and Oracle for Application databases

Chevalier

Joined: 23 May 2005
Posts: 410

Hi,

I am using MB v6.1. We use DB2 for broker database, I used mqsisetdbparms to set it up and the msgflows are running fine on the broker boxes already.

We also have a Oracle database for application databases that broker needs to access.

Do I need to run mqsisetdbparms command to setup Oracle database for the broker to access it ? Does it affect the DB2 setup already done ?

Appreciate any help.

Thanks in advance.
ydsk.

AkankshA

Posted: Thu Feb 05, 2009 8:39 pm Post subject:

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

you need not run mqsisetdbparms for broker database... we provide broker db credentials while creating broker

Give mqsisetdbparms for all the DB which the flows would access and they can be of any type (supported obv :p)
_________________
Cheers

MQEnthu

Posted: Thu Feb 05, 2009 8:40 pm Post subject:

Partisan

Joined: 06 Oct 2008
Posts: 329
Location: India

Yes, you should run the mqsisetdbparm. So that flows can access the required database with user id specified user id in mqsisetdbparm.

Hope you have created the connection to the data source name so as to enable connection to your application database.

__________________________________________

MQEnthu

Posted: Thu Feb 05, 2009 8:42 pm Post subject:

Partisan

Joined: 06 Oct 2008
Posts: 329
Location: India

Quote:

Does it affect the DB2 setup already done ?

No.. since we provide the datasource name while executing the mqsisetdbparm...it does not affect the already set up databases.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » using DB2 for broker, and Oracle for Application databases

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