| Author |
Message
|
| Ching |
 Posted: Thu Apr 28, 2005 2:54 pm Post subject: 2 Data sources in 1 compute node |
 |
|
Apprentice
Joined: 08 Nov 2004
Posts: 25
Location: Portland, OR
|
Hi everyone,
I am developing a message flow that does table look ups from 2 different data sources.
1. UDB on AIX
2. DB2 on mainframe
My question is: How do you specify multiple data sources in the compute node properties?
I appreciate your help!
Ching |
|
| Back to top |
|
 |
| malammik |
| Posted: Thu Apr 28, 2005 3:23 pm Post subject: |
|
|
Partisan
Joined: 27 Jan 2005
Posts: 397
Location: Philadelphia, PA
|
I never done this but I had a similar need in the past which was resolved by linking the databases. There is a functionality in DB2 that allows you to be connected to one db and execute sql against another if they have been linked.
_________________
Mikhail Malamud
http://www.netflexity.com
http://groups.google.com/group/qflex |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Apr 28, 2005 3:33 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You could, of course, also use ... two compute nodes.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| malammik |
| Posted: Thu Apr 28, 2005 3:40 pm Post subject: |
|
|
Partisan
Joined: 27 Jan 2005
Posts: 397
Location: Philadelphia, PA
|
Jeff, do u know if broker upon select retrieves the entire dataset selected from the database or actually keeps an open cursor and retrieves the data in smaller batches? The reason I am asking is if broker indeed keeps a cursor to a dataset and it is not possible to somehow carry over that reference from one node to another, he could have a scenario where he would benefit from 2 dbs connected in one node. But I find it highly unlikely that the broker keeps reference to a cursor. I also dont think it was designed to retrieve very large numbers of records.
_________________
Mikhail Malamud
http://www.netflexity.com
http://groups.google.com/group/qflex |
|
| Back to top |
|
|
| Ching |
| Posted: Thu Apr 28, 2005 3:54 pm Post subject: |
|
|
Apprentice
Joined: 08 Nov 2004
Posts: 25
Location: Portland, OR
|
Thanks for the replies.
I would like to avoid using another compute node if possible. (for performance reasons)
Jeff,
Are you suggesting that each data source requires a unique compute node?
Ching |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Apr 28, 2005 4:35 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| Ching wrote: |
| I would like to avoid using another compute node if possible. (for performance reasons) |
The difference between one compute node and two, performance wise, is very small.
The difference between 100 and 200 compute nodes, performance wise, is slightly larger.
But I firmly subscribe to "make it work, THEN make it right, THEN make it fast". So if you're still making it work, then you're not ready to consider performance.
| Ching wrote: |
Are you suggesting that each data source requires a unique compute node?
|
I would never suggest anything that was clearly documented.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| JLRowe |
| Posted: Fri Apr 29, 2005 1:38 am Post subject: |
|
|
Yatiri
Joined: 25 May 2002
Posts: 664
Location: South East London
|
| Ching wrote: |
Thanks for the replies.
I would like to avoid using another compute node if possible. (for performance reasons)
Jeff,
Are you suggesting that each data source requires a unique compute node?
Ching |
Don't worry about performance, the connections are pooled. |
|
| Back to top |
|
|
| muralihegde |
| Posted: Fri Apr 29, 2005 1:49 am Post subject: |
|
|
Centurion
Joined: 30 Apr 2002
Posts: 108
|
Hi All,
Our requirement is also quite similar. I am trying to update two different databases, using two compute node. The first compute node updates database1 and then the second compute node updates database2.
But the broker is not able to connect to the second databasae.
Our environmnet is : WBIMB V5, FP04, on Z/OS mainframe and DB2.
The first database, is on the database subsystem DED1 and uses the datasource location as DED1LOC. This is the subsystem on which other broker database system tables and our user tables reside. The broker has no problem in connecting to this.
The second compute node is trying to connect to another DB2 database on a different subsystem called DB2D with location name DB2DLOC.
But we get an exception in this compute node, "locaiton node specified in the connect statement is invalid or not listed in the communication database."
I have edited the dsnaoini file to add a new stanza for the second db2 subsystem. But still we get the above error.
Am I missing some step here, any additonal chagnes to be done on the broker? any other files to be edited to add the new entry .
I checked the ENVFILE, there is no reference to the database location.
Any suggestions or ideas are greatly appreciated
thanks, -Murali |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Apr 29, 2005 3:26 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I think WBIMB on Z/OS is a little different in it's database support...
You may need to catalog the other database into the one you can connect to, and access it that way.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Ian |
| Posted: Fri Apr 29, 2005 3:46 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
Hi All,
To clarify the following point, in WMQI v2.1 and WBIMB v5.0 you can only access one DSN per node.
_________________
Regards, Ian |
|
| Back to top |
|
|
| nathanw |
| Posted: Fri Apr 29, 2005 3:57 am Post subject: |
|
|
Knight
Joined: 14 Jul 2004
Posts: 550
|
This is what I have found on client site.
the solution was to have one database with all tables within or use multiple compute nodes |
|
| Back to top |
|
|
| Diwakar |
| Posted: Fri May 13, 2005 8:03 am Post subject: |
|
|
Apprentice
Joined: 06 Apr 2005
Posts: 33
|
Can passthru statement/node help here in accessing 2 databases from 1 compute node ?
_________________
Diwakar. |
|
| Back to top |
|
|
| malammik |
| Posted: Fri May 13, 2005 8:05 am Post subject: |
|
|
Partisan
Joined: 27 Jan 2005
Posts: 397
Location: Philadelphia, PA
|
|
| Back to top |
|
|
|
|
