Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Related Documents
• Conventions
• Command Syntax

1 Introduction to Oracle Database Gateway for APPC

• Overview of the Gateway
• Features of the Gateway
• Terms
• Architecture of the Gateway
• Implementation of the Gateway
• Communication With the Gateway
• RPC Functions
  • Description of RPC Functions
    • Remote Transaction Initiation
    • Data Exchange
    • Remote Transaction Termination
• Transaction Types for Gateway Using SNA
• Transaction Types for Gateway Using TCP/IP

2 Release Information

• Product Set
• Changes and Enhancements
  • Gateway Password Encryption Tool
  • Partial IPv6 Support
• Known Restrictions
  • Known Restrictions for the Gateway
  • Known Restrictions for PGAU

3 System Requirements

• Hardware Requirements
  • Network Attachment Requirements
• Software Requirements
  • Operating System Requirements
  • Communication Protocol Requirements
  • Oracle Database Requirements
  • Oracle Networking Product Requirements
  • IBM Mainframe Requirements

4 Installing the Gateway

• Before You Begin
• Planning to Upgrade or Migrate the Gateway
  • Preupgrade Procedures
  • Upgrade and Migration Considerations
  • Restoration
• Preinstallation Steps
  • Gateway Installation Methods
•  Installing the Gateway Software
• Installation Steps
  • Step through the Oracle Universal Installer
    • Oracle Universal Installer on UNIX platforms
• Deinstalling Oracle Database Gateway for APPC
  • About the Deinstallation Tool
  • Removing Oracle Software

5 Configuring Your Oracle Network

• Configuring the Oracle Network for the Gateway

6 Configuring the SNA Communication Package on Linux

• Using SNA Security Validation
• Processing Inbound Connections
• Independent Versus Dependent LUs
• Definition Types
• Creating IBM Communications Server Definitions for the Gateway
  • Creating the Configuration
  • Creating the Node
  • Creating Devices
  • Choosing the Device Type
  • Configuring a LAN Device
  • Creating Peer Connections
  • Defining the Link Station
  • Defining the Adjacent Node
  • Creating Local LUs
  • Defining Local LUs
  • Creating Partner LUs
  • Defining Partner LUs
  • Creating the CPI-C Side Information Profile
• Testing the Connection
• Resume Configuration of the Gateway

7 Configuring the SNA Communication Package on AIX-Based Systems

• Processing Inbound Connections
• 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
• Activating Profiles
• Resume Configuration of the Gateway

8 Configuring the SNA Communication Package on Solaris

• Processing Inbound Connections
• Configuring SNAP-IX Version 6
  • Before You Begin
  • SNAP-IX Configuration Tool
  • Creating SNAP-IX Profiles for the Gateway
  • Independent Versus Dependent LUs
  • Creating SNA Definitions for the Gateway
  • Sample SNAP-IX Definitions
  • Configuring SNAP-IX
  • Starting xsnaadmin
    • Configuring the SNA node
    • Adding a Port
    • Create a Link Station
    • Creating Local LUs
    • Creating Partner LUs
    • Creating Mode and CPI-C Profiles
  • Testing the Connection
• Resuming Gateway Configuration

9 Gateway Configuration Using SNA Communication Protocol

• Before You Begin
• Preparing to Configure a Gateway Installation/Upgrade
• Oracle Database Configuration: First-Time Gateway Installations
• Upgrading or Migrating the Oracle Database from Previous Gateways
  • If You Must Reinstall Package Specifications
  • Upgrading PGAU From Previous Gateway Releases
• Configuring the Oracle Database for Gateways to Coexist
• Optional Configuration Steps to Permit Multiple Users
• Configuring the Gateway
• Configuring Commit-Confirm
  • Configuring the Oracle Database for Commit-Confirm
  • Configuring Gateway Initialization Parameters for Commit-Confirm
  • Configuring the OLTP for Commit-Confirm
• Verifying the Gateway Installation and OLTP Configuration
  • Verifying the Gateway Installation
  • Verifying the OLTP Configuration
    • CICS Verification
    • IMS/TM Verification
    • APPC/MVS Verification
  • Verifying OLTP Configuration for Commit-Confirm
• Performing Postinstallation Procedures
  • Installing Sample Applications

10 Configuring the OLTP

• Configuring the OLTP for an SNA Environment
  • Configuring CICS Transaction Server for z/OS
  • Configuring IMS/TM
  • Configuring APPC/MVS
• Configuring the OLTP for a TCP/IP Environment

11 Gateway Configuration Using TCP/IP Communication Protocol

• Before You Begin
• Preparing to Configure a Gateway Installation/Upgrade
• Configuring Oracle Database: First-Time Installation
• Upgrading or Migrating the Oracle Database from Previous Gateways
  • If You Must Reinstall Package Specifications
  • Upgrading PGAU from Previous Gateway Releases
• Optional Configuration Steps to Permit Multiple Users
• Configuring TCP/IP for the Gateway
• Configuring the Gateway
• Loading the PGA_TCP_IMSC Table
• Verifying the Gateway Installation and OLTP Configuration
  • Verifying the Gateway Installation
  • Verifying the OLTP Configuration
    • IMS/TM Verification
• Performing Postinstallation Procedures
  • Installing Sample Applications

12 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
• TCP/IP Security
  • Specifying TCP/IP Conversation Security
    • TCP/IP Security Option SECURITY=NONE
    • TPC/IP Security Option SECURITY=PROGRAM
• Passwords in the Gateway Initialization File

13 Migration From Existing Gateways

• Migrating An Existing Gateway Instance to a New Release Using SNA Protocol
  • Step 1: Install the New Release
  • Step 2: Transferring the initsid.ora Gateway Initialization File Parameters
  • Backout Considerations When Migrating to New Releases
  • Oracle Net Considerations
  • Parameter Changes: Version 4 to 12c Release 1 (12.1) of the Gateway
  • Parameter Changes: Version 8 or Earlier to Gateway 12c Release 1 (12.1)
  • Migrating from Gateway Release 9.0.1 or 9.2.0 or 10.1.0 to Gateway 12c Release 1 (12.1)
• Migrating from an Existing Gateway to TCP/IP Using SNA
  • Using Existing TIPs with Existing Side Profile Definitions

A Gateway Initialization Parameters for SNA Protocol

• Gateway Initialization Parameter File Using SNA Protocol
  • PGA Parameters
  • PGA_CAPABILITY Parameter Considerations
  • PGA_CONFIRM Parameter Considerations
  • Sample listener.ora file for a Gateway Using SNA
  • Sample tnsnames.ora file for a Gateway Using SNA

B Gateway Initialization Parameters for TCP/IP Communication Protocol

• Gateway Initialization Parameter File Using TCP/IP
  • PGA Parameters
• Output for the pg4tcpmap Tool
  • Sample listener.ora File for a Gateway Using TCP/IP
  • Sample tnsnames.ora File for a Gateway Using TCP/IP

C Gateway Terminology

• Gateway Term Definitions

D Configuration Worksheet

Index