| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Sharing Broker database |
« View previous topic :: View next topic » |
| Author |
Message
|
| damianharvey |
 Posted: Mon Oct 03, 2005 4:51 pm Post subject: Sharing Broker database |
 |
|
Acolyte
Joined: 05 Aug 2003
Posts: 59
Location: Sydney, Australia
|
I am running a Broker Production environment and had originally planned for a separate Oracle database for each Broker. Due to outsourcing and licensing, this is not the cheapest option (we pay per database). On re-reading the Info Center it suggests that you can share a Database "if the platforms are compatible."
Before I embark on what is an ardous journey of requesting a database to test this in, can someone tell me if they have done this sucessfully on Oracle + Linux (or even Unix)? Any issues with doing this in production? Is an alternative to use a different schema for each broker in the one database?
Cheers,
Damian. |
|
| Back to top |
|
 |
| happyj |
| Posted: Tue Oct 04, 2005 12:50 am Post subject: |
|
|
Voyager
Joined: 07 Feb 2005
Posts: 87
|
I have 2 brokers (test and qa) sharing a single (oracle hp) database using a different database user / schema. Only used for testing but seems ok so far.
The production broker ( only using one ) has it's own dataabse. |
|
| Back to top |
|
|
| jfluitsm |
| Posted: Wed Oct 05, 2005 12:23 am Post subject: |
|
|
Disciple
Joined: 24 Feb 2002
Posts: 160
Location: The Netherlands
|
The broker uuid is a part of every broker table, so it is no problem to even use the same schema/userid.
_________________
Jan Fluitsma
IBM Certified Solution Designer WebSphere MQ V6
IBM Certified Solution Developer WebSphere Message Broker V6 |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Wed Oct 05, 2005 12:53 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi,
this is something I read on recently also,but cannot try in a project  ... I guess not many have tried this out, else you would have got some suggestions.
I hope u'll get it working and tell us the steps and any glitches, so future generations of WBI developers including me will be guided 
Best of luck...
Regards. |
|
| Back to top |
|
|
| jfluitsm |
| Posted: Wed Oct 05, 2005 4:32 am Post subject: |
|
|
Disciple
Joined: 24 Feb 2002
Posts: 160
Location: The Netherlands
|
I used it a couple of times.
Just do a mqsicreatebroker with the same database options (-n, -u, -p) as the other broker(s), only the broker name and queue manager should be different.
There is even no need to be on the same server or platform.
Regards |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
