| Author |
Message
|
| aditya.aggarwal |
 Posted: Thu Sep 10, 2009 6:37 am Post subject: Need To Change The D/B for Message Broker |
 |
|
Master
Joined: 13 Jan 2009
Posts: 252
|
Hi,
We are planning to change the D/B from DB2 to Oracle for the message Broker Environment. There will be no change in the Message Broker environment accept the Broker D/B type.
is it possible to migrate the Broker from DB2 to Oracle at Windows amd AIX platofrms? If yes then whay are the ways to migrate the Broker from DB2 to Oracle environment?
Cheers,
Aditya |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Thu Sep 10, 2009 6:56 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
It is (IMHO) far easier to delete the broker, change the odbc defs to poing at Oracle and recreate the broker, eg's and redeploy everything.
All this can be done via scripts (you do have scripts to do this don't you?).
It is repeatable and requires less faffing about trying to migrate the existing broker DB from DB2 to ORacle.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| aditya.aggarwal |
| Posted: Thu Sep 10, 2009 7:11 am Post subject: |
|
|
Master
Joined: 13 Jan 2009
Posts: 252
|
thanks...Which scripts you are pointing???
Cheers,
Aditya |
|
| Back to top |
|
|
| Luke |
| Posted: Thu Sep 10, 2009 7:43 am Post subject: |
|
|
Centurion
Joined: 10 Nov 2008
Posts: 128
Location: UK
|
| I think smdavies is suggesting there should be scripts that you, or somone in your organisation has produced to deploy your configuration. Some people do things manually through the toolkit of course, but the flaws associated with that should be apparent to you at this point ... |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Sep 10, 2009 8:01 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
FWIW I find it easier to delete & recreate the broker for anything apart from the most trivial change. Cleaner, simpler and (at risk of starting a fire) less likely to cause odd & bizzare WMB issues.
Especially when the delete & create are standard scripts as they typically are (sites like their installations a la cookie cutter).
My personal view, other views equally valid, etc, etc.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Sep 10, 2009 8:25 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| Vitor wrote: |
FWIW I find it easier to delete & recreate the broker for anything apart from the most trivial change. Cleaner, simpler and (at risk of starting a fire) less likely to cause odd & bizzare WMB issues.
Especially when the delete & create are standard scripts as they typically are (sites like their installations a la cookie cutter).
My personal view, other views equally valid, etc, etc. |
You can add the following
- Repeatable
- Verifiable
- Auditable
To the advantage of using scripts for the creation of Brokers, creation of EG's and the deployment of Flows etc.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
