The Oracle Database Gateway for APPC provides Oracle applications running anywhere on your network with procedural access to non-Oracle transactions, databases, and file systems on the mainframe. No Oracle code is required on the target mainframe system.
The Oracle Procedural Gateway uses Remote Procedural Call (RPC) processing and can access any system connected to your enterprise-wide Systems Network Architecture (SNA) network. This allows you to leverage your investment in existing transactions, while providing you with the ability to move toward new distributed environments.
The Oracle Database Gateway for APPC can request the execution of existing transactions in many different systems. CICS TS, IMS TM, and other transactions can access and update a variety of databases and file systems such as IMS, DB2, ADABAS, or VSAM files. As a result, you can use existing rules that enforce data integrity in your mainframe operation. Mainframe transactions can also be executed to perform complex calculations or launch processes on peripheral devices.
Oracle's commitment to industry standards minimizes and protects your application integration investment. Unlike other vendors' gateways that require you to use proprietary application programming interfaces (APIs), the Oracle Database Gateway for APPC uses the X/Open Common Programming Interface for Communication (CPI-C). This allows the same mainframe transaction to be used - unchanged - by both Oracle and non-Oracle applications. Through its use of the APPC facility, the Oracle Procedural Gateway allows you to maintain independence and portability, and simplifies support of your existing information processing systems.
Unlike other vendors' mainframe solutions that run on the mainframe where processing is expensive, the Oracle Procedural Gateway runs on your choice of leading UNIX platforms or Microsoft Windows - with no code on the mainframe. Thus, your mainframe resources are free to perform traditional business operations. With Oracle, expanding your client/server systems does not mean you will also have to expand your mainframe investment.
The Oracle Procedural Gateway also eliminates the need for multiple copies of a gateway. With the Oracle Database Gateway for APPC, a single software license of the Gateway allows access to multiple transaction processing monitors - and multiple mainframe platforms. For example, a single gateway allows you to reach CICS transactions on your corporate z/OS system, as well as iSeries transactions at a local sales office.
The Oracle Database Gateway for APPC leverages the strength of the industry-leading Oracle Database and PL/SQL technologies, Oracle customers don't need to learn a new API to get to their mainframe transactions. The tight integration between the Oracle Database and the Oracle Procedural Gateway also enables you to take advantage of ongoing improvements in Oracle's leading server technology.
The Oracle Database Gateway for APPC, in conjunction with the Oracle database, provides distributed transaction capabilities such that APPC transactions and Oracle Database updates can be performed in a coordinated fashion. The Oracle Procedural Gateway distributed transaction support maintains application integrity while providing access to non-Oracle transactions.
Communication with the target system is transparent to the client applications. The Oracle Procedural Gateway translates Oracle database stored procedure calls into the required remote procedure calls (RPCs). Non-Oracle remote procedures are executed as if they were local Oracle database stored procedures. The Oracle database and Oracle Procedural Gateway distribution mechanisms work together to shield the application from having to know the location of the transaction.
Because the Oracle Database Gateway for APPC runs on a non-mainframe server, it does not add any additional system overhead to the mainframe. Thus, your mainframe transaction performance will not be affected by traditional gateway overhead, such as that resulting from datatype conversions. Also, key to a high-performance OLTP implementation is the ability to minimize network calls. The Oracle Procedural Gateway minimizes network overhead by exploiting the capabilities of APPC/LU6.2. For example, the Gateway can return multiple records using as few as two network calls. The Oracle Database Gateway for APPC can also request the execution of programs that use static SQL against a DB2 database. Static (i.e., precompiled) SQL statements enhance DB2 security and performance.