Oracle to DB2 UDB Connection

Michael McKinney

Oracle to DB2 UDB Connection
All,

Any thoughts on or experience related to middleware software to allow
Oracle to 'speak to' DB2 UDB ?

Oracle is running in a SCO Unix environment. Still waiting for an answer
on the server type. Platform where DB2 UDB will be running has not yet
been determined.

Thanks,

Mike



Jeremy Schleicher

Re: Oracle to DB2 UDB Connection
(in response to Michael McKinney)
Not sure about oracle to DB2 but I believe that db2 connect to talk to
orcale and I know that if your db2 database is a federated database you can
talk directly to oracle



From: Michael McKinney <[login to unmask email]>@RYCI.COM on 01/03/2002 11:18 AM

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

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: Oracle to DB2 UDB Connection


All,

Any thoughts on or experience related to middleware software to allow
Oracle to 'speak to' DB2 UDB ?

Oracle is running in a SCO Unix environment. Still waiting for an answer
on the server type. Platform where DB2 UDB will be running has not yet
been determined.

Thanks,

Mike








Michael McCarthy

Re: Oracle to DB2 UDB Connection
(in response to Jeremy Schleicher)
It's actually DB2 Relational Connect that let's you do this.

-Mike.





Jeremy Schleicher <[login to unmask email]>@RYCI.COM> on 01/03/2002
01:01:42 PM

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

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: Re: [DB2-L] Oracle to DB2 UDB Connection


Not sure about oracle to DB2 but I believe that db2 connect to talk to
orcale and I know that if your db2 database is a federated database you can
talk directly to oracle



From: Michael McKinney <[login to unmask email]>@RYCI.COM on 01/03/2002 11:18 AM

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

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: Oracle to DB2 UDB Connection


All,

Any thoughts on or experience related to middleware software to allow
Oracle to 'speak to' DB2 UDB ?

Oracle is running in a SCO Unix environment. Still waiting for an answer
on the server type. Platform where DB2 UDB will be running has not yet
been determined.

Thanks,

Mike













John McKown

Re: Oracle to DB2 UDB Connection
(in response to Michael McCarthy)
Try reading: http://www-4.ibm.com/software/data/datajoiner/index.html to see
if DB2 DataJoiner will do what you want.

----------------------------------------------------------------------
John McKown
HealthAxis

All opinions are my own and are not the opinions of my employer.

Unsolicited telephone calls from vendors are NOT appreciated and tend to
upset my management.

Divine intervention---What happens when God steps in and does something for
the good of mankind...like ending Ronald Reagan's movie career.


