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 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 CD-ROM Drive
    • 3.1.4.1 HP-UX Only
  • 3.1.5 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 Preupgrade Procedures
  • 4.2.2 Upgrade and Migration Considerations
  • 4.2.3 Restoration
• 4.3 Preinstallation Steps for Upgrade
  • 4.3.1 Gateway Installation Methods
• 4.4 Installing the Gateway Software
• 4.5 Installation Steps
  • 4.5.1 Step 1: Login as DBA and Create Login User ID
  • 4.5.2 Step 2: Create the Product Installation Directory
  • 4.5.3 Step 3: Setting the Environment Variables
  • 4.5.4 Step 5: Mount the CD-ROM
    • 4.5.4.1 Mounting the CD-ROM for Linux
    • 4.5.4.2 Mounting the CD-ROM for AIX-Based Systems
    • 4.5.4.3 Mounting the CD-ROM for HP-UX
    • 4.5.4.4 Mounting the CD-ROM for Solaris Operating System (SPARC 64-bit)
  • 4.5.5 Step 6: Start the Oracle Universal Installer
    • 4.5.5.1 For Linux
    • 4.5.5.2 For AIX Systems
    • 4.5.5.3 For HP-UX
    • 4.5.5.4 For Solaris
  • 4.5.6 Step 7: Step through the Oracle Universal Installer
    • 4.5.6.1 Oracle Universal Installer on UNIX platforms
• 4.6 Deinstalling 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 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 TCP/IP Communications Package for IMS Connect

• 10.1 Configuring TCP/IP for IMS Connect on UNIX Platforms

11 Configuring the OLTP

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

12 Gateway Configuration Using SNA Communication Protocol

• 12.1 Before You Begin
• 12.2 Preparing to Configure a Gateway Installation/Upgrade
• 12.3 Oracle Database Configuration: First-Time Gateway Installations
• 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 Configuring the Oracle Database for Gateways to Coexist
• 12.6 Optional Configuration Steps to Permit Multiple Users
• 12.7 Configuring the Gateway
• 12.8 Configuring Commit-Confirm
  • 12.8.1 Configuring the Oracle Database for Commit-Confirm
  • 12.8.2 Configuring Gateway Initialization Parameters for Commit-Confirm
  • 12.8.3 Configuring the OLTP for Commit-Confirm
• 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 CICS Verification
    • 12.9.2.2 IMS/TM Verification
    • 12.9.2.3 APPC/MVS Verification
  • 12.9.3 Verifying OLTP Configuration for Commit-Confirm
• 12.10 Performing Postinstallation Procedures
  • 12.10.1 Installing Sample Applications

13 Gateway Configuration Using TCP/IP Communication Protocol

• 13.1 Before You Begin
• 13.2 Preparing to Configure a Gateway Installation/Upgrade
• 13.3 Configuring Oracle Database: First-Time Installation
• 13.4 Upgrading or Migrating the Oracle Database from Previous Gateways
  • 13.4.1 If You Must Reinstall Package Specifications
  • 13.4.2 Upgrading PGAU from Previous Gateway Releases
• 13.5 Optional Configuration Steps to Permit Multiple Users
• 13.6 Configuring TCP/IP for the Gateway
• 13.7 Configuring the Gateway
• 13.8 Loading the PGA_TCP_IMSC Table
• 13.9 Verifying the Gateway Installation and OLTP Configuration
  • 13.9.1 Verifying the Gateway Installation
  • 13.9.2 Verifying the OLTP Configuration
    • 13.9.2.1 IMS/TM Verification
• 13.10 Performing Postinstallation Procedures
  • 13.10.1 Installing Sample Applications

14 Security Requirements

• 14.1 Overview of Security Requirements
• 14.2 Authenticating Application Logons
• 14.3 Defining and Controlling Database Links
  • 14.3.1 Link Accessibility
  • 14.3.2 Links and CONNECT Clauses
• 14.4 Using SNA Security Validation
  • 14.4.1 Specifying SNA Conversation Security
    • 14.4.1.1 SNA Security Option SECURITY=NONE
    • 14.4.1.2 SNA Security Option SECURITY=PROGRAM
    • 14.4.1.3 SNA Security Option SECURITY=SAME
• 14.5 TCP/IP Security
  • 14.5.1 Specifying TCP/IP Conversation Security
    • 14.5.1.1 TCP/IP Security Option SECURITY=NONE
    • 14.5.1.2 TPC/IP Security Option SECURITY=PROGRAM
• 14.6 Passwords in the Gateway Initialization File

15 Migration From Existing Gateways

• 15.1 Migrating An Existing Gateway Instance to a New Release Using SNA Protocol
  • 15.1.1 Step 1: Install the New Release
  • 15.1.2 Step 2: Transferring the initsid.ora Gateway Initialization File Parameters
  • 15.1.3 Backout Considerations When Migrating to New Releases
  • 15.1.4 Oracle Net Considerations
  • 15.1.5 Parameter Changes: Version 4 to Release 11.1.0.6 of the Gateway
  • 15.1.6 Parameter Changes: Version 8 or Earlier to Gateway Release 11.1.0.6
  • 15.1.7 Migrating from Gateway Release 9.0.1 or 9.2.0 or 10.1.0 to Gateway Release 11.1.0.6
• 15.2 Migrating from an Existing Gateway to TCP/IP Using SNA
  • 15.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