Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

can DB2 and Oracle talk?

0 views
Skip to first unread message

Ren Watanabe

unread,
Jun 16, 1997, 3:00:00 AM6/16/97
to

What is the best way to let an Oracle database (on a Sun Ultra 2) talk
to a DB2 database (on an AS/400)?

Any suggestions would be appreciated.

- Ren Watanabe
re...@opim.wharton.upenn.edu

Bob Eisner

unread,
Jun 16, 1997, 3:00:00 AM6/16/97
to Ren Watanabe

Hi Ren,

Oracle Transparent Gateway for DRDA is the only way.

The Transparent Gateway for DRDA runs on MVS only!

Bob

Dave Dargo

unread,
Jun 17, 1997, 3:00:00 AM6/17/97
to

Bob Eisner wrote in article <33A57E...@trifox.com>...

There are two methods to get an Oracle database to speak to DB2/400:

The Oracle Transparent Gateway for DB2/400 which runs on the AS/400
machine
The Oracle Transparent Gateway for DRDA which runs on a number of machines
including Sun Solaris

The Oracle Access Manager for AS/400 allows AS/400 applications to
communicate with Oracle databases on any platform

All of these products provide distributed transaction capabilities with
two-phase commit between Oracle and DB2/400.

The confusion may be caused by the Oracle Transparent Gateway for DB2 which
runs on MVS and provides similar functionality to those products listed
above for DB2/MVS.

Dave
(dda...@us.oracle.com)

ANthony M. Connor

unread,
Jun 22, 1997, 3:00:00 AM6/22/97
to

Hi, Check with IBM to see if DataJoiner will solve you problem. Ask if
DJ will run on AS/400. I know it runs on AIX. DJ allows DB2 and Oracle
to share data both directions.
Mi...@amc.batnet.com

Kirk Bradley

unread,
Jun 27, 1997, 3:00:00 AM6/27/97
to

right.. the transparent gateway for DRDA specifically does NOT
run on MVS

solaris as/400

1) TG4DRDA -->> normal IBM provided DRDA server (free!)

the -->> is SNA (LU6.2) for our current release and it's the
DRDA protocol on the wire

2) Oracle database -->> TG4DB2400 (an Oracle product)

the -->> is tcp/ip or SNA and the protocol on the wire is SQL*NET.

You can buy the TG4DB2400 and get to the data from ANY box that runs
an Oracle kernel (all 90+ of them) and you have SQL*Net for TCP/IP or
SNA. If you want to use the DRDA gateway you need SNA and we only support
SOlaris, AIX and HP (maybe NT too check with your salesman). This is mainly
because SNA isn't supported very well on most Unix systems.


In article <5o5evd$ona$1...@inet16.us.oracle.com>, "Dave Dargo"

0 new messages