| Author |
Message
|
| mrgate |
 Posted: Wed Feb 28, 2007 12:54 pm Post subject: uninstalled the database |
 |
|
Centurion
Joined: 28 Feb 2007
Posts: 141
Location: India
|
Hello,
I am using ibmdb2(database) version 8.2 and have uninstalled the data base and now Broker is not working. can anyone help me how to solve this problem. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Feb 28, 2007 12:55 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Broker can't run without a database.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mrgate |
| Posted: Wed Feb 28, 2007 12:58 pm Post subject: |
|
|
Centurion
Joined: 28 Feb 2007
Posts: 141
Location: India
|
hello,
I have installed the database again. can any one tell me how to make broker run successfully. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Wed Feb 28, 2007 7:54 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Hi
Connect broker and config with the database....
it will work....
i dont know why you un-installed the database at first.
for more information search the forum...
Thanks and Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| au@kosa |
| Posted: Wed Feb 28, 2007 10:33 pm Post subject: |
|
|
Centurion
Joined: 04 Jan 2007
Posts: 103
Location: pune
|
You can try this
1. Delete the DSN name of the old broker DB (the one which you have deleted).
2. Create a broker db
3. Rename the ODBC DSN name of the new broker DB, same as the ODBC DSN name of the OLD broker DB.
4. Restart the broker
_________________
Regards,
au@kosa
IBM Certified SOA Solution Designer/Associate |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Wed Feb 28, 2007 10:45 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi au@kosa,
| au@kosa wrote: |
You can try this
1. Delete the DSN name of the old broker DB (the one which you have deleted).
2. Create a broker db
3. Rename the ODBC DSN name of the new broker DB, same as the ODBC DSN name of the OLD broker DB.
4. Restart the broker |
Once if the Broker database has been deleted and you simply create another database...it does not become a broker database....hence starting the broker with that db won't work...or atleast I don't see how it could...
You can create another database with the same name, then delete the broker...then re-create the broker with the same database...this will in-turn create the broker specific tables in that database.
Regards. |
|
| Back to top |
|
|
| au@kosa |
| Posted: Wed Feb 28, 2007 11:38 pm Post subject: |
|
|
Centurion
Joined: 04 Jan 2007
Posts: 103
Location: pune
|
I got your point Elvis and totally agree with you,
The new created DB through mqsicreateDb command does not contain broker tables.
What if we copy the broker tables from another broker DB into this DB and then changing this DSN name for the new broker DB. Then restarting the broker
I doubt that it will work but still want to know the views of the Masters.
_________________
Regards,
au@kosa
IBM Certified SOA Solution Designer/Associate |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Mar 01, 2007 1:02 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi au@kosa,
| au@kosa wrote: |
| What if we copy the broker tables from another broker DB into this DB and then changing this DSN name for the new broker DB. Then restarting the broker |
The UUID itself will be incorrect, and then you'll try to connect to the configMgr which will fail...now you may go and change the UUID by looking into the configMgr tables...but still all your broker information in this broker Db is incorrect(it is specific to another broker)...
Instead of running around all these issues, isn't it much better to simply delete and re-create....and NOT commit the same crime again.
Regards. |
|
| Back to top |
|
|
|
|
