| Author |
Message
|
| varshasvin |
 Posted: Sun Apr 13, 2008 11:28 pm Post subject: Using Multiple databases (Oracle and DB2) |
 |
|
Newbie
Joined: 27 Feb 2008
Posts: 9
|
| We specify a data source into Compute code if there is one database and if there are two databases Oracle and DB2 from which tables to be fetched then how to define two data source names for two different databases |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Mon Apr 14, 2008 1:40 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
you can access only one database at a time from the compute,
Use two compute nodes to retrieve the data and aggregate/consolidate and do manipulation  
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| shalabh1976 |
| Posted: Mon Apr 14, 2008 2:48 am Post subject: |
|
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
Gaya3,
I was under the impression that in V6.x you can access multiple databases of the same TYPE from the same compute node.
Please advise.
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Apr 14, 2008 2:52 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| shalabh1976 wrote: |
Gaya3,
I was under the impression that in V6.x you can access multiple databases of the same TYPE from the same compute node.
Please advise. |
Oracle and DB2 are not of the same TYPE. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| biswagourab |
| Posted: Mon Apr 14, 2008 3:44 am Post subject: |
|
|
Apprentice
Joined: 31 May 2005
Posts: 47
Location: London
|
Does that mean that we can access 2 different DB2 databases from the same compute node ? [/quote]
_________________
_________________
Biswa Gourab Malla
IBM Certified System Administrator - WebSphere MQ, v6.0
IBM Certified System Administrator - Websphere Message Broker v6.0 |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Mon Apr 14, 2008 3:49 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Two or different tables under the same database Schema.
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| biswagourab |
| Posted: Mon Apr 14, 2008 3:54 am Post subject: |
|
|
Apprentice
Joined: 31 May 2005
Posts: 47
Location: London
|
Yes ... I understand that we can access multiple tables under the same DB schema.... but can we actually access 2 separate Databases? 
_________________
_________________
Biswa Gourab Malla
IBM Certified System Administrator - WebSphere MQ, v6.0
IBM Certified System Administrator - Websphere Message Broker v6.0 |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Mon Apr 14, 2008 4:10 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Apr 14, 2008 4:27 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| biswagourab wrote: |
| Does that mean that we can access 2 different DB2 databases from the same compute node ? |
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
