Connect DB2 to oracle

Jeff Frazier

Connect DB2 to oracle
Hi All,

db2 v8 nfm, z/os v1.7
I have been asked can we connect an oracle database to db2 and go from db2
to oracle also.
What do we need and how is it done? Any information will be helpful.

TIA
Jeff

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Brian Bear

Re: Connect DB2 to oracle
(in response to Jeff Frazier)
We use Oracle Access Manager on the mainframe to run mainframe cobol
programs connecting to Oracle residing in AIX.

We use Oracle Transaction gateway for DB2, also running on the mainframe
as a started task, to run programs residing on AIX to connect mainframe
DB2.


Both are products that Oracle will no longer be developing going
forward. Oracle has discontinued development of all their products on
the mainframe. The replacement for Oracle Transaction gateway is Oracle
Gateway for DRDA which runs on unix to enable access to DB2 data from
Oracle. I don't know of a replacement for Access Manager enabling access
to Open systems Oracle data from the mainframe.





________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Jeff Frazier
Sent: Monday, January 26, 2009 10:54 AM
To: [login to unmask email]
Subject: [DB2-L] Connect DB2 to oracle




Hi All,

db2 v8 nfm, z/os v1.7
I have been asked can we connect an oracle database to db2 and go from
db2 to oracle also.
What do we need and how is it done? Any information will be helpful.

TIA
Jeff

________________________________

IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia
< http://idug.org/lsAU >

IDUG.org < http://www.idug.org > was recently updated requiring members
to use a new password. You should have gotten an e-mail with the
temporary password assigned to your account. Please log in and update
your member profile. If you are not already an IDUG.org member, please
register here. < http://www.idug.org/component/juser/register.html >


______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Kim May

Re: Connect DB2 to oracle
(in response to Brian Bear)
Jeff,



Oracle has a product called the Transparent Gateway for Oracle applications
that enables the access of DB2 data from Oracle.



IBM's similar federation product has had many names - DataJoiner,
Information Integrator, and currently Infosphere Federation Server. It does
the same thing from the DB2 database, federating/incorporating Oracle data.



We've worked with these products quite a bit - if we can give you a hand
please let me know.



Kim May

The Fillmore Group





From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Jeff Frazier
Sent: Monday, January 26, 2009 10:54 AM
To: [login to unmask email]
Subject: [DB2-L] Connect DB2 to oracle




Hi All,

db2 v8 nfm, z/os v1.7
I have been asked can we connect an oracle database to db2 and go from db2
to oracle also.
What do we need and how is it done? Any information will be helpful.

TIA
Jeff

_____

< http://idug.org/lsAU > IDUG 2009 - Australasia * 18-20 March * Melbourne,
Australia

< http://www.idug.org > IDUG.org was recently updated requiring members to
use a new password. You should have gotten an e-mail with the temporary
password assigned to your account. Please log in and update your member
profile. If you are not already an IDUG.org member, please register here.
< http://www.idug.org/component/juser/register.html >


______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Jeff Frazier

Re: Connect DB2 to oracle
(in response to Kim May)
Kim,
Thank you for info.
so i would need both of these products to access data from either db2 to
oracle or oracle to db2? Anyway I go i am going to need a product to
access data between db2 and oracle?
Jeff



Kimberly May <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/26/2009 01:25 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] Connect DB2 to oracle






Jeff,

Oracle has a product called the Transparent Gateway for Oracle
applications that enables the access of DB2 data from Oracle.

IBM’s similar federation product has had many names – DataJoiner,
Information Integrator, and currently Infosphere Federation Server. It
does the same thing from the DB2 database, federating/incorporating Oracle
data.

We’ve worked with these products quite a bit – if we can give you a hand
please let me know.

Kim May
The Fillmore Group


From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Jeff Frazier
Sent: Monday, January 26, 2009 10:54 AM
To: [login to unmask email]
Subject: [DB2-L] Connect DB2 to oracle


Hi All,

db2 v8 nfm, z/os v1.7
I have been asked can we connect an oracle database to db2 and go from db2
to oracle also.
What do we need and how is it done? Any information will be helpful.

TIA
Jeff

IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia
IDUG.org was recently updated requiring members to use a new password. You
should have gotten an e-mail with the temporary password assigned to your
account. Please log in and update your member profile. If you are not
already an IDUG.org member, please register here.


IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia
IDUG.org was recently updated requiring members to use a new password. You
should have gotten an e-mail with the temporary password assigned to your
account. Please log in and update your member profile. If you are not
already an IDUG.org member, please register here.

Kim May

Re: Connect DB2 to oracle
(in response to Jeff Frazier)
Jeff,



Regardless of the direction you will need something…if you can figure out which direction you really need the data to flow you may be able to simplify and just use one…



Kim



From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Jeff Frazier
Sent: Monday, January 26, 2009 2:11 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Connect DB2 to oracle




Kim,
Thank you for info.
so i would need both of these products to access data from either db2 to oracle or oracle to db2? Anyway I go i am going to need a product to access data between db2 and oracle?
Jeff




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

01/26/2009 01:25 PM


Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To

[login to unmask email]


cc



Subject

Re: [DB2-L] Connect DB2 to oracle








Jeff,

Oracle has a product called the Transparent Gateway for Oracle applications that enables the access of DB2 data from Oracle.

IBM’s similar federation product has had many names – DataJoiner, Information Integrator, and currently Infosphere Federation Server. It does the same thing from the DB2 database, federating/incorporating Oracle data.

We’ve worked with these products quite a bit – if we can give you a hand please let me know.

Kim May
The Fillmore Group


From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Jeff Frazier
Sent: Monday, January 26, 2009 10:54 AM
To: [login to unmask email]
Subject: [DB2-L] Connect DB2 to oracle


Hi All,

db2 v8 nfm, z/os v1.7
I have been asked can we connect an oracle database to db2 and go from db2 to oracle also.
What do we need and how is it done? Any information will be helpful.

TIA
Jeff



_____

< http://idug.org/lsAU > IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia

<http://www.idug.org/> IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please < http://www.idug.org/component/juser/register.html > register here.



_____

< http://idug.org/lsAU > IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia

<http://www.idug.org/> IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please < http://www.idug.org/component/juser/register.html > register here.


______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html