Re: Oracle Transparent Gateway

We have used the Oracle Transparent Gateway for DRDA (mainframe DB2) for 5 years.

The gateway is only accessable by an Oracle database -- client tools must connect to an Oracle database, not directly to the gateway. This is not a problem, but might be a surprise.

The gateway does not have an 'instance'. There is no SGA. There are no background processes. Starting the gateway means starting the listener. For each database connection to DB2 through the gataway, the listener spawns a process.

Database connections to the gateway are via normal data base links. We use RACF userid and password security for DB2. We require every DB2 user to use a personal userid and password. This requires the userid and passwords to be identical in the Oracle database vs RACF.

Some client tools cannot deal with the three-part address using data base links. I have created, within an Oracle database, views of the DB2 tables. This makes the DB2 tables (via the views) visible to the tools.

Transparency means you code Oracle SQL as normal. The gateway takes care of most dialect differences.

Performance is good. However, some dumb things can occur. For example, the join of two DB2 tables can cause the entire two tables to be transmitted over the network and then Oracle does the join! Create a join view on DB2 and select from that.

That's it, off the top. If you have detailed questions, let me know.

Alessandro Feltrin wrote:

> Hi all.
> Does anyone could give me more informations about Oracle Transparent
> Gateway?
> My need are to move a data base from Oracle to DB2 OS/390 and continue
> to access it through a web application that works with many Perl scripts
> (and OraPerl calls).
>
> I will appreciate any help
>
> Thanks in advance.
>
> Alessandro
>
> -- Rimuovere NOSPAN dall'indirizzo
>
> \|/
> (@ @)
> ---------------------oOO--(_)--OOo----------------
> Alessandro Feltrin - C&M S.p.a. Tel. 011-7767877
> Torino - C.so Svizzera, 185
> E-Mail afeltrin_at_c-m.it
Received on Fri Mar 12 1999 - 00:00:00 CST