| Author |
Message
|
| Srinu |
 Posted: Thu Mar 30, 2006 11:01 am Post subject: Deleting the broker |
 |
|
Acolyte
Joined: 15 Jun 2005
Posts: 51
|
Hi Everybody,
I am trying to delete the broker using mqsideletebroker command. Before I run this command I stopped the services. But I am getting the following error
C:\Program Files\IBM\MQSI\6.0>mqsideletebroker WBRK6_DEFAULT_BROKER
BIP2321E: Database error: ODBC return code '-1'.
The message broker encountered an error whilst executing a database operation. T
he ODBC return code was '-1'. See the following messages for information obtaine
d from the database pertaining to this error.
Use the following messages to determine the cause of the error. This is likely t
o be such things as incorrect datasource or table names. Then correct either the
database or message broker configuration.
BIP2322E: Database error: SQL State ''08001''; Native Error Code '-1032'; Error
Text ''[IBM][CLI Driver] SQL1032N No start database manager command was issued.
SQLSTATE=57019 ''.
The error has the following diagnostic information: SQL State ''
08001'' SQL Native Error Code '-1032' SQL Error Text ''[IBM][CLI
Driver] SQL1032N No start database manager command was issued. SQLSTATE=57019
''
This message may be accompanied by other messages describing the effect on the m
essage broker itself. Use the reason identified in this message with the accomp
anying 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 conne
ction. Also ensure that the database has a adequate number of database connectio
ns available for use
Plz help me out.
Thanks in advance.
[/quote] |
|
| Back to top |
|
 |
| sandiksk |
| Posted: Thu Mar 30, 2006 11:12 am Post subject: |
|
|
Centurion
Joined: 08 Jun 2005
Posts: 133
|
| did you delete the Database before you try to delete broker? |
|
| Back to top |
|
|
| mqseries0209 |
| Posted: Thu Mar 30, 2006 11:44 am Post subject: |
|
|
Voyager
Joined: 30 Mar 2006
Posts: 90
|
What services did you stop before deleting the broker?.
From the message you posted, it seems like you have stopped the database services too, else check that your database services are running before trying to delete the broker. |
|
| Back to top |
|
|
| JT |
| Posted: Thu Mar 30, 2006 1:02 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| ............and if DB2 was started, then check the db2diag.log file for relevant error messages. |
|
| Back to top |
|
|
| Srinu |
| Posted: Thu Mar 30, 2006 1:07 pm Post subject: |
|
|
Acolyte
Joined: 15 Jun 2005
Posts: 51
|
Thnx for the replies..
Problem with Database Services...Finally resolved.. |
|
| Back to top |
|
|
| Dalapathi |
| Posted: Mon May 01, 2006 11:31 am Post subject: |
|
|
Apprentice
Joined: 30 Jan 2006
Posts: 27
Location: IBM,BANGALORE,INDIA
|
Srinu ,
whether your problem is cleared or pending |
|
| Back to top |
|
|
| ferquirino |
| Posted: Mon May 05, 2008 12:34 pm Post subject: |
|
|
Apprentice
Joined: 05 May 2008
Posts: 34
Location: São Paulo, Brazil
|
Hi,
sandiksk write:
| Quote: |
| did you delete the Database before you try to delete broker? |
Yes, I did this.  
What can I do?
Thanks. |
|
| Back to top |
|
|
| _dave_ |
| Posted: Tue May 06, 2008 1:48 am Post subject: |
|
|
Apprentice
Joined: 08 Apr 2005
Posts: 33
Location: IBM Hursley
|
Recreate the database and try running mqsideletebroker again.
Mqsideletebroker is attempting to connect, so it can delete any rows for any of the tables for this particular broker UUID.
If after recreating the database you get further problems, then you can create a dummy broker using the same database, that way the tables will be recreated.
I think you can then delete both. Give it a try and let us know.
Manually deleting a broker on Windows is tricky because of the Windows service entry. So best try and sort it out cleanly with mqsideletebroker. |
|
| Back to top |
|
|
| ferquirino |
| Posted: Tue May 06, 2008 7:32 am Post subject: |
|
|
Apprentice
Joined: 05 May 2008
Posts: 34
Location: São Paulo, Brazil
|
| How I create database default DEFBKDB6 without wizard "Remove the default configuration"? |
|
| Back to top |
|
|
| mqmatt |
| Posted: Tue May 06, 2008 8:15 am Post subject: |
|
|
Grand Master
Joined: 04 Aug 2004
Posts: 1213
Location: Hursley, UK
|
| If you're using Derby (through DB2 Runtime Client Lite) on Windows, you can use mqsicreatedb/mqsideletedb to create and delete the DEFBKDB6 database. |
|
| Back to top |
|
|
| _dave_ |
| Posted: Tue May 06, 2008 9:07 am Post subject: |
|
|
Apprentice
Joined: 08 Apr 2005
Posts: 33
Location: IBM Hursley
|
You can also use mqsicreatedb to create a DB2 database if you are using that  |
|
| Back to top |
|
|
| ferquirino |
| Posted: Tue May 06, 2008 11:44 am Post subject: |
|
|
Apprentice
Joined: 05 May 2008
Posts: 34
Location: São Paulo, Brazil
|
Thanks for help and sorry for simple questions. 
My english is poor (I study in later 90 days) and I`m begginer in broker and mq. I have other problems with broker and mq, but, first, I will install fix packs of 6.0.2 and do other tests. After, I post other doubts... 
My English can correct the will... I want to also learn well English, but more to broker and mq...
  |
|
| Back to top |
|
|
| anupama |
| Posted: Thu May 08, 2008 9:59 pm Post subject: abt MB |
|
|
Novice
Joined: 03 Apr 2008
Posts: 19
|
Hi srinu
On wich os u r using MB......If u know any integration senarioes just send me... |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Thu May 08, 2008 10:02 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
C:\Program Files\IBM\MQSI\6.0 :- So Its WINDOWZ
Integration Scenarios, as i quoted before...get it from samples..thats the best place
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
|
|