> -----Original Message-----
> From: Michael McKinney [SMTP:[login to unmask email]
> Sent: Thursday, January 03, 2002 11:19 AM
> To: [login to unmask email]
> Subject: Oracle to DB2 UDB Connection
>
> All,
>
> Any thoughts on or experience related to middleware software to allow
> Oracle to 'speak to' DB2 UDB ?
>
> Oracle is running in a SCO Unix environment. Still waiting for an answer
> on the server type. Platform where DB2 UDB will be running has not yet
> been determined.
>
> Thanks,
>
> Mike
>
>
>
>
>



Gary Jobe

Re: Oracle to DB2 UDB Connection
(in response to John McKown)
We are using Oracle Transparent Gateway for DRDA. It has worked fairly
well for DB2v6, but we are having some problems with it on DB2v7 on 390.



RIBEIRO Paulo Jorge

Re: Oracle to DB2 UDB Connection
(in response to Gary Jobe)
I suppose this answer is not tottaly correct. When you talk about connect I
think you want to say Relational Connect. As far as I know, Relational
Connect only supports reading data from other systems, and not writing data
to other systems. To use federated databases with Oracle I think you have to
use DataJoiner.
Maybe someone more experienced can confirm my ideas.

Paulo

-----Original Message-----
From: Jeremy Schleicher [mailto:[login to unmask email]
Sent: quinta-feira, 3 de Janeiro de 2002 18:02
To: [login to unmask email]
Subject: Re: Oracle to DB2 UDB Connection


Not sure about oracle to DB2 but I believe that db2 connect to talk to
orcale and I know that if your db2 database is a federated database you can
talk directly to oracle



From: Michael McKinney <[login to unmask email]>@RYCI.COM on 01/03/2002 11:18 AM

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

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: Oracle to DB2 UDB Connection


All,

Any thoughts on or experience related to middleware software to allow
Oracle to 'speak to' DB2 UDB ?

Oracle is running in a SCO Unix environment. Still waiting for an answer
on the server type. Platform where DB2 UDB will be running has not yet
been determined.

Thanks,

Mike













John McKown

Re: Oracle to DB2 UDB Connection
(in response to RIBEIRO Paulo Jorge)
Paulo,
The IBM web site on Relational Connect at
http://www-4.ibm.com/software/data/db2/relconnect/index.html does indeed
indicate that the access is READ ONLY.

----------------------------------------------------------------------
John McKown
HealthAxis

All opinions are my own and are not the opinions of my employer.

Unsolicited telephone calls from vendors are NOT appreciated and tend to
upset my management.

Divine intervention---What happens when God steps in and does something for
the good of mankind...like ending Ronald Reagan's movie career.


> -----Original Message-----
> From: RIBEIRO Paulo Jorge [SMTP:[login to unmask email]
> Sent: Thursday, January 03, 2002 12:27 PM
> To: [login to unmask email]
> Subject: Re: Oracle to DB2 UDB Connection
>
> I suppose this answer is not tottaly correct. When you talk about connect
> I
> think you want to say Relational Connect. As far as I know, Relational
> Connect only supports reading data from other systems, and not writing
> data
> to other systems. To use federated databases with Oracle I think you have
> to
> use DataJoiner.
> Maybe someone more experienced can confirm my ideas.
>
> Paulo
>



Jeremy Schleicher

Re: Oracle to DB2 UDB Connection
(in response to John McKown)
with udb version 7, by making your database federated, you don't need data
joiner. However as of yet you can only select data, not write data. That
and the method it uses to join tables is really bad. We looked at it and
determined that what we were using was far superior



From: RIBEIRO Paulo Jorge <[login to unmask email]>@RYCI.COM on 01/03/2002
12:27 PM

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

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: Re: Oracle to DB2 UDB Connection


I suppose this answer is not tottaly correct. When you talk about connect I
think you want to say Relational Connect. As far as I know, Relational
Connect only supports reading data from other systems, and not writing data
to other systems. To use federated databases with Oracle I think you have
to
use DataJoiner.
Maybe someone more experienced can confirm my ideas.

Paulo

-----Original Message-----
From: Jeremy Schleicher [mailto:[login to unmask email]
Sent: quinta-feira, 3 de Janeiro de 2002 18:02
To: [login to unmask email]
Subject: Re: Oracle to DB2 UDB Connection


Not sure about oracle to DB2 but I believe that db2 connect to talk to
orcale and I know that if your db2 database is a federated database you can
talk directly to oracle



From: Michael McKinney <[login to unmask email]>@RYCI.COM on 01/03/2002 11:18 AM

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

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: Oracle to DB2 UDB Connection


All,

Any thoughts on or experience related to middleware software to allow
Oracle to 'speak to' DB2 UDB ?

Oracle is running in a SCO Unix environment. Still waiting for an answer
on the server type. Platform where DB2 UDB will be running has not yet
been determined.

Thanks,

Mike








the










Burgess Evans

Re: Oracle to DB2 UDB Connection
(in response to Jeremy Schleicher)
Hi Gary,

We are also using Oracle Transparent Gateway.

We just finished migrating our DB2 test subsystem to DB2V7 on OS/390.

Would you mind sharing some of the problems you noticed with the Oracle
Gateway either on-line or off-line?

Thank you,
Burgess Evans, DBA

>>> [login to unmask email] 01/03/02 01:23PM >>>
We are using Oracle Transparent Gateway for DRDA. It has worked
fairly
well for DB2v6, but we are having some problems with it on DB2v7 on
390.



visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the
list can