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

• 1.1 Overview of the Gateway
• 1.2 Features of the Gateway
• 1.3 Terms
• 1.4 Architecture of the Gateway
• 1.5 Implementation of the Gateway
• 1.6 Communication with the Gateway
• 1.7 Remote Procedural Call Functions
  • 1.7.1 Description of RPC Functions
    • 1.7.1.1 Remote Transaction Initiation
    • 1.7.1.2 Data Exchange
    • 1.7.1.3 Remote Transaction Termination
• 1.8 Transaction Types for Gateway Using SNA
• 1.9 Transaction Types for Gateway Using TCP/IP

2 Release Information

• 2.1 Known Restrictions
  • 2.1.1 Known Restrictions for the Gateway
  • 2.1.2 Known Restrictions for PGAU

3 System Requirements

• 3.1 Hardware Requirements
  • 3.1.1 Processor Requirements
  • 3.1.2 Memory Requirements
  • 3.1.3 Network Attachment Requirements
  • 3.1.4 Disk Space Requirements
• 3.2 Software Requirements
  • 3.2.1 Operating System Requirements
  • 3.2.2 Communication Protocol Requirements
  • 3.2.3 Oracle Database Requirements
  • 3.2.4 Oracle Networking Product Requirements
  • 3.2.5 IBM Mainframe Requirements

4 Installing the Gateway

• 4.1 Before You Begin
• 4.2 Planning to Upgrade or Migrate the Gateway
  • 4.2.1 Performing Pre-Upgrade Procedures
  • 4.2.2 Upgrade and Migration Considerations
  • 4.2.3 Restoration
• 4.3 Performing Preinstallation Procedures
  • 4.3.1 Gateway Installation Methods
• 4.4 Installing the Gateway Software
• 4.5 Installation Steps
  • 4.5.1 Step 1: Log On to Windows System
  • 4.5.2 Step 2: Ensure Minimum Amount of Disk Space
  • 4.5.3 Step 3: Stop All Oracle Services
  • 4.5.4 Step 4: Insert the Gateway Product Installation Media
  • 4.5.5 Step 5: Start the Oracle Universal Installer
  • 4.5.6 Step 6: Step Through the Oracle Universal Installer
    • 4.5.6.1 Oracle Universal Installer on Windows Platforms
• 4.6 Removing Your Oracle Database Gateway for APPC

5 Configuring Your Oracle Network

• 5.1 Configuring the Oracle Network for the Gateway

6 Configuring the SNA Communication Package on Windows

• 6.1 Using SNA Security Validation
• 6.2 Processing Inbound Connections
• 6.3 Configuring Your Microsoft Host Integration Server
  • 6.3.1 Independent Versus Dependent LUs
  • 6.3.2 Location of Sample SNA Server Definitions
  • 6.3.3 HIS Definition Types
  • 6.3.4 Methods of Creating SNA Server Definitions for the Gateway
• 6.4 Creating SNA Server Definitions on Microsoft Host Integration Server
  • 6.4.1 Server Selection
  • 6.4.2 Link Service Definition
  • 6.4.3 Connection Definition
  • 6.4.4 Local LU Definition
  • 6.4.5 Mode Definition
  • 6.4.6 Remote LU Definition
  • 6.4.7 CPI-C Symbolic Destination Name
• 6.5 Configuring an IBM Communications Server
  • 6.5.1 Independent And Dependent LUs
  • 6.5.2 Definition Types
• 6.6 Creating IBM Communications Server Definitions for the Gateway
  • 6.6.1 Creating the Configuration
  • 6.6.2 Creating the Node
  • 6.6.3 Creating Devices
  • 6.6.4 Choosing the Device Type
  • 6.6.5 Configuring a LAN Device
  • 6.6.6 Creating Peer Connections
  • 6.6.7 Defining the Link Station
  • 6.6.8 Defining the Adjacent Node
  • 6.6.9 Creating Local LUs
  • 6.6.10 Defining Local LUs
  • 6.6.11 Creating Partner LUs
  • 6.6.12 Defining Partner LUs
  • 6.6.13 Creating the CPI-C Side Information Profile
• 6.7 Testing the Connection
• 6.8 Resume Configuration of the Gateway

7 Configuring the TCP/IP Communications Package for IMS Connect

• 7.1 Configuring TCP/IP for IMS Connect on Windows Platforms

8 Configuring the OLTP

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

9 Gateway Configuration Using SNA Communication Protocol

• 9.1 Before You Begin
• 9.2 Preparing to Configure a Gateway Installation/Upgrade
• 9.3 Integrating Server Configuration: First-Time Gateway Installations
• 9.4 Upgrading or Migrating the Oracle Database from Previous Gateways
  • 9.4.1 If You Must Reinstall Package Specifications
  • 9.4.2 Upgrading PGAU from Previous Gateway Releases
