| Author |
Message
|
| ashritha |
 Posted: Thu Dec 08, 2005 1:12 pm Post subject: Cannot create broker on AIX |
 |
|
Voyager
Joined: 25 Jul 2005
Posts: 85
|
I just installed Message Broker v6 on AIX machine.
I could create config manager and username server but while i am trying to create a broker i get the following error:
| Quote: |
BIP8040E: Unable to connect to the database.
The database cannot be accessed with the userid and password that are
specified when the broker was created.
Check that the datbase is running, that an ODBC connection has been created
and that the userid and password pair specified for the 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 have db2 running under db2inst1 userid and have message broker running in mqm userid. I made db2inst1 a member of mqm and mqbrkrs groups. Is there anything else that i am missing?
Also, when I am trying to connect to the configuration manager on the AIX machine from a windows toolkit I have an error. Is it that I have to create a userid in AIX as that of the one that I am using in windows???
-Thanks. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Dec 08, 2005 1:35 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The db2 user doesn't need to be a member of the MQM group. That means that any db2 subsystem can access MQ.
The mqm user needs permissions in DB2 to access the database.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| ashritha |
| Posted: Thu Dec 08, 2005 2:10 pm Post subject: |
|
|
Voyager
Joined: 25 Jul 2005
Posts: 85
|
I will sure try that.
Also, do i have to create a DSN for the database to use it with the broker as we do in windows?
If needed, how do i do that? I am trying to find for .odbc.ini file but cannot find it on AIX machine. Does the ODBC drivers for DB2 get installed along with the DB2 product on AIX also as it does on windows??? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Dec 08, 2005 2:14 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Dec 08, 2005 8:46 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi ashritha,
I think you need to make the DSN....
Look for the ODBC file in this directory(default)
var/mqsi/odbc
You can view the file using
ls -ltra (ltr will not work)
Make changes using
cat .odbc.ini
But I think you should be able to enter a new DSN using
db2 catalog system ODBC data source <Database name>
the above works in Windows, dont know about AIX, not tried 
regards. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Dec 09, 2005 4:27 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It won't work on AIX, as there is no centralized ODBC subsystem for db2 to talk to and update.
There are, however, very very specific detailed instructions on how to create the necessary configuration information for broker databases on AIX.
Oddly enough, these instructions are in a subsection of the section of the manual that I linked to. 
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| ashritha |
| Posted: Mon Dec 12, 2005 7:20 am Post subject: |
|
|
Voyager
Joined: 25 Jul 2005
Posts: 85
|
Hello,
Thanks to all.
I resolved it.
The link forwarded by Jefflowery directed me.
Just follow the steps mentioned in Connecting to Databases and Authorizing access to the Databases.
And then when you create the brokers you should not have any problem.
Thanks once again Jeff. |
|
| Back to top |
|
|
|
|
