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

How can I make a table on DB2-Mainframe appear as Oracle view.

18 views
Skip to first unread message

James Sim

unread,
Apr 17, 1998, 3:00:00 AM4/17/98
to

Subject pretty much states the challenge. Target table is 1.5M rows.

What do I need for middle-ware? Oracle is 7.3.3 or 8.x on hp-ux 10.2 db2
is also of recent vintage. What additional products will I need on each
side?

Thanks in advance - Jim Sim


David Sisk

unread,
Apr 17, 1998, 3:00:00 AM4/17/98
to

One product that would work is Oracle Transparent Gateway for DB2/MVS. This
is a listener process that runs on an MVS mainframe, and makes the mainframe
DB2 database look like another Oracle database to Oracle. You can create
dblinks that point to the mainframe, so (obviously) you could easily create
a view that is a "SELECT ... FROM table_name@DB2nnn". We use OTG for
DB2/400, but I'm reasonably sure that OTG for DB2/MVS works pretty much the
same.

Good luck,
Dave


James Sim wrote in message <35378E5B...@juno.com>...

John P. Higgins

unread,
Apr 17, 1998, 3:00:00 AM4/17/98
to

There is an additional Oracle gateway available:
Oracle Transparent Gateway for DRDA

DRDA is IBM's native remote access method to DB2. In this case the
listener and gateway (pseudo Oracle server) runs on an an IBM AIX box
and uses LU6.2 to access DDF.

We have used this for several years.

Connor McDonald

unread,
Apr 18, 1998, 3:00:00 AM4/18/98
to

David Sisk wrote:
>
> One product that would work is Oracle Transparent Gateway for DB2/MVS. This
> is a listener process that runs on an MVS mainframe, and makes the mainframe
> DB2 database look like another Oracle database to Oracle. You can create
> dblinks that point to the mainframe, so (obviously) you could easily create
> a view that is a "SELECT ... FROM table_name@DB2nnn". We use OTG for
> DB2/400, but I'm reasonably sure that OTG for DB2/MVS works pretty much the
> same.
>
> Good luck,
> Dave
>
> James Sim wrote in message <35378E5B...@juno.com>...
> >Subject pretty much states the challenge. Target table is 1.5M rows.
> >
> >What do I need for middle-ware? Oracle is 7.3.3 or 8.x on hp-ux 10.2 db2
> >is also of recent vintage. What additional products will I need on each
> >side?
> >
> >Thanks in advance - Jim Sim
> >

We use Transparent for DB2/MVS...(the MVS box runs TCP/IP to facilitate
this).

Seems to work fine...a little slow but this is more due to our network I
would suspect...

Cheers

--
==========================================
Connor McDonald
BHP Information Technology
Perth, Western Australia
"These views mine not BHP..etc etc"

"The only difference between me and a madman is that I am not mad."

Armando Marcotulli

unread,
Apr 20, 1998, 3:00:00 AM4/20/98
to

James Sim wrote:

> Subject pretty much states the challenge. Target table is 1.5M rows.
>
> What do I need for middle-ware? Oracle is 7.3.3 or 8.x on hp-ux 10.2
> db2
> is also of recent vintage. What additional products will I need on
> each
> side?
>
> Thanks in advance - Jim Sim

You can use Oracle Transparent Gateway for DB2 on mainframe.
I suggest you to use TCP protocol instead of APPC.

0 new messages