Re: query involving 2 different DBs

Jorge Daniel Ortiz

Re: query involving 2 different DBs
(in response to Rick Creech)
<color><param>0100,0100,0100</param><smaller>For some reason we are getting dozens of messages from different senders,
indicating that reply must be sent to your address. We would greatly appreciate
that you do something to stop this.We do not want to be included in any list for
any purposes whatsoever. This is an inconvenience that I am sure you do not
wish to cause. Thank you for your help. Best wishes. <bigger>

<nofill>
Attachments

  • import1 (<1k)

Mike Bruzdzinski

Re: query involving 2 different DBs
(in response to Leonardo Kenji Shikida)
Assuming that you do not want to hard code the DB qualifier, consider using
an ALIAS. This will keep your coding and BIND parameters to a minimum.

-----Original Message-----
From: Leonardo Kenji Shikida [mailto:[login to unmask email]
Sent: Wednesday, October 06, 1999 11:48 AM
To: [login to unmask email]
Subject: query involving 2 different DBs


I want to make a query involving 2 different DBs on the same DB2 machine.
How do I do this ?
Or it's better to put all tables in the same database ?

thanks in advance

K

Wayne Driscoll

Re: query involving 2 different DBs
(in response to Mike Bruzdzinski)
It depends on which DB2 you are using. With DB2 OS/390, this can be done as
long as both databases are in the same subsystem. With DB2 UDB for Windows,
OS/2 or UNIX, the only way this can be done is through an additional product
such as IBM's Datajoiner. This is because on these platforms, databases are
distinct objects.
Wayne Driscoll
Product Developer
Quest Software
[login to unmask email]

Note: All opinions are strictly my own

-----Original Message-----
From: Leonardo Kenji Shikida <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: [login to unmask email] <[login to unmask email]>
Date: Wednesday, October 06, 1999 10:00 AM
Subject: [DB2-L] query involving 2 different DBs


>I want to make a query involving 2 different DBs on the same DB2 machine.
>How do I do this ?
>Or it's better to put all tables in the same database ?
>
>thanks in advance
>
>K
>

Leonardo Kenji Shikida

query involving 2 different DBs
I want to make a query involving 2 different DBs on the same DB2 machine.
How do I do this ?
Or it's better to put all tables in the same database ?

thanks in advance

K

Leon Katsnelson

Re: query involving 2 different DBs
(in response to Wayne Driscoll)
Can you be a bit more specific. Where do you want to do this query from PC,
UNIX, Web, SPUFI, batch etc.? When you say "2 different DBs" do you mean tables
in different databases on the same DB2 for OS/390 subsystem or one table in DB2
UDB on UNIX and another in DB2 for OS/390 or one table in DB2 for OS/390 and the
other in Oracle etc.

All of these scenarios are possible but how you would do them depends on the
answers to these questions.

Leon Katsnelson, DB2 Connect Development Manager
mailto:[login to unmask email]


Leonardo Kenji Shikida <[login to unmask email]> on 10/06/99 11:47:46 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc:
Subject: query involving 2 different DBs




I want to make a query involving 2 different DBs on the same DB2 machine.
How do I do this ?
Or it's better to put all tables in the same database ?

thanks in advance

K

craig patton

Re: query involving 2 different DBs
(in response to Leon Katsnelson)
Leonardo,

DAta is accessed via TABLEs and NOT at the database level. Other than
perhaps a performance consideration, it does NOT matter in which database
the tables reside. Generally, I prefer to keep JOINed tables in the same
database (to avoid loading 2 different DBD's in the EDM Pool). However, if
the EDM pool is sized correctly and BOTH DBD's are resident, Then it really
should NOT matter where the two tables reside. This is actually one of the
benefits of the DB2 DBMS.

HTH,
Craig Patton
Other Comments Welcomed




>From: Leonardo Kenji Shikida <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: query involving 2 different DBs
>Date: Wed, 6 Oct 1999 12:47:46 -0300
>
>I want to make a query involving 2 different DBs on the same DB2 machine.
>How do I do this ?
>Or it's better to put all tables in the same database ?
>
>thanks in advance
>
>K

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

Rick Creech

Re: query involving 2 different DBs
(in response to craig patton)
If you are talking about different DB2 sub-systems, there will be overhead
in accessing tables from different sub-systems that would be avoided if the
tables were in the same sub-system.
By the way, one DB2 sub-system will like to have as much of the machine
resources for itself as possible. By having more than one sub-system on the
same machine, the machine resources (cpu and memory) will have to bedivided
between the sub-systems as well as everything else that is running on that
machine. One of the advantages of a data-sharing system is that multiple
members running on different machines have even more machine resources for
the entire DB2 system.

If you are talking about databases in DB2 os/390 system, then it's a good
idea to minimize the number of tables per database. It will make things a
lot more convenient for dropping/creating indexes or doing alters or binds
simultaneously because of DBD locking. The fewer tables in a database, the
less of this kind of contention you will have.

Rick Creech
>From: "Bruzdzinski, Mike" <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: query involving 2 different DBs
>Date: Wed, 6 Oct 1999 10:55:58 -0400
>
>Assuming that you do not want to hard code the DB qualifier, consider using
>an ALIAS. This will keep your coding and BIND parameters to a minimum.
>
>-----Original Message-----
>From: Leonardo Kenji Shikida [mailto:[login to unmask email]
>Sent: Wednesday, October 06, 1999 11:48 AM
>To: [login to unmask email]
>Subject: query involving 2 different DBs
>
>
>I want to make a query involving 2 different DBs on the same DB2 machine.
>How do I do this ?
>Or it's better to put all tables in the same database ?
>
>thanks in advance
>
>K

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

Leonardo Kenji Shikida

Re: query involving 2 different DBs
(in response to Jorge Daniel Ortiz)
Jorge Daniel Ortiz wrote:

> For some reason we are getting dozens of messages from different senders, indicating that reply must be sent to your address. We would greatly appreciate that you do something to stop this.We do not want to be included in any list for any purposes whatsoever. This is an inconvenience that I am sure you do not wish to cause. Thank you for your help. Best wishes.

I would like to thank everybody who answered my question and I would invite any others that want to send their contribution directly to my personal email [login to unmask email] I am sorry if I am causing any incovenience.

K

Centro de Computos

Re: query involving 2 different DBs
(in response to Leonardo Kenji Shikida)
Hi K!
Well, I followed the thread since it started, I issued more or less the same question some two weeks ago and have no repplies, so I would sorry if any responses are posted only to you.
Please, don't exclude me !!!

Thanks in advance

Daniel
Red Robe Wizard from Palanthus

----------
Desde: Leonardo Kenji Shikida[SMTP:[login to unmask email]
Enviado el: Thursday, October 07, 1999 1:02 AM
Para: [login to unmask email]
Asunto: Re: query involving 2 different DBs

Jorge Daniel Ortiz wrote:

> For some reason we are getting dozens of messages from different senders, indicating that reply must be sent to your address. We would greatly appreciate that you do something to stop this.We do not want to be included in any list for any purposes whatsoever. This is an inconvenience that I am sure you do not wish to cause. Thank you for your help. Best wishes.

I would like to thank everybody who answered my question and I would invite any others that want to send their contribution directly to my personal email [login to unmask email] I am sorry if I am causing any incovenience.

K