Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Getting Started with Oracle Database Gateway

• 1.1 Overview
• 1.2 Oracle Heterogeneous Services
• 1.3 Oracle Database Gateways
• 1.4 Gateway Architecture
• 1.5 Gateway Process Flow
• 1.6 Setup Flow

2 Installing Oracle Connect for IMS, VSAM, and Adabas Gateways

• 2.1 Overview of Oracle Database Gateway for IMS, VSAM, and Adabas
• 2.2 System Requirements for Oracle Connect for IMS, VSAM, and Adabas Gateways
  • 2.2.1 Hardware Requirements for Oracle Connect for IMS, VSAM, and Adabas Gateways
  • 2.2.2 Software Requirements for Oracle Connect for IMS, VSAM, and Adabas Gateways
• 2.3 Accessing the Installation Software
  • 2.3.1 Downloading Oracle Software from the Oracle Technology Network Web Site
    • 2.3.1.1 Downloading the Installation Archive File
    • 2.3.1.2 Extracting the Installation Files
  • 2.3.2 Copying the Oracle Software to a Hard Disk
    • 2.3.2.1 Mounting Discs
• 2.4 Installing Oracle Connect for IMS, VSAM, and Adabas Gateways
  • 2.4.1 Installation Worksheet
  • 2.4.2 Preinstallation Instructions
  • 2.4.3 Kit Installation Instructions
    • 2.4.3.1 Transferring the Kit to the Dataset
  • 2.4.4 Installation Instructions
  • 2.4.5 Data Source Configuration Instructions
  • 2.4.6 Postinstallation Instructions
    • 2.4.6.1 Postinstallation Tasks
    • 2.4.6.2 Starting the Daemon
    • 2.4.6.3 Setting Up Oracle Connect for IMS, VSAM, and Adabas Gateways for Reentrancy
    • 2.4.6.4 Configuring Additional Settings for Working with CICS
    • 2.4.6.5 Configuring OTMA for Working with IMS/TM
    • 2.4.6.6 Setting Up Oracle Connect for IMS, VSAM, and Adabas Gateways to Update VSAM, IMS, or Adabas Data

3 Troubleshooting Oracle Connect for IMS, VSAM, and Adabas Gateways

• 3.1 Troubleshooting Overview
• 3.2 Troubleshooting Methods
  • 3.2.1 Using the NAV_UTIL CHECK SERVER Utility
  • 3.2.2 Using the NAV_UTIL CHECK DATASOURCE Utility
  • 3.2.3 Using Trace Log Files
    • 3.2.3.1 Log Traces
• 3.3 Common Errors and Solutions

A Using NAV_UTIL Utility

• A.1 Running NAV_UTIL
  • A.1.1 Activating NAV_UTIL
  • A.1.2 Basic NAV_UTIL Syntax
• A.2 ADD_ADMIN
• A.3 CHECK
  • A.3.1 check irpcd
  • A.3.2 check network [port]
  • A.3.3 check irpcdstat
  • A.3.4 check tcpip
  • A.3.5 check server
  • A.3.6 check license
  • A.3.7 check datasource
• A.4 DELETE
  • A.4.1 Deleting Data Source Objects
• A.5 EDIT
• A.6 EXECUTE
  • A.6.1 EXECUTE Overview
  • A.6.2 Running SQL Statements
    • A.6.2.1 On-the-fly
    • A.6.2.2 From a File
    • A.6.2.3 From within a Transaction
  • A.6.3 EXECUTE Commands
• A.7 EXPORT
• A.8 GEN_ARRAY_TABLES
• A.9 IMPORT
• A.10 IMS_MERGE
• A.11 IRPCDCMD
• A.12 LOCAL_COPY
• A.13 PASSWORD
• A.14 SVC
• A.15 TEST
• A.16 UPDATE
  • A.16.1 Removing Metadata Statistics
• A.17 UPD_DS
• A.18 UPD_SEC
• A.19 VERSION
• A.20 VERSION_HISTORY
• A.21 VIEW
• A.22 XML
  • A.22.1 XML Samples

Index