Re: DB2/400 <--> Oracle Questions

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Sun, 16 Jul 2006 06:41:26 -0400
Message-ID: <4hujdfF1aqeeU1@individual.net>

René H. Hartman wrote:

> "Charles Wilt" <cwilt_at_meaa.mea.com> schreef in bericht

>> IBM Provides one product:
>>
>> 1) DB2 Information Integrator (formally DataJoiner)
>> --runs on a (non-iSeries) host system
>> --Handles DB2/400 --> Oracle access
>> --uses TCP/IP

Couple of comments:
* The product name is Websphere Information Integrator * The product uses DRDA to talk to DB2 iSeries and the regular Oracle Client to connect to Oracle (although it can use ODBC as well).

Do you do cross product joins? Like joining a table from Oracle with one   from DB2 iSeries? These sorts of things are WS II's strength since it knows the capabilities of the target databases and does distributed optimization.

Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Received on Sun Jul 16 2006 - 05:41:26 CDT