MQSeries.net :: View topic

tosaurav · Posted: Tue Jan 16, 2007 7:26 am Post subject:

All,
I am getting following error while deleting broker.The database is derby and i tried to delete it and recreate it but the result is same.Strangely it allows me to create new DB as well broker and which works perfectly.
Just wanted to get rid of this.

Any pointers/advise...???

C:\Program Files\IBM\MQSI\6.0>mqsideletebroker WBRK6_DEFAULT_BROKER
WebSphere MQ queue manager running.
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 '-30082'; Error
Text ''[IBM][CLI Driver] SQL30082N Attempt to establish connection failed with
security reason "3" ("PASSWORD MISSING"). SQLSTATE=08001 ''.
The error has the following diagnostic information: SQL State ''
08001'' SQL Native Error Code '-30082' SQL Error Text ''[IBM][CLI
Driver] SQL30082N Attempt to establish connection failed with security reason
"3" ("PASSWORD MISSING"). SQLSTATE=08001 ''
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.