| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Broker database deleted & broker is orphaned |
« View previous topic :: View next topic » |
| Author |
Message
|
| SAFraser |
 Posted: Wed May 19, 2004 11:18 am Post subject: Broker database deleted & broker is orphaned |
 |
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
I searched but didn't get a hit....
Our DBAs deleted a broker's persistent store. Fortunately, it was a broker that was about to be deleted anyway. I believe I have successfully removed the broker from the ConfigMgr as I find no references to it in the configuration database; but, I cannot delete the broker itself on the broker host because it can't find its database.
Surely someone else has been the victim of unruly DBAs? I'll appreciate any ideas you have. Thanks. |
|
| Back to top |
|
 |
| fschofer |
| Posted: Wed May 19, 2004 1:03 pm Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
Hi,
simply create a database with the same name and define the ODBC parameters.
Then run mqsideletebroker.
Greetings
Frank |
|
| Back to top |
|
|
| SAFraser |
| Posted: Fri May 21, 2004 5:28 am Post subject: |
|
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
I'll do it and post the results. It will take a few days as I have to submit a work order to the DBAs blah blah blah.
Thanks for the tip. |
|
| Back to top |
|
|
| SAFraser |
| Posted: Fri May 21, 2004 11:56 am Post subject: |
|
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
We went even one step simpler. Our DBA directed the service name in the tnsnames.ora file to an existing DB and gave the wmqi user connection rights. Although we got some errors during deletion (since there was no matching data in the DB), the deletion of the orphaned broker succeeded.
Thanks again for this great tip. |
|
| 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
|
|
|
|
