Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Getting Started with Oracle Database Gateway

• Overview
• Oracle Heterogeneous Services
• Oracle Database Gateways
• Gateway Architecture
• Gateway Process Flow
• Setup Flow

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

• Overview of Oracle Database Gateway for IMS, VSAM, and Adabas
• System Requirements for Oracle Connect for IMS, VSAM, and Adabas Gateways
  • Hardware Requirements for Oracle Connect for IMS, VSAM, and Adabas Gateways
  • Software Requirements for Oracle Connect for IMS, VSAM, and Adabas Gateways
• Accessing the Installation Software
  • Downloading Oracle Software from the Oracle Technology Network Web Site
    • Downloading the Installation Archive File
    • Extracting the Installation Files
  • Copying the Oracle Software to a Hard Disk
    • Mounting Discs
• Installing Oracle Connect for IMS, VSAM, and Adabas Gateways
  • Installation Worksheet
  • Preinstallation Instructions
  • Kit Installation Instructions
    • Transferring the Kit to the Dataset
  • Installation Instructions
  • Data Source Configuration Instructions
  • Postinstallation Instructions
    • Postinstallation Tasks
    • Starting the Daemon
    • Setting Up Oracle Connect for IMS, VSAM, and Adabas Gateways for Reentrancy
    • Configuring Additional Settings for Working with CICS
    • Configuring OTMA for Working with IMS/TM
    • 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

• Troubleshooting Overview
• Troubleshooting Methods
  • Using the NAV_UTIL CHECK SERVER Utility
  • Using the NAV_UTIL CHECK DATASOURCE Utility
  • Using Trace Log Files
    • Log Traces
• Common Errors and Solutions

A Using NAV_UTIL Utility

• Running NAV_UTIL
  • Activating NAV_UTIL
  • Basic NAV_UTIL Syntax
• ADD_ADMIN
• CHECK
  • check irpcd
  • check network [port]
  • check irpcdstat
  • check tcpip
  • check server
  • check license
  • check datasource
• DELETE
  • Deleting Data Source Objects
• EDIT
• EXECUTE
  • EXECUTE Overview
  • Running SQL Statements
    • On-the-fly
    • From a File
    • From within a Transaction
  • EXECUTE Commands
• EXPORT
• GEN_ARRAY_TABLES
• IMPORT
• IMS_MERGE
• IRPCDCMD
• LOCAL_COPY
• PASSWORD
• SVC
• TEST
• UPDATE
  • Removing Metadata Statistics
• UPD_DS
• UPD_SEC
• VERSION
• VERSION_HISTORY
• VIEW
• XML
  • XML Samples

Index