| Author |
Message
|
| wmqiguy |
 Posted: Tue Dec 07, 2004 7:42 am Post subject: ODBC Connectivity |
 |
|
Centurion
Joined: 09 Oct 2002
Posts: 145
Location: Florida
|
Starting to get my feet wet with V5. I can now associate different userid/pwd with different ODBC connections. Super!
I was hoping to be able to use more than one connection in a Compute node, (Combine one value from DB A with another value from DB B.)
From the documentation, it doesn't look like I can, but thought I would run it by the group to see if I was missing something.
Thanks in advance.
Todd |
|
| Back to top |
|
 |
| JT |
| Posted: Tue Dec 07, 2004 9:05 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
Well.......actually there is a scenario where you can access multiple databases from the same Compute node. You'll have to assess for yourself whether it can be applied to your environment. Sometime ago, we discovered that you can issue SQL calls against different databases (Oracle), if they all share the same database id & password or that the database id has the proper rights to access the other databases. We did the following:
- Set the Data Source parameter of the Compute node to one of the databases.
- Set the database id & password for that data source via the mqsisetdbparms command
- Qualify the tables in the SQL statements with the varied database names.
- Grant the proper database pivileges to the specified database id
Apparently, the databse id & password that is registered for that data source is used for all the databases that are referenced in the Compute node. We became aware of this while doing some initial testing of WBIMB, but since our Q.A. & production environments strictly inforce the implementation of distinct database ids & passwords for all databases, we rarely use it (i.e. testing utilities). |
|
| Back to top |
|
|
| kirani |
| Posted: Tue Dec 07, 2004 11:38 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
I believe this will not work if you are using DB2 as database. One option would be to define remote table definitions of Database2 into Database1. In your compute node you would add Database1 DSN and use Remote table names as if they are local to your DB.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| wmqiguy |
| Posted: Wed Dec 08, 2004 5:19 am Post subject: |
|
|
Centurion
Joined: 09 Oct 2002
Posts: 145
Location: Florida
|
We are using DB2 and I figured that to be the case. I'll check with the DBA about remote table definitions.
Thanks. |
|
| Back to top |
|
|
| Bill.Matthews |
| Posted: Wed Dec 08, 2004 3:02 pm Post subject: |
|
|
Master
Joined: 23 Sep 2003
Posts: 232
Location: IBM (Retired)
|
Well, another possibility is to use DB2 Information Integrator and let it the combining of tables from different databases. Then WBIMB will only see the combined view and DB2 II does all the work.
Plus, you can get data from different database products at the same time, ie DB2, Oracle, Informix, and so on.
_________________
Bill Matthews |
|
| Back to top |
|
|
| JT |
| Posted: Wed Dec 08, 2004 9:27 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| kirani wrote: |
| I believe this will not work if you are using DB2 as database. |
Just curious why you believe this wouldn't work with DB2? |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Dec 09, 2004 12:05 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
I think the way you define database and schema in ORACLE is different than DB2. This is my understanding, so I could be wrong.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
|
|
