Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent!!! Oracle and DB2 Connectivity

Re: Urgent!!! Oracle and DB2 Connectivity

From: Geoffrey Bray <gbray1_at_my-dejanews.com>
Date: Tue, 11 May 1999 20:16:13 GMT
Message-ID: <7ha369$ipg$1@nnrp1.deja.com>


When we checked about a year ago, their ODBC transparent gateway worked great and was ~15K. The price on their transparent gateway specifically for DB2 that ran on the mainframe was > 90K.

Geoffrey Bray

In article <7h9il7$pm7$1_at_plonk.apk.net>,   havoc_at_apk.net (Chris Petersen) wrote:
> Well, we solved a similar problem with DB2/400 using one of Oracle's
> Transparent Gateways. A pricely solution, but it makes your DB2 look
like
> another Oracle database to the outside, and allows you to do all kinds
of
> neat things, like creating snapshots, table links into the DB2 from
your
> Oracle, queries, etc. A very, very nice and clean solution from our
> experience. Be warned, this was a $18k product for DB2/400, so I
imagine
> it's not any better (and probably more expensive) on the S/390.
>
> dloader4 (arul_at_cheerful.com) wrote:
> : I have Oracle 8.04 running on HP-UX. I need to access certain tables
on the
> : DB2 running on S/390 from Oracle. A user running reports needs to
get
> : information from both Oracle and DB2 tables. Once again Oracle need
to read
> : certain tables from DB2.
> :
> : Has some one worked on similar issues? How can this be achieved? Can
a link
> : be created? and if so how ? What is the best way to have this
transparent
> : to the user ?
> :
> : Any help would be most welcome.
> :
>
> --
> Chris Petersen
> Systems Engineer
> Unigraphics Solutions Inc. Industry Services, MidAmerica
Region
> Email: petersen_at_ugsolutions.com Voice Mail: (800)
388-8038 #52222
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 11 1999 - 15:16:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US