MQSeries.net :: View topic - Broker database

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 » Broker database

Broker database

« View previous topic :: View next topic »

Author

Message

mqwbiwf

Posted: Thu Aug 31, 2006 9:59 am Post subject: Broker database

Centurion

Joined: 21 Jul 2006
Posts: 126

Hi,
We are planning to use oracle database for the broker(till now used to have DB2 for WMQI 2.1). Can we have a remote database as a broker database or should that be a local database itself. As far as I saw, I could not find regarding this in the info-center.
Can someone let me know what kind of precautions should we consider inorder to use a remote oracle as broker database(if we can). We will be using WMB 6 with Oracle 10g on AIX 5.2/5.3.
Thank you.

jefflowrey

Posted: Thu Aug 31, 2006 10:10 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

I guess you didn't look very hard in the Info Center.

http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r0m0/index.jsp?topic=/com.ibm.etools.mft.doc/ah14440_.htm

Yes, you can use a remote Oracle database. This has all the same potential problems as accessing any remote database.

Also, make very sure that you only use a supported version of either the Oracle client if using a remote database or the Oracle local install if using a local database.
_________________
I am *not* the model of the modern major general.

mqwbiwf

Posted: Thu Aug 31, 2006 10:31 am Post subject:

Centurion

Joined: 21 Jul 2006
Posts: 126

So I can access any remote database as broker database by editing the .odbc.ini file (where broker is installed) and having the right client to access the server.
I am confused with one other thing Jeff and would be happy if you clarify this for me please.
How can I determine whether an exec group is a 32-bit or 64-bit one. It's given in doc:

Quote:

If you have defined 64-bit execution groups for a broker, you must define both 32-bit and 64-bit DSNs for the broker database.

Since we'll be using WMB 6, I beleive it should be a 64bit Exec Group. So what does 32-bit and 64-bit DSN 's mean?

jefflowrey

Posted: Thu Aug 31, 2006 10:37 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

The Info Center explains this.
_________________
I am *not* the model of the modern major general.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Broker 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