Re: Oracle 7.3 AIX - CICS/DB2 Online connection

We use Oracle's Transparent Gateway for DRDA to access our DB2 databases from Oracle.

The "transparent" means that a user / programmer accesses the DB2 tables as though they are Oracle tables via a database link. The database link is actually pointed to the gateway. The gateway runs on an AIX machine with SNA services installed. The gateway connects over LU6.2 to DB2's DDF.

There is no software to install on the MVS side. There is no software to install on the database. There is no software to install on client machines beyond the SQL*Net 2.x that is needed to access the Oracle database.

The gateway may be installed on the same AIX machine as the database, or on a separate machine.

Clients (SQL*Plus, MS Access, Forms, ....) CAN NOT access the gateway. The gateway can only be accessed via a database link defined in an Oracle database. This is not a problem to us.

Jeroen Oosterveld wrote:

> Hello,
>
> Can anyone tell me how I should create a connection between an Oracle 7.3
> database on AIX (RS/6000) server and an CICS/DB2 application on an IBM
> Mainframe (MVS).
>
> It should be a nice, simple and extreemely stable connection like APPC or MQ
> and NOT a tricky one like 3270-emulation on AIX and "screen scraping".
>
> My plan is to create a stored procedure in the Oracle 7.3 database, which
> calls (by using an MQ or APPC application on AIX) an application on the
> mainframe and returns some values out of the DB2-database.
>
> I'm only experienced in Oracle and I don't know anything about connections
> between an RS/6000 and IBM mainframe.
>
> So in short:
> - Which application do I need on AIX?
> - Which application do I need on MVS?
> - Can I call an AIX-application from a strored procedure?
> - Can you tell me your experience with this all?
> Thanks a lot and greetings,
>
> Jeroen Oosterveld
> Postbank NV
> Holland
Received on Thu May 21 1998 - 21:12:37 CDT