| Author |
Message
|
| Henrique Neil |
 Posted: Wed Jul 26, 2006 5:52 am Post subject: mqsicreatebroker failed |
 |
|
Apprentice
Joined: 24 Jul 2006
Posts: 27
|
Hi All!
I got a error when i was trying to create a broker on SuSE Linux Enterprise Server 9.
The error is the following:
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 ''78''; Native Error Code '0'; Error Text ''523 76''.
The error has the following diagnostic information: SQL State ''78'' SQL Native Error Code '0' SQL Error Text ''523 76''
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.
I read about some solutions of this error like configure db2profile and mqsi_setupdatabase but without success 
Somebody know what is wrong?
Thanks
_________________
Henrique Neil
System Analyst - Cyberlynxx
http://www.clx.com.br |
|
| Back to top |
|
 |
| neerav |
| Posted: Wed Jul 26, 2006 6:46 am Post subject: |
|
|
Novice
Joined: 31 May 2006
Posts: 22
|
| Quote: |
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.
|
Are you able to connect to the DB and the DB Table using any of the DB clients (not through the broker)? |
|
| Back to top |
|
|
| Henrique Neil |
| Posted: Wed Jul 26, 2006 8:34 am Post subject: |
|
|
Apprentice
Joined: 24 Jul 2006
Posts: 27
|
neerav,
i get access through DB2Client but i don't get access through the broker command.
i think the problem is the broker connection with database, but i don't know what is wrong exactally.
the user and password are right, can you help me?
thanks
_________________
Henrique Neil
System Analyst - Cyberlynxx
http://www.clx.com.br |
|
| Back to top |
|
|
| wschutz |
| Posted: Wed Jul 26, 2006 8:53 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
|
| Back to top |
|
|
| Henrique Neil |
| Posted: Wed Jul 26, 2006 10:06 am Post subject: |
|
|
Apprentice
Joined: 24 Jul 2006
Posts: 27
|
Hi wschutz,
i read the link informations but it's not applicable at my problem.
if you want know the values of my variables i can send it to you:
LD_LIBRARY_PATH: /opt/mqm/java/lib:/opt/ibm/mqsi/6.0/lib:/opt/ibm/mqsi/6.0/bin:/opt/ibm/mqsi/6.0/merant/lib:/opt/ibm/mqsi/6.0/jre/bin/classic:/opt/ibm/mqsi/6.0/jre/bin:/opt/ibm/mqsi/6.0/xml4c/lib:instancehomedir/sqllib/lib
ODBCINI: /var/mqsi/odbc/.odbc.ini
LANG: en_US
Can you see something wrong in this values?
thanks
_________________
Henrique Neil
System Analyst - Cyberlynxx
http://www.clx.com.br |
|
| Back to top |
|
|
| Kateel |
| Posted: Wed Jul 26, 2006 10:45 am Post subject: |
|
|
Novice
Joined: 01 May 2006
Posts: 17
|
You might to want to check the following...
1. Make sure /opt/ibm/mqsi/6.0/merant/lib directory exists and your broker service id has read access to this directory.
2. The mqsicreatebroker command uses -u and -p correctly (database userid/passpwod)
3. /var/mqi/.odbc.ini file has been configured correctly.
If the above doesnot help you might try turning on the ODBC tracing and see if at all it attempts to connect to the database.
And I assume you are able to connect to database using sqlplus. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Wed Jul 26, 2006 8:54 pm Post subject: Re: mqsicreatebroker failed |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi Henrique Neil,
I think you should check these first
| Henrique Neil wrote: |
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. |
Regards. |
|
| Back to top |
|
|
| Henrique Neil |
| Posted: Thu Jul 27, 2006 5:29 am Post subject: |
|
|
Apprentice
Joined: 24 Jul 2006
Posts: 27
|
Hi All,
i think my problem is in mqsicreatebroker command but how must i do to know if my command is capable to use the odbc connection?
i found a .odbc.ini file but it's empty.
thanks
_________________
Henrique Neil
System Analyst - Cyberlynxx
http://www.clx.com.br |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jul 27, 2006 5:46 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Jul 27, 2006 5:47 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
|
| Back to top |
|
|
| GrandMaster |
| Posted: Thu Jul 27, 2006 9:50 am Post subject: Re: mqsicretebroker Failed |
|
|
Guest
|
One clue.
Your .odbc.ini file must not be empty. However i do not remeber you need to set the specific parameters in that(Ex: Database name, user id etc.)
Regards. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jul 27, 2006 10:08 am Post subject: Re: mqsicretebroker Failed |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| Henrique Neil |
| Posted: Thu Jul 27, 2006 11:49 am Post subject: |
|
|
Apprentice
Joined: 24 Jul 2006
Posts: 27
|
Hi All!
I made changes that you told me, but i get the same error yet.
My ODBC data is the following:
[WBIMBDB]
Driver=/opt/IBM/db2/V8.1/lib/libdb2.so
Description=IBM DB2 ODBC Driver for Broker
Database=WBIMBDB
ServerName=192.168.0.51
This database is on Windows 2003 Server and i had configured the DB2Client and it connects to the server make queries, etc...
Should I specify some username and password parameter for this file?
Thanks
_________________
Henrique Neil
System Analyst - Cyberlynxx
http://www.clx.com.br |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jul 27, 2006 11:55 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jul 27, 2006 11:55 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
duplicate deleted.
_________________
I am *not* the model of the modern major general.
Last edited by jefflowrey on Thu Jul 27, 2006 12:25 pm; edited 1 time in total |
|
| Back to top |
|
|
|
|
