Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

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
• Remote Procedural Call 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
  • Processor Requirements
  • Memory Requirements
  • Network Attachment Requirements
  • Disk Space 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
  • Performing Pre-Upgrade Procedures
  • Upgrade and Migration Considerations
  • Restoration
• Performing Preinstallation Procedures
  • Gateway Installation Methods
• Installing the Gateway Software
• Using Windows User Account as Oracle Home User
• Installation Steps
  • Step 1: Log On to Windows System
  • Step 2: Ensure Minimum Amount of Disk Space
  • Step 3: Stop All Oracle Services
  • Step 4: Insert the Gateway Product Installation Media
  • Step 5: Start the Oracle Universal Installer
  • Step 6: Step Through the Oracle Universal Installer
    • Oracle Universal Installer on Windows Platforms
• Removing Your 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 Windows

• Using SNA Security Validation
• Processing Inbound Connections
• Configuring Your Microsoft Host Integration Server
  • Independent Versus Dependent LUs
  • Location of Sample SNA Server Definitions
  • HIS Definition Types
  • Methods of Creating SNA Server Definitions for the Gateway
• Creating SNA Server Definitions on Microsoft Host Integration Server
  • Server Selection
  • Link Service Definition
  • Connection Definition
  • Local LU Definition
  • Mode Definition
  • Remote LU Definition
  • CPI-C Symbolic Destination Name
• Configuring an IBM Communications Server
  • Independent And 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 OLTP

• Configuring the OLTP for Your SNA Environment
• Configuring the OLTP for Your TCP/IP Environment

8 Gateway Configuration Using SNA Communication Protocol

• Before You Begin
• Preparing to Configure a Gateway Installation/Upgrade
• Integrating Server 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

9 Gateway Configuration Using TCP/IP Communication Protocol

• Before You Begin
• Preparing to Configure a Gateway Installation/Upgrade
• Configuring the 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

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

11 Migration from Existing Gateways

• Migrating an Existing Gateway Instance to New Release Using SNA Protocol
  • Step 1: Install the New Release
  • Step 2: Transfer 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 to Gateway 12c Release 1 (12.1)
• Migrating from an Existing Gateway Using SNA to TCP/IP
  • To Use 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