| Author |
Message
|
| elvis_gn |
 Posted: Thu Feb 09, 2006 1:11 am Post subject: |
 |
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi praveenraju,
Do a list database directory and tell us all the database names returned.
You are trying to create a local broker..right?
Is this the first time you are creating the broker or have you tried before...say through the command line ?
Regards. |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Thu Feb 09, 2006 1:59 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi praveenraju,
Well the database is listed and is at a remote location.
You could either drop it from the remote location OR remove the connection to the remote machine from the DB2 control center.
Then try to do the default configuration.
Regards. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Feb 09, 2006 2:11 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi praveenraju,
The database is on another system, I hope you know which system it is atleast.
Even I haven't worked on cloudscape but if the remote machine is running DB2, then open the "Start->Programs->IBM Db2->Command Line Tools->Command Line processor" and do a
| Code: |
| drop database DEFBKDB6 |
You should get a status message saying delete successful.
After this do the creation.
P.S: If you are not able to delete the databse then I would suggest you simply use some other database name 
Regards. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Feb 09, 2006 2:20 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi praveenraju,
It is possible that the database was deleted at the remote location but that your cloudscape is still not updated about its deletion.
It will be simpler if you juat use some other database name, since you are anyway creating a local broker.
Regards. |
|
| Back to top |
|
|
| mqmatt |
| Posted: Thu Feb 09, 2006 2:29 am Post subject: |
|
|
Grand Master
Joined: 04 Aug 2004
Posts: 1213
Location: Hursley, UK
|
| praveenraju wrote: |
| do i have the option of specifying a database name when i am doing the default configuration??? |
No (deliberately so).
You say that you are using Cloudscape - if you're trying to clear up a previous database, try "mqsideletedb DEFBKDB6" rather than the drop database command.
-Matt |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Feb 09, 2006 2:33 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi praveenraju,
Oh God, sorry for asking, you joined this site in 2003, from then till now haven't you done a default configuration ? Or were you into MQ alone till now ? 
Anyway, you can specify the Database name and the Queue Manager names....
You can also create it from the command line...please search this forum for the command mqsicreate.
Please read some documentation before you work on this tool...or atleast use the pdf's...one of them takes you step by step.
Regards. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Feb 09, 2006 4:17 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
| mqmatt wrote: |
| praveenraju wrote: |
| do i have the option of specifying a database name when i am doing the default configuration??? |
No (deliberately so).
|
We can specify the database...
praveenraju:
You asked me the question first...How do you suppose the toolkit knew that you wanted to use DEFBKDB6...you must have specified it, and thus answered your own question 
Regards. |
|
| Back to top |
|
|
| james2005 |
| Posted: Thu Feb 09, 2006 5:47 am Post subject: |
|
|
Apprentice
Joined: 18 Sep 2005
Posts: 31
|
| Just delete broker domain and create broker, configuration manager manually. I also tried the same like u but using mqsi commands only is the better way. |
|
| Back to top |
|
|
| mqmatt |
| Posted: Thu Feb 09, 2006 5:58 am Post subject: |
|
|
Grand Master
Joined: 04 Aug 2004
Posts: 1213
Location: Hursley, UK
|
| elvis_gn wrote: |
| mqmatt wrote: |
| praveenraju wrote: |
| do i have the option of specifying a database name when i am doing the default configuration??? |
No (deliberately so).
|
We can specify the database...
|
Not in the v6 Default Config Wizard you can't; the only piece of information that you're prompted for is your password. It deliberately cuts down the number of options you have to make, and DEFBKDB6 is the name of the database the wizard creates for you (in either Cloudscape or DB2, depending on what is installed.)
You can specify database options for brokers using the command line or command assistant wizards.
Regards
-Matt |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Feb 09, 2006 9:20 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi praveenraju,
Congrats and welcome back to MB 
I would suggest you work with the command line for creation of configMgr, broker's etc....its the right way to go.
Please mark the topic solved (edit your first post and add a [Solved] infront of the subject, thx)
mqmatt:
Thanks for the info on v6...i'll remember this when i move to v6..soon hopefully.
Regards. |
|
| Back to top |
|
|
| mqmatt |
| Posted: Fri Feb 10, 2006 4:20 am Post subject: |
|
|
Grand Master
Joined: 04 Aug 2004
Posts: 1213
Location: Hursley, UK
|
| elvis_gn wrote: |
| I would suggest you work with the command line for creation of configMgr, broker's etc....its the right way to go. |
I think it's a matter of personal preference. I used commandline scripts to set up components in v5; I like the DCW in v6 because I really don't need to think about anything, and the deployment step at the end of the wizard acts as an installation verification check which, on my development machine is really, really useful
This said, I find myself using both techniques - I don't particularly dislike the commandline. In fact, I spent a whole boring afternoon editing the syntax messages (putting each flag on a new line), so the more people that see those the better
-Matt |
|
| Back to top |
|
|
| jamest_ibm |
| Posted: Tue Feb 14, 2006 7:39 am Post subject: |
|
|
Newbie
Joined: 13 Dec 2004
Posts: 9
Location: Winchester, UK
|
|
| Back to top |
|
|
|
|
