Need help with SQL - connect to multiple data source in DB2 AIX

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

thiamwah@yahoo.com - 25 Feb 2005 06:51 GMT

Hi,

I have a SQL statement that access to one database (DB2) i.e.

SELECT
DB1.TABLE1.TABLE1_ID,
DB1.TABLE1.FIELD_A,
DB1.TABLE2.FIELD_1,
DB1.TABLE2.FIELD_2,

FROM
DB1.TABLE1 LEFT OUTER JOIN DB1.TABLE2 ON
DB1.TABLE2.TABLE1_ID=DB1.TABLE1.TABLE1_ID
WHERE
(
DB1.TABLE2.TABLE1_ID = 123456
AND DB1.TABLE2.MSR_PRD_ID = 'AAAAAA'
)

Table2 is now going to be moved to another database DB2 residing in
another server. How can I connect to two database (DB1 & DB2) now for
the SQL Statement? Does DB2 on AIX support this?

Pls help! Thanks

Reply to this Message

Mark A - 25 Feb 2005 07:18 GMT

> Hi,
>
[quoted text clipped - 20 lines]
>
> Pls help! Thanks

You need to set up DB2 Federated Support and refer to the table in the other
database via a nickname. This was discussed in detail recently. Check Google
Groups archive.

Reply to this Message

thiamwah@yahoo.com - 25 Feb 2005 09:26 GMT

Is there any online PDFs or references that can assist a DBA in setting
up a Federated Database on AIX? Does this require additional licensing
i.e. $$$?

Pls advice. Thanks

Reply to this Message

Mark A - 25 Feb 2005 18:03 GMT

> Is there any online PDFs or references that can assist a DBA in setting
> up a Federated Database on AIX? Does this require additional licensing
> i.e. $$$?
>
> Pls advice. Thanks

No additional licensing if all databases are on DB2 for AIX. A recent thread
had the syntax needed. Check Google Groups archives

Reply to this Message

Larry - 26 Feb 2005 14:30 GMT

Go back and google the recent thread on this. Doc was discussed. Go here:

http://www-306.ibm.com/software/data/db2/udb/support/manualsv8.html

and look under "DB2 Information Integrator". No additional licensing is
required if you stay within the DB2 family in terms of your access.

Larry Edelstein

> Is there any online PDFs or references that can assist a DBA in setting
> up a Federated Database on AIX? Does this require additional licensing
> i.e. $$$?
>
> Pls advice. Thanks

Reply to this Message