| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ODBC and Configurable service |
« View previous topic :: View next topic » |
| Author |
Message
|
| Gideon |
 Posted: Mon Jul 11, 2011 2:27 pm Post subject: ODBC and Configurable service |
 |
|
Chevalier
Joined: 18 Aug 2009
Posts: 403
|
|
| Back to top |
|
 |
| rglack10 |
| Posted: Mon Jul 11, 2011 10:44 pm Post subject: Re: ODBC and Configurable service |
|
|
Apprentice
Joined: 06 Jul 2011
Posts: 34
|
wouldn't that be with the mqsisetdbparms command? as long as your odbc.ini file is correct and your tnsnames.ora etc... |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Jul 12, 2011 5:00 am Post subject: Re: ODBC and Configurable service |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Gideon wrote: |
I am using WMB 7 on Linux
I made some progress, reading the following link: (I still do not have class approval)
There is no ODBC 'Type'.
How do you create a ODBC configurable service? |
Well, I'm proud of you for requesting the class.
Step 1. mqsisetdbparms <brokername> -n <DB2 instance name> -u <service_id> -p <password>
Step 2. mqsicvp -n <DB2 instance name> -u <service_id> -p <password>
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Gideon |
| Posted: Tue Jul 12, 2011 10:00 am Post subject: |
|
|
Chevalier
Joined: 18 Aug 2009
Posts: 403
|
I appreciate the help
One question: Can WMB connect to a remote database through the DB2 client
In other words is there a requirement that the DB reside on the same machine as WMB, as WMQ must reside on the same machine as WMB ? |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Jul 12, 2011 10:20 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
This question has been answered many times before. It is also covered in the documentation.
How about:-
http://www.mqseries.net/phpBB2/viewtopic.php?t=55320 for starters.
your original question is also answered by a simple search.
This one -> http://www.mqseries.net/phpBB/viewtopic.php?p=76379, dating from 2004 would even help your first question if you were running the broker on Windows.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| Gideon |
| Posted: Tue Jul 12, 2011 5:53 pm Post subject: |
|
|
Chevalier
Joined: 18 Aug 2009
Posts: 403
|
I read the links in the preceding post, they were very helpful.
I read one statement that surprised me:
| Quote: |
The broker makes connections via ODBC and, in the case of DB2, the ODBC driver always connects to the database, be it local or remote, via the DB2 client.
So, first a DB2 client definition (i.e. an 'alias') for the remote database must be made and then an ODBC definition made which points to the database alias. |
Does this mean that on a machine (say Linux), that I have both a WMB and DB2 database installed, I still need to have a DB2 client installed to connect with the locally hosted database ??? Did I understand that correctly? |
|
| 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
|
|
|
|
