| Author |
Message
|
| rvikky |
 Posted: Thu Mar 02, 2006 3:31 am Post subject: Deletion Problem |
 |
|
Apprentice
Joined: 14 Feb 2006
Posts: 32
Location: Bangalore
|
After deleting a Broker from Toolkit, I'm unable create a broker with same name. When I gave 'mqsilist', it still shows the broker name. Then I tried deleting from Command Console and it gives some error and diesn't deletes it.
Similarly, when I drop a database from DB2 which was created using 'mqsicreatedb' command gets dropped, but I'm unable to crete a new DB with same name with mqsi command. It gives DB already exists. Actually it doesn't exist. I even checked DB2 Control Center.
Why is it showing like this?
I'm working in Windows with WMB v6. |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Thu Mar 02, 2006 3:35 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi rvikky,
What do u mean when u say u deleted the broker ?
Did you do a mqsideletebroker ?
Please tell us your procedure of deletion.
Regards. |
|
| Back to top |
|
|
| rvikky |
| Posted: Thu Mar 02, 2006 3:42 am Post subject: |
|
|
Apprentice
Joined: 14 Feb 2006
Posts: 32
Location: Bangalore
|
whn i delete using mqsi delete broker also I have a problem like, I'm able to create a broker with same name but unable to add it to diff. config mgr.
the problem which I had mentioned earlier is deletion using toolkit. I deleted a broker using toolkit and tried creating a new one with same name, but I was unable to create and when I tries mqsilist command, it still existed. So I tried using mqsideletebroker and I'm unable to delete and it gives some error.
another case is i dropped a database from DB2 which I created using mqsicreatedb command. But I'm unable to create a new DB with same name using this command. The error is ' DB already exists' |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Mar 02, 2006 3:44 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| elvis_gn wrote: |
Hi rvikky,
What do u mean when u say u deleted the broker ?
Did you do a mqsideletebroker ?
Please tell us your procedure of deletion.
Regards. |
From his post
| rvikky wrote: |
| After deleting a Broker from Toolkit, I'm unable create a broker with same name. When I gave 'mqsilist', it still shows the broker name. Then I tried deleting from Command Console and it gives some error and diesn't deletes it. |
This is a case of read the ... manuals 
The deletion procedure is listed in detail.
Deleting the broker from the toolkit does not "delete" the broker. It just removes it from the configuration. The broker itself is still there as shown by mqsilist command. 
So what was "some kind of error?"
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| rvikky |
| Posted: Thu Mar 02, 2006 4:43 am Post subject: |
|
|
Apprentice
Joined: 14 Feb 2006
Posts: 32
Location: Bangalore
|
Error-------
"BIP2321E: Database error: ODBC return code '-1'.
The message broker encountered an error whilst executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database pertaining to this error.
Use the following messages to determine the cause of the error. This is likely to be such things as incorrect datasource or table names. Then correct either the database or message broker configuration.
BIP2322E: Database error: SQL State ''IM002''; Native Error Code '0'; Error Text ''[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified''.
The error has the following diagnostic information: SQL State ''IM002'' SQL Native Error Code '0' SQL Error Text ''[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified''
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.
BIP8040E: Unable to connect to the database.
The database cannot be accessed with the userid and password that were specified when the broker was created.
Check that the database is running, that an ODBC connection has been created and that the userid and password pair specified for ODBC connect on the mqsicreate command are capable of being used to connect to the database using an ODBC connection. Also ensure that the database has a adequate number of database connections available for use.
" |
|
| Back to top |
|
|
| rvikky |
| Posted: Thu Mar 02, 2006 4:45 am Post subject: |
|
|
Apprentice
Joined: 14 Feb 2006
Posts: 32
Location: Bangalore
|
| the mistake I did was, I deleted the Database assuming that broker has been deleted. Now I want to remove the broker. How should I do it? |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Mar 02, 2006 4:50 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi rvikky,
The error is not that the database is deleted, it is becoz you have not used the correct userid and password.
open the database command line editor and do a "list database directory", if your databse name is there then that means that the databse exists.
Still to answer your question, you can simply recreate the database using "create database <DBName>"....
I hope you do not get a "Database already exists" error.
Regards. |
|
| Back to top |
|
|
| rvikky |
| Posted: Thu Mar 02, 2006 4:54 am Post subject: |
|
|
Apprentice
Joined: 14 Feb 2006
Posts: 32
Location: Bangalore
|
I went o DB2 control center and looked for databases, its not available. Actually I dropped the Database manually using DB2 instead of using mqsideletedb command
I tried creating a DB with same name and then tried deleting the broker. even that didn't work.
My username and password are correct and when I follow the order mentioned in WMB-Basics pdf, it works properly. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Mar 02, 2006 5:04 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi rvikky,
Ok, i want to you to tell us the below.
1. What does mqsilist return.
2. Does your broker exist RIGHT NOW ?
3. Does your database exist RIGHT NOW ?
4. Post the commands you are using to create the broker and delete it.
5. Did you create an ODBC connection for the database.
6. Tell us the passwords for the Database.
Regards. |
|
| Back to top |
|
|
| rvikky |
| Posted: Thu Mar 02, 2006 7:38 pm Post subject: |
|
|
Apprentice
Joined: 14 Feb 2006
Posts: 32
Location: Bangalore
|
1. What does mqsilist return.
2. Does your broker exist RIGHT NOW ?
3. Does your database exist RIGHT NOW ?
4. Post the commands you are using to create the broker and delete it.
5. Did you create an ODBC connection for the database.
6. Tell us the passwords for the Database
1. MQSILIST Returns
BIP8099I: DbInstMgr: DatabaseInstanceMgr6 -
BIP8099I: Broker: NBROKER - NISHANTH
BIP8099I: Broker: SAMPLE_BROKER - SAMPLE_QUEUE
BIP8099I: ConfigMgr: SAMPLE_CONFIG - SAMPLE_QUEUE
BIP8099I: Broker: VBROKER - VIKRAM
BIP8071I: Successful command completion.
Of this I want to delete NBROKER & VBROKER which were using DB NDB & VDB respectively. Now the databse doesn't exist as I've deleted it from DB2 itself. Thatz my mistake.
2. Broker exists and I'm unable to delete it. When I try deleting, I get the error which I had posted earlier.
3. No, DB doesn't exist. I tried creating it and deleting the broker, it didn't work.
4. Steps for creation
a) Created a Queue Manager.
b) Created a Config. Mgr. using mqsicreateconfigmgr
c) Created DB using mqsicreatedb
d) Created broker using mqsicreatebroker
e) Started the Config. Mgr. & Broker using mqsistart
During Deletion I didn't maintain the order.
a) Stopped Config. Mgr. & Broker using mqsistop.
b) Deleted the broker from toolkit
c) Assuming broker has been deleted, I deleted the DB.
d) Deleted Config. Mgr. using mqsideleteconfigmgr.
e) Gave mqsilist and found the brokers still existing
f) Tried deleting The Broker and got error.
g) Tried creating the DB and tried deleting. But it didn't work.
5. I'm using mqsicreatedb command. This command creates the ODBC connection also.
6. I'm using the same username and password which I use for my Windows Login and it works. Those brokers are the first ones which I tried creating and it created properly. But during deletion, I made the mistake of deleting from Toolkit and also the mistake of deleting Database before deleting broker.
One more problem----
I'm unable to communicate between remote queues using toolkit. The message which I put in IN Queue goes to Dead Letter Queue. If I try the same using just MQ it works. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Mar 02, 2006 8:53 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi rvikky,
| Quote: |
| I'm unable to communicate between remote queues using toolkit. The message which I put in IN Queue goes to Dead Letter Queue. If I try the same using just MQ it works. |
This would be becoz the flow in the toolkit is throwing out the message and the message is pushed into the dead letter queue, whereas when you do a simple transfer in MQ it will be, irrespective of what the message is.
Now coming to the deletion:
1. Go to control Panel->Administrative Tools->Data sources.
2. Remove the ODBC connection for the databases used for NBROKER and VBROKER.
3. Go to Programs->IBM DB2->Command line tools->Command line processor
4. do a Drop database <DBName> for the two databases.
5. Do a create database <DBName> for the two databases.
6. Create the ODBC from the above link and check the connection using your userid password.
7. Now try the broker deletion.
Best of luck.
Regards. |
|
| Back to top |
|
|
| rvikky |
| Posted: Thu Mar 02, 2006 10:26 pm Post subject: |
|
|
Apprentice
Joined: 14 Feb 2006
Posts: 32
Location: Bangalore
|
| I tried and it didn't work |
|
| Back to top |
|
|
| rvikky |
| Posted: Fri Mar 03, 2006 12:29 am Post subject: |
|
|
Apprentice
Joined: 14 Feb 2006
Posts: 32
Location: Bangalore
|
I deleted the Registry Entry for those brokers and it worked finally.
Thanks to all of you |
|
| Back to top |
|
|
|
|
