Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Related Documents

Conventions

Documentation Accessibility

Accessibility of Code Examples in Documentation

1 Release Information

Product Set

Changes and Enhancements, Release 9.0.1.0.1

Enhancements

Changes

Known Restrictions

2 Introduction to Oracle Procedural Gateway® for APPC

Overview

Features

Terms

Architecture

Implementation

Starting the Gateway

Communication

Remote Procedural Call Functions

Remote Transaction Initiation

Data Exchange

Remote Transaction Termination

Transaction Types

3 System Requirements

Hardware Requirements

Processor

Memory

Network Attachment

CD-ROM Drive

Disk Space

Software Requirements

Operating System

Communications

Oracle Integrating Server

File Transfer

OLTP

CICS/MVS and CICS/ESA

CICS/VSE

IDMS-DC

IMS/TM

APPC/MVS

Oracle Networking Products

Documentation Requirements

4 Installing and Configuring the Gateway

Before You Begin

Planning to Upgrade the Gateway

Upgrade Considerations

Restoration

Performing Pre-Upgrade Procedures

Performing Pre-Installation Procedures

Installing the Gateway Software

Installation Steps

Step 1: Login as DBA and create login user ID

Step 2: Create the product installation directory

Step 3: Set the ORACLE_HOME environmental variable

Step 4: Verify the ORACLE_TERM environmental variable

Step 5: Mount the CD-ROM

Step 6: Start the Oracle Universal Installer

Step 7: Step through the Oracle Universal Installer

Configuring the Oracle Procedural Gateway for APPC

Pre-Configuration Steps

Oracle Server Coexistent with Gateway Installation/Upgrade

Stand-alone Gateway Installation/Upgrade

Configuring the Oracle Integrating Server for First-Time Installations

Upgrading the Oracle Integrating Server from Previous Releases

First-Time Installation and Upgrade Configuration Steps

Optional Configuration Steps to Permit Multiple Users

AIX Configuration

Configuring the SNA server

Configuring the Gateway

Configuring Your Network

Configuring Two-Phase Commit

Configuring Commit-Confirm

Configuring the OLTP

Configuring CICS/ESA

Configuring IDMS-DC MVS

Configuring IMS/TM

Configuring APPC/MVS

Verifying the Installation

Verifying the Gateway Installation

Verifying the OLTP Configuration

CICS Verification

IDMS-DC Verification

IMS/TM Verification

APPC/MVS Verification

Performing Post-Installation Procedures

Installing Sample Applications

Accessing the Gateway from Other Oracle Servers

Accessing Other OLTPs from the Oracle Integrating Server

De-installing Your Oracle Procedural Gateway for APPC

5 Security Requirements

Overview of Security Requirements

Authenticating Application Logons

Defining and Controlling Database Links

Link Accessibility

Links and CONNECT Clauses

Using SNA Security Validation

Specifying SNA Conversation Security

SNA Security Option SECURITY=NONE

SNA Security Option SECURITY=PROGRAM

SNA Security Option SECURITY=SAME

Processing Inbound Connections

6 SNA Configuration

Independent Versus Dependent LUs

Creating SNA Profiles for the Gateway

Profile Types

SNA Server Profiles

SNA Node Profile

Link Station Profile

Mode Profile

Local LU Profile

Partner LU Profile

Partner LU Location Profile

Side Information Profile

Transaction Program Name Profile

Activating Profiles

7 Implementing Two-Phase Commit

Introduction

Supported OLTPs (Online Transaction Processors)

Two-Phase Commit Architecture

Required Components

Roles of the Components of Two-Phase Commit

Interactions

Two-Phase Commit Flow

Gateway Server and RRM LU6.2 Log Tables

Pre-Configuration Tasks

Choose a Dedicated Local LU

Set Up RRM Execution Group

Configuring Two-Phase Commit

Configuring the Oracle Logging Server

Configuring the Gateway Initialization Parameters

Configuring the RRM Initialization Parameters

Configuring the SNA Server

Configuring CICS/ESA

Post-Configuration Tasks

Set Up RRM Startup and Shutdown Procedures

Customizing the rrmstart script

RRM Recovery

RRM issued message PGA-21215

RRM issued message PGA-21218

Two-Phase Commit With CICS/ESA

Application Design Requirements

Manual Recovery of In-Doubt Transactions

Logging Two-Phase Commit Activity from CICS

PGALUWID Subroutine

Periodic Log Cleanup

8 Migration and Coexistence with Existing Gateways

Migrating An Existing Gateway Instance to New Release

Step 1: Install the new Release

Step 2: Transferring initsid.ora gateway initialization file parameters

Backout Considerations When Migrating to New Releases

New and Changed Parameters: Migrating from Version 4 to Release 9i of the Gateways

New Parameter Added When Migrating from Version 8 or Earlier to Oracle 9i Gateway

A Gateway Initialization Parameters

Gateway Initialization Parameter File

PGA Parameters

PGA_CAPABILITY Parameter Considerations

PGA_CONFIRM Parameter Considerations

Sample pg4hoa1.sh File

Sample initPGA.ora File

Sample rrmstart Script

B AIX - Specific Gateway Messages

Oracle Procedural Gateway for APPC Server Messages

Oracle Procedural Gateway for APPC Resource Recovery Manager Messages

C Summary of Changes in Previous Versions

Changes and Enhancements in Previous Versions

Release 8.0.4.1.0

Release 4.0.1.1.0

Release 4.0.0.1.0

Release 3.4.0.1.0

Release 3.3.1.0.4

Release 3.3.0.0.3

Release 3.2.0

Corrected Problems in Previous Versions

Release 8.0.4.1.0

Release 4.0.1.1.0

Release 4.0.0.1.0

Release 3.4.0.1.0

Release 3.3.0.0.3

Release 3.2.0

Known Problems in Previous Versions

Release 8.0.4.1.0

Release 4.0.1.1.0

Index