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

• 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 RPC 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 Product Set
• 2.2 Changes and Enhancements
  • 2.2.1 Gateway Password Encryption Tool
  • 2.2.2 Partial IPv6 Support
• 2.3 Known Restrictions
  • 2.3.1 Known Restrictions for the Gateway
  • 2.3.2 Known Restrictions for PGAU

3 System Requirements

• 3.1 Hardware Requirements
  • 3.1.1 Network Attachment 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 Preupgrade Procedures
  • 4.2.2 Upgrade and Migration Considerations
  • 4.2.3 Restoration
• 4.3 Preinstallation Steps
  • 4.3.1 Gateway Installation Methods
• 4.4  Installing the Gateway Software
• 4.5 Installation Steps
  • 4.5.1 Step through the Oracle Universal Installer
    • 4.5.1.1 Oracle Universal Installer on UNIX platforms
• 4.6 Deinstalling Oracle Database Gateway for APPC
  • 4.6.1 About the Deinstallation Tool
  • 4.6.2 Removing Oracle Software

5 Configuring Your Oracle Network

• 5.1 Configuring the Oracle Network for the Gateway

6 Configuring the SNA Communication Package on Linux

• 6.1 Using SNA Security Validation
• 6.2 Processing Inbound Connections
• 6.3 Independent Versus Dependent LUs
• 6.4 Definition Types
• 6.5 Creating IBM Communications Server Definitions for the Gateway
  • 6.5.1 Creating the Configuration
  • 6.5.2 Creating the Node
  • 6.5.3 Creating Devices
  • 6.5.4 Choosing the Device Type
  • 6.5.5 Configuring a LAN Device
  • 6.5.6 Creating Peer Connections
  • 6.5.7 Defining the Link Station
  • 6.5.8 Defining the Adjacent Node
  • 6.5.9 Creating Local LUs
  • 6.5.10 Defining Local LUs
  • 6.5.11 Creating Partner LUs
  • 6.5.12 Defining Partner LUs
  • 6.5.13 Creating the CPI-C Side Information Profile
• 6.6 Testing the Connection
• 6.7 Resume Configuration of the Gateway

7 Configuring the SNA Communication Package on AIX-Based Systems

• 7.1 Processing Inbound Connections
• 7.2 Independent Versus Dependent LUs
• 7.3 Creating SNA Profiles for the Gateway
• 7.4 Profile Types
• 7.5 SNA Server Profiles
  • 7.5.1 SNA Node Profile
  • 7.5.2 Link Station Profile
  • 7.5.3 Mode Profile
  • 7.5.4 Local LU Profile
  • 7.5.5 Partner LU Profile
  • 7.5.6 Partner LU Location Profile
  • 7.5.7 Side Information Profile
• 7.6 Activating Profiles
• 7.7 Resume Configuration of the Gateway

8 Configuring the SNA Communication Package on HP-UX

• 8.1 Processing Inbound Connections
  • 8.1.1 Steps for Configuring the Communications Interfaces
• 8.2 SNAPlus2 Configuration Tool
• 8.3 Creating SNAPlus2 Profiles for the Gateway
• 8.4 Independent Versus Dependent LUs
  • 8.4.1 Sym Dest Name
• 8.5 Creating SNA Definitions for the Gateway
• 8.6 Sample SNAPlus2 Definitions
• 8.7 Configuring SNAPlus2
• 8.8 Testing the Connection
• 8.9 Resuming Gateway Configuration

9 Configuring the SNA Communication Package on Solaris

• 9.1 Processing Inbound Connections
• 9.2 Configuring SNAP-IX Version 6
  • 9.2.1 Before You Begin
  • 9.2.2 SNAP-IX Configuration Tool
  • 9.2.3 Creating SNAP-IX Profiles for the Gateway
  • 9.2.4 Independent Versus Dependent LUs
  • 9.2.5 Creating SNA Definitions for the Gateway
  • 9.2.6 Sample SNAP-IX Definitions
  • 9.2.7 Configuring SNAP-IX
  • 9.2.8 Starting xsnaadmin
    • 9.2.8.1 Configuring the SNA node
    • 9.2.8.2 Adding a Port
    • 9.2.8.3 Create a Link Station
    • 9.2.8.4 Creating Local LUs
    • 9.2.8.5 Creating Partner LUs
    • 9.2.8.6 Creating Mode and CPI-C Profiles
  • 9.2.9 Testing the Connection
