RE: Oracle Transparent Gateway

Peter,

    I used it briefly a couple of years ago. It certainly works well enough. The problem I had related to password administration. When you set it up in Oracle, you need to provide the password to an id on the OS/390 system. Our OS/390 system requires us to change passwords every 30 days. This meant we had to make a corresponding change to the database link in Oracle. We are no longer using the product.

Bill Carle
AT&T
Database Administrator
816-995-3922
wcarle_at_att.com

 -----Original Message-----
Sent: Wednesday, February 06, 2002 1:28 PM

To:     Multiple recipients of list ORACLE-L
Subject:        Oracle Transparent Gateway

Thanks to the people who tipped me off to this product.
>From the marketing fluff on Technet, it looks like this
will do what I want it to do (i.e. extract data from DB2 on O/S390 into Oracle 8.1.x on UNIX).

If anyone on the list has actual experience doing this I would be interested in your feedback.

thanks,

Peter Schauss
Northrop Grumman Corporation
516-346-3148
schaupe_at_mail.northgrum.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Schauss, Peter
  INET: SCHAUPE_at_mail.northgrum.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carle, William T (Bill), ALINF
  INET: wcarle_at_att.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).