| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| remote broker database |
« View previous topic :: View next topic » |
| Author |
Message
|
| sebastia |
 Posted: Wed Jan 28, 2009 6:59 am Post subject: remote broker database |
 |
|
Grand Master
Joined: 07 Oct 2004
Posts: 1003
|
Hi again.
I want to try to access a Windows DB2 database from an AIX Broker.
I am talking about the broker "own" database, not "user data" database.
What I have done until now is :
On Windows machine (IP=10.11.12.13) :
1) mqsicreatedb RMT_BRK_AIX -i db2admin -a passwd -e DB2 -u wbrkadm
2) db2 update database configuration for RMT_BRK_AIX using dbheap 900
3) db2 connect to RMT_BRK_AIX user db2admin
4) db2 grant connect, createtab, bindadd, create_external_routine on database to user wbrkadm
On AIX machine (IP=20.22.24.26)
5) modify odbc64.ini to contain
# DB2 stanza
[DB2DB]
DRIVER=libdb2Wrapper64.so
Description=Broker DB2 ODBC Database
Database=RMT_BRK_AIX
6) set ODBCINI envir var to point to odbc64.ini, full path
Now, and it is (I think) the last step before "mqsicreatebroker" command,
the manual says I have to "run a db2profile" ... in order to "add the DB2 client libraries to your library search path"
The problem is that I do not have DB2 on this machine,
and this is the reason I am trying to go to another (wintel) machine.
Easy question : what DB2 software shall I install on this AIX machine ?
Seems to be "DB2 client" .. am I right ?
- - -
And a last question : HOW IS IT that the remote IP has never been used on this procedure (I mean the wintel 10.11.12.13) ?
- - - |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Jan 28, 2009 7:03 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Unfortunately, you can't connect to the results of mqsicreatedb from a remote machine.
You're really going to have to halt your install/configure attempts until you can get sufficient diskspace *somewhere* to install a real DB2 .
And, yes, you need the DB2 Runtime Client installed on the AIX box - or the full DB2 Enterprise server if you want to run the broker db locally. These both come with the Broker install media.
The db2 catalog is where the connection information for the remote database is kept. But, again, the Derby database that is created by mqsicreatedb does not listen for external connections. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jan 28, 2009 7:05 am Post subject: Re: remote broker database |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| sebastia wrote: |
| I want to try to access a Windows DB2 database from an AIX Broker. |
I repeat my comments from here that this is an unnatural union and can only lead to problems.
| sebastia wrote: |
| Seems to be "DB2 client" .. am I right ? |
Depends. Are you trying to access the DB2 server via ODBC, or client onto it from AIX? AFAIK the broker needs "local" access so you'd need the client. And if you're going to install the client, install the full thing and solve all your problems at a stroke. 
| sebastia wrote: |
And a last question : HOW IS IT that the remote IP has never been used on this procedure (I mean the wintel 10.11.12.13) ?
|
Why should it have been used?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| sebastia |
| Posted: Wed Jan 28, 2009 7:14 am Post subject: |
|
|
Grand Master
Joined: 07 Oct 2004
Posts: 1003
|
I fully understand what you mean, Vitor, and completely agree.
The truth is next days I shall be configuring
an AIX (with MB) to AIX (with DB2) odbc connection,
and I am trying to do it here before that ...
but I do not have DB2 neither disk space for it ...
And I do have a VMWARE machine with full DB2 on it ...
Again, I am trying to learn my "blind spots" (is this correct english ?)
on this procedure, as by example, where to configure the destination IP.
I think it has to be provided/used on the client (broker) machine,
because the IP is the only way this machine has to reach the remote DB2, as far as I know, which is not very much, as we all can verify.
Cheers. Seb. |
|
| Back to top |
|
|
| sebastia |
| Posted: Wed Jan 28, 2009 7:31 am Post subject: |
|
|
Grand Master
Joined: 07 Oct 2004
Posts: 1003
|
Jeff : your phrase is very strong ...
"you can't connect to the results of mqsicreatedb from a remote machine"
Is this because it is Windows ?
Let me reverse the question ...
Can I access a DB2 on a remote DB2 on a remote AIX machine ?
My architect has designed to have MB and MQ on one AIX (under HACMP)
and DB2 on another AIX (under another HACMP), so it has to be possible,
or someone is going to have a headache !
Keep in mind I am not using DERBY anymore :
>>> mqsicreatedb RMT_BRK_AIX -i db2admin -a passwd -e DB2 -u wbrkadm |
|
| Back to top |
|
|
| sebastia |
| Posted: Wed Jan 28, 2009 7:35 am Post subject: |
|
|
Grand Master
Joined: 07 Oct 2004
Posts: 1003
|
Very interesting :
"The db2 catalog is where the connection information for the remote database is kept"
I accept that, but some day, someone will have to key into that catalog
the "magic" number :
"10.11.12.13"
The "server" DB2 is on this IP and not on any other,
and I suspect it is going to be me who's going to do it,
(updating db2 catalog)
so I was just surprised this small step was not found by my eyes
on the pages I am using :
>>> http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r1m0/index.jsp?topic=/com.ibm.etools.mft.doc/ah14470_.htm
Seb. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jan 28, 2009 7:41 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
|
| Back to top |
|
|
| sebastia |
| Posted: Wed Jan 28, 2009 7:53 am Post subject: |
|
|
Grand Master
Joined: 07 Oct 2004
Posts: 1003
|
Thanks a lot, Jeff -
that last step was the one I wasn't able to do by myself,
neither find it in infocenter.
That was the intention of this practice : fix the steps I wasn't able to do.
Thanks a lot. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