• 9.5 Configuring the Oracle Database for Gateways to Coexist
• 9.6 Optional Configuration Steps to Permit Multiple Users
• 9.7 Configuring the Gateway
• 9.8 Configuring Commit-Confirm
  • 9.8.1 Configuring the Oracle Database for Commit-Confirm
  • 9.8.2 Configuring Gateway Initialization Parameters for Commit-Confirm
  • 9.8.3 Configuring the OLTP for Commit-Confirm
• 9.9 Verifying the Gateway Installation and OLTP Configuration
  • 9.9.1 Verifying the Gateway Installation
  • 9.9.2 Verifying the OLTP Configuration
    • 9.9.2.1 CICS Verification
    • 9.9.2.2 IMS/TM Verification
    • 9.9.2.3 APPC/MVS Verification
  • 9.9.3 Verifying OLTP Configuration for Commit-Confirm
• 9.10 Performing Postinstallation Procedures
  • 9.10.1 Installing Sample Applications

10 Gateway Configuration Using TCP/IP Communication Protocol

• 10.1 Before You Begin
• 10.2 Preparing to Configure a Gateway Installation/Upgrade
• 10.3 Configuring the Oracle Database : First Time Installation
• 10.4 Upgrading or Migrating the Oracle Database from Previous Gateways
  • 10.4.1 If You Must Reinstall Package Specifications
  • 10.4.2 Upgrading PGAU from Previous Gateway Releases
• 10.5 Optional Configuration Steps to Permit Multiple Users
• 10.6 Configuring TCP/IP for the Gateway
• 10.7 Configuring the Gateway
• 10.8 Loading the PGA_TCP_IMSC Table
• 10.9 Verifying the Gateway Installation and OLTP Configuration
  • 10.9.1 Verifying the Gateway Installation
  • 10.9.2 Verifying the OLTP Configuration
    • 10.9.2.1 IMS/TM Verification
• 10.10 Performing Postinstallation Procedures
  • 10.10.1 Installing Sample Applications

11 Security Requirements

• 11.1 Overview of Security Requirements
• 11.2 Authenticating Application Logons
• 11.3 Defining and Controlling Database Links
  • 11.3.1 Link Accessibility
  • 11.3.2 Links and CONNECT Clauses
• 11.4 Using SNA Security Validation
  • 11.4.1 Specifying SNA Conversation Security
    • 11.4.1.1 SNA Security Option SECURITY=NONE
    • 11.4.1.2 SNA Security Option SECURITY=PROGRAM
• 11.5 TCP/IP Security
  • 11.5.1 Specifying TCP/IP Conversation Security
    • 11.5.1.1 TCP/IP Security Option SECURITY=NONE
    • 11.5.1.2 TCP/IP Security Option SECURITY=PROGRAM
• 11.6 Passwords in the Gateway Initialization File

12 Migration from Existing Gateways

• 12.1 Migrating an Existing Gateway Instance to New Release Using SNA Protocol
  • 12.1.1 Step 1: Install the New Release
  • 12.1.2 Step 2: Transfer initsid.ora Gateway Initialization File Parameters
  • 12.1.3 Backout Considerations When Migrating to New Releases
  • 12.1.4 Oracle Net Considerations
  • 12.1.5 Parameter Changes: Version 4 to Release 11.1.0.6 of the Gateway
  • 12.1.6 Parameter Changes: Version 8 or Earlier to Gateway Release 11.1.0.6
  • 12.1.7 Migrating from Gateway Release 9.0.1 or 9.2.0 to Gateway Release 11.1.0.6
• 12.2 Migrating from an Existing Gateway Using SNA to TCP/IP
  • 12.2.1 To Use Existing TIPs with Existing Side Profile Definitions

A Gateway Initialization Parameters for SNA Protocol

• A.1 Gateway Initialization Parameter File Using SNA Protocol
  • A.1.1 PGA Parameters
  • A.1.2 PGA_CAPABILITY Parameter Considerations
  • A.1.3 PGA_CONFIRM Parameter Considerations
  • A.1.4 Sample listener.ora File for a Gateway Using SNA
  • A.1.5 Sample tnsnames.ora File for a Gateway Using SNA

B Gateway Initialization Parameters for TCP/IP Communication Protocol

• B.1 Gateway Initialization Parameter File Using TCP/IP
  • B.1.1 PGA Parameters
• B.2 Output for the pg4tcpmap Tool
  • B.2.1 Sample listener.ora File for a Gateway Using TCP/IP
  • B.2.2 Sample tnsnames.ora File for a Gateway Using TCP/IP

C Gateway Terminology

• C.1 Gateway Term Definitions

D Configuration Worksheet

Index