• 9.3 Resuming Gateway Configuration

10 Configuring the OLTP

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

11 Gateway Configuration Using SNA Communication Protocol

• 11.1 Before You Begin
• 11.2 Preparing to Configure a Gateway Installation/Upgrade
• 11.3 Oracle Database Configuration: First-Time Gateway Installations
• 11.4 Upgrading or Migrating the Oracle Database from Previous Gateways
  • 11.4.1 If You Must Reinstall Package Specifications
  • 11.4.2 Upgrading PGAU From Previous Gateway Releases
• 11.5 Configuring the Oracle Database for Gateways to Coexist
• 11.6 Optional Configuration Steps to Permit Multiple Users
• 11.7 Configuring the Gateway
• 11.8 Configuring Commit-Confirm
  • 11.8.1 Configuring the Oracle Database for Commit-Confirm
  • 11.8.2 Configuring Gateway Initialization Parameters for Commit-Confirm
  • 11.8.3 Configuring the OLTP for Commit-Confirm
• 11.9 Verifying the Gateway Installation and OLTP Configuration
  • 11.9.1 Verifying the Gateway Installation
  • 11.9.2 Verifying the OLTP Configuration
    • 11.9.2.1 CICS Verification
    • 11.9.2.2 IMS/TM Verification
    • 11.9.2.3 APPC/MVS Verification
  • 11.9.3 Verifying OLTP Configuration for Commit-Confirm
• 11.10 Performing Postinstallation Procedures
  • 11.10.1 Installing Sample Applications

12 Gateway Configuration Using TCP/IP Communication Protocol

• 12.1 Before You Begin
• 12.2 Preparing to Configure a Gateway Installation/Upgrade
• 12.3 Configuring Oracle Database: First-Time Installation
• 12.4 Upgrading or Migrating the Oracle Database from Previous Gateways
  • 12.4.1 If You Must Reinstall Package Specifications
  • 12.4.2 Upgrading PGAU from Previous Gateway Releases
• 12.5 Optional Configuration Steps to Permit Multiple Users
• 12.6 Configuring TCP/IP for the Gateway
• 12.7 Configuring the Gateway
• 12.8 Loading the PGA_TCP_IMSC Table
• 12.9 Verifying the Gateway Installation and OLTP Configuration
  • 12.9.1 Verifying the Gateway Installation
  • 12.9.2 Verifying the OLTP Configuration
    • 12.9.2.1 IMS/TM Verification
• 12.10 Performing Postinstallation Procedures
  • 12.10.1 Installing Sample Applications

13 Security Requirements

• 13.1 Overview of Security Requirements
• 13.2 Authenticating Application Logons
• 13.3 Defining and Controlling Database Links
  • 13.3.1 Link Accessibility
  • 13.3.2 Links and CONNECT Clauses
• 13.4 Using SNA Security Validation
  • 13.4.1 Specifying SNA Conversation Security
    • 13.4.1.1 SNA Security Option SECURITY=NONE
    • 13.4.1.2 SNA Security Option SECURITY=PROGRAM
    • 13.4.1.3 SNA Security Option SECURITY=SAME
• 13.5 TCP/IP Security
  • 13.5.1 Specifying TCP/IP Conversation Security
    • 13.5.1.1 TCP/IP Security Option SECURITY=NONE
    • 13.5.1.2 TPC/IP Security Option SECURITY=PROGRAM
• 13.6 Passwords in the Gateway Initialization File

14 Migration From Existing Gateways

• 14.1 Migrating An Existing Gateway Instance to a New Release Using SNA Protocol
  • 14.1.1 Step 1: Install the New Release
  • 14.1.2 Step 2: Transferring the initsid.ora Gateway Initialization File Parameters
  • 14.1.3 Backout Considerations When Migrating to New Releases
  • 14.1.4 Oracle Net Considerations
  • 14.1.5 Parameter Changes: Version 4 to Release 11.2 of the Gateway
  • 14.1.6 Parameter Changes: Version 8 or Earlier to Gateway Release 11.2
  • 14.1.7 Migrating from Gateway Release 9.0.1 or 9.2.0 or 10.1.0 to Gateway Release 11.2
• 14.2 Migrating from an Existing Gateway to TCP/IP Using SNA
  • 14.2.1 Using 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