Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I Getting Started with Oracle Database Gateways

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

Part II Installing and Configuring Oracle Database Gateway for VSAM

2 Configuring Access to VSAM Data

• 2.1 Setting Up Access to a Computer Running Oracle Connect for IMS, VSAM, and Adabas Gateways
• 2.2 Setting Up a VSAM Data Source
  • 2.2.1 Defining the VSAM Data Source Connection
  • 2.2.2 Defining the VSAM (CICS) Data Source Connection
  • 2.2.3 Configuring the VSAM or VSAM (CICS) Data Source Properties
    • 2.2.3.1 VSAM Data Source Parameters
    • 2.2.3.2 VSAM (CICS) Data Source Parameters
• 2.3 Setting Up the Metadata of the VSAM Data Source
  • 2.3.1 Import the COBOL Copybooks
  • 2.3.2 Apply Filters
  • 2.3.3 Select Tables
  • 2.3.4 Manipulate the Imported Tables
  • 2.3.5 Create VSAM Indexes
  • 2.3.6 Select the Metadata Model
  • 2.3.7 Import the Metadata
• 2.4 Setting Up the Metadata of the VSAM (CICS) Data Source
  • 2.4.1 Import the COBOL Copybooks
  • 2.4.2 Apply Filters
  • 2.4.3 Select Tables
  • 2.4.4 Manipulate the Imported Tables
  • 2.4.5 Assign File Names
  • 2.4.6 Assign Index File Names
  • 2.4.7 Select the Metadata Model
  • 2.4.8 Import the Metadata

3 Installing Oracle Database Gateway for VSAM

• 3.1 Overview of Oracle Database Gateway for VSAM
• 3.2 System Requirements for Oracle Database Gateway for VSAM
  • 3.2.1 Hardware Requirements for Oracle Database Gateway for VSAM
  • 3.2.2 Software Requirements for Oracle Database Gateway for VSAM
• 3.3 Gateway Installation Configurations
• 3.4 Gateway Installation Methods
  • 3.4.1 Interactive Installation Method
  • 3.4.2 Automated Installation Method Using Response Files
• 3.5 Gateway Installation Considerations
  • 3.5.1 Release Notes
  • 3.5.2 Hardware and Software Certification
  • 3.5.3 Multiple ORACLE_HOME Directories
    • 3.5.3.1 Installing the Software on a System with an Existing Oracle Installation
• 3.6 Upgrades
• 3.7 Accessing the Installation Software
  • 3.7.1 Downloading Oracle Software from the Oracle Technology Network Web Site
    • 3.7.1.1 Downloading the Installation Files
    • 3.7.1.2 Extracting the Installation Files
  • 3.7.2 Copying the Gateway Software to a Hard Disk
    • 3.7.2.1 Mounting the Installation Media
    • 3.7.2.2 Copying the Oracle Database Gateway Software to a Hard Disk
• 3.8 Running the Oracle Universal Installer

4 Configuring Oracle Database Gateway for VSAM

• 4.1 Configuring the Gateway
  • 4.1.1 Choose a System Identifier for the Gateway
  • 4.1.2 Customize the Initialization Parameter File
• 4.2 Configuring Oracle Net Services Listener for the Gateway
  • 4.2.1 Configure Oracle Net Services Oracle Net Listener for the Gateway
    • 4.2.1.1 Example of Address to Listen On in listener.ora File
    • 4.2.1.2 Example of Gateway to Start in listener.ora File
  • 4.2.2 Stop and Start the Oracle Net Listener for the Gateway
• 4.3 Configuring the Oracle Database for Gateway Access
  • 4.3.1 Configuring Oracle Net Services for the Oracle Database
    • 4.3.1.1 Configuring tnsnames.ora
• 4.4 Creating Database Links
• 4.5 Gateway Password Encryption Tool
• 4.6 Configuring the Gateway for Multiple VSAM Databases
  • 4.6.1 Multiple Databases Example: Configuring the Gateway
  • 4.6.2 Multiple Databases Example: Configuring Oracle Net Services Listener
  • 4.6.3 Multiple Databases Example: Stopping and Starting the Oracle Net Listener
  • 4.6.4 Multiple Databases Example: Configuring the Oracle Database for Gateway Access
    • 4.6.4.1 Configuring Oracle Net Services on the Oracle Database for Multiple Gateway Instances
  • 4.6.5 Multiple Databases Example: Accessing VSAM Data
• 4.7 Performing Configuration Tasks
  • 4.7.1 Configuring for Global Transactions
  • 4.7.2 Enabling Automatic Recovery
• 4.8 Testing the VSAM Data Source
  • 4.8.1 Sample Log File

Part III Installing and Configuring Oracle Database Gateway for IMS

5 Configuring Access to IMS Data

• 5.1 Setting Up Access to a Computer Running Oracle Connect for IMS, VSAM, and Adabas Gateways
• 5.2 Setting Up an IMS Data Source
  • 5.2.1 Defining the IMS-DLI Data Source
    • 5.2.1.1 Setting Up the Daemon Workspace
    • 5.2.1.2 Defining the IMS-DLI Data Source Connection
    • 5.2.1.3 Configuring the IMS/DB DLI Data Source Properties
  • 5.2.2 Defining the IMS/DB DBCTL Data Source
    • 5.2.2.1 Define the IMS/DB DBCTL Data Source Connection
    • 5.2.2.2 Configure the IMS/DB DBCTL Data Source Properties
    • 5.2.2.3 Accessing IMS/DB Data under CICS
  • 5.2.3 Defining the IMS/DB DBDC Data Source
    • 5.2.3.1 Define the IMS/DB DBDC Data Source Connection
    • 5.2.3.2 Configure the IMS/DB DBDC Data Source Properties
    • 5.2.3.3 Access IMS/DB Data under IMS/TM
• 5.3 Setting Up the IMS/DB Data Source Metadata
  • 5.3.1 Select the Input Files
  • 5.3.2 Apply Filters
  • 5.3.3 Select Tables
  • 5.3.4 Match DBD to COBOL
  • 5.3.5 Manipulate the Imported Records
  • 5.3.6 Select the Metadata Model
  • 5.3.7 Import the Metadata

6 Installing Oracle Database Gateway for IMS

• 6.1 Overview of Oracle Database Gateway for IMS
• 6.2 System Requirements for Oracle Database Gateway for IMS
  • 6.2.1 Hardware Requirements for Oracle Database Gateway for IMS
  • 6.2.2 Software Requirements for Oracle Database Gateway for IMS
• 6.3 Gateway Installation Configurations
• 6.4 Gateway Installation Methods
  • 6.4.1 Interactive Installation Method
  • 6.4.2 Automated Installation Method Using Response Files
• 6.5 Gateway Installation Considerations
  • 6.5.1 Release Notes
  • 6.5.2 Hardware and Software Certification
  • 6.5.3 Multiple ORACLE_HOME Directories
    • 6.5.3.1 Installing the Software on a System with an Existing Oracle Installation
• 6.6 Upgrades
• 6.7 Accessing the Installation Software
  • 6.7.1 Downloading Oracle Software from the Oracle Technology Network Web Site
    • 6.7.1.1 Downloading the Installation Files
    • 6.7.1.2 Extracting the Installation Files
  • 6.7.2 Copying the Gateway Software to a Hard Disk
    • 6.7.2.1 Mounting the Installation Media
    • 6.7.2.2 Copying the Oracle Database Gateway Software to a Hard Disk
• 6.8 Running the Oracle Universal Installer

7 Configuring Oracle Database Gateway for IMS

• 7.1 Configuring the Gateway
  • 7.1.1 Choose a System Identifier for the Gateway
  • 7.1.2 Customize the Initialization Parameter File
• 7.2 Configuring Oracle Net Services Listener for the Gateway
  • 7.2.1 Configure Oracle Net Services Oracle Net Listener for the Gateway
    • 7.2.1.1 Example of Address to Listen On in listener.ora File
    • 7.2.1.2 Example of Gateway to Start in listener.ora File
  • 7.2.2 Stop and Start the Oracle Net Listener for the Gateway
• 7.3 Configuring the Oracle Database for Gateway Access
  • 7.3.1 Configuring Oracle Net Services for the Oracle Database
    • 7.3.1.1 Configuring tnsnames.ora
• 7.4 Creating Database Links
• 7.5 Gateway Password Encryption Tool
• 7.6 Configuring the Gateway for Multiple IMS Databases
  • 7.6.1 Multiple Databases Example: Configuring the Gateway
  • 7.6.2 Multiple Databases Example: Configuring Oracle Net Services Listener
  • 7.6.3 Multiple Databases Example: Stopping and Starting the Oracle Net Listener
  • 7.6.4 Multiple Databases Example: Configuring the Oracle Database for Gateway Access
    • 7.6.4.1 Configuring Oracle Net Services on the Oracle Database for Multiple Gateway Instances
  • 7.6.5 Multiple Databases Example: Accessing IMS Data
• 7.7 Performing Configuration Tasks
  • 7.7.1 Configuring for Global Transactions
  • 7.7.2 Enabling Automatic Recovery
• 7.8 Testing the IMS Data Source
  • 7.8.1 Sample Log File

Part IV Installing and Configuring Oracle Database Gateway for Adabas

8 Configuring Access to Adabas Data

• 8.1 Setting Up Access to a Computer Running Oracle Connect for IMS, VSAM, and Adabas Gateways
• 8.2 Setting Up an Adabas Data Source
  • 8.2.1 Define the Adabas Data Source Connection
  • 8.2.2 Configure the Adabas Data Source Properties
• 8.3 Setting Up Adabas Data Source Metadata
  • 8.3.1 Import Oracle Metadata from DDM Files
  • 8.3.2 Export Predict Metadata into Adabas ADD

9 Installing Oracle Database Gateway for Adabas

• 9.1 Overview of Oracle Database Gateway for Adabas
• 9.2 System Requirements for Oracle Database Gateway for Adabas
  • 9.2.1 Hardware Requirements for Oracle Database Gateway for Adabas
  • 9.2.2 Software Requirements for Oracle Database Gateway for Adabas
• 9.3 Gateway Installation Configurations
• 9.4 Gateway Installation Methods
  • 9.4.1 Interactive Installation Method
  • 9.4.2 Automated Installation Method Using Response Files
• 9.5 Gateway Installation Considerations
  • 9.5.1 Release Notes
  • 9.5.2 Hardware and Software Certification
  • 9.5.3 Multiple ORACLE_HOME Directories
    • 9.5.3.1 Installing the Software on a System with an Existing Oracle Installation
• 9.6 Upgrades
• 9.7 Accessing the Installation Software
  • 9.7.1 Downloading Oracle Software from the Oracle Technology Network Web Site
    • 9.7.1.1 Downloading the Installation Files
    • 9.7.1.2 Extracting the Installation Files
  • 9.7.2 Copying the Gateway Software to a Hard Disk
    • 9.7.2.1 Mounting the Installation Media
    • 9.7.2.2 Copying the Oracle Database Gateway Software to a Hard Disk
• 9.8 Running the Oracle Universal Installer

10 Configuring Oracle Database Gateway for Adabas

• 10.1 Configuring the Gateway
  • 10.1.1 Choose a System Identifier for the Gateway
  • 10.1.2 Customize the Initialization Parameter File
• 10.2 Configuring Oracle Net Services Listener for the Gateway
  • 10.2.1 Configure Oracle Net Services Oracle Net Listener for the Gateway
    • 10.2.1.1 Example of Address to Listen On in listener.ora File
    • 10.2.1.2 Example of Gateway to Start in listener.ora File
  • 10.2.2 Stop and Start the Oracle Net Listener for the Gateway
• 10.3 Configuring the Oracle Database for Gateway Access
  • 10.3.1 Configuring Oracle Net Services for the Oracle Database
    • 10.3.1.1 Configuring tnsnames.ora
• 10.4 Creating Database Links
• 10.5 Gateway Password Encryption Tool
• 10.6 Configuring the Gateway for Multiple Adabas Databases
  • 10.6.1 Multiple Databases Example: Configuring the Gateway
  • 10.6.2 Multiple Databases Example: Configuring Oracle Net Services Listener
  • 10.6.3 Multiple Databases Example: Stopping and Starting the Oracle Net Listener
  • 10.6.4 Multiple Databases Example: Configuring the Oracle Database for Gateway Access
    • 10.6.4.1 Configuring Oracle Net Services on the Oracle Database for Multiple Gateway Instances
  • 10.6.5 Multiple Databases Example: Accessing Adabas Data
• 10.7 Performing Configuration Tasks
  • 10.7.1 Configuring for Global Transactions
  • 10.7.2 Enabling Automatic Recovery
• 10.8 Testing the Adabas Data Source

Part V Installing and Working with Oracle Studio for IMS, VSAM, and Adabas Gateways

11 Installing Oracle Studio for IMS, VSAM, and Adabas Gateways

• 11.1 System Requirements for Oracle Database Gateway
  • 11.1.1 Hardware Requirements for Oracle Studio for IMS, VSAM, and Adabas Gateways
  • 11.1.2 Software Requirements for Oracle Studio for IMS, VSAM, and Adabas Gateways
• 11.2 Installing Oracle Studio for IMS, VSAM, and Adabas Gateways on UNIX
  • 11.2.1 Accessing Oracle Studio for IMS, VSAM, and Adabas Gateways Software on UNIX
  • 11.2.2 Installing Oracle Studio for IMS, VSAM, and Adabas Gateways with the Wizard (SH installation)
  • 11.2.3 Installing with a Silent Installation (RPM)
• 11.3 Installing Oracle Studio for IMS, VSAM, and Adabas Gateways on Windows

12 Working with the Oracle Studio for IMS, VSAM, and Adabas Gateways Workbench

• 12.1 Using Workbench Parts
  • 12.1.1 Main Screen
  • 12.1.2 Main Menu Bar
  • 12.1.3 Working with Views
    • 12.1.3.1 Customizing Views
    • 12.1.3.2 Properties View
    • 12.1.3.3 Error Log View
    • 12.1.3.4 Configuration View
    • 12.1.3.5 Metadata View
  • 12.1.4 Working with Perspectives
    • 12.1.4.1 Design Perspective
    • 12.1.4.2 Runtime Perspective
    • 12.1.4.3 Selecting a Perspective
• 12.2 Workbench Icons
  • 12.2.1 General
  • 12.2.2 Actions
  • 12.2.3 Objects
  • 12.2.4 Manipulation
• 12.3 Setting Oracle Studio for IMS, VSAM, and Adabas Gateways Preferences
  • 12.3.1 Studio
    • 12.3.1.1 Configuration
    • 12.3.1.2 Metadata
    • 12.3.1.3 Runtime Manager
  • 12.3.2 Keys
    • 12.3.2.1 Default Keyboard Shortcuts

13 Configuring Oracle Connect through Oracle Studio for IMS, VSAM, and Adabas Gateways

• 13.1 Starting and Stopping Daemons
  • 13.1.1 Starting a Daemon
    • 13.1.1.1 Enabling Automatic Startup
    • 13.1.1.2 Manually Starting a Daemon on z/OS Platforms
    • 13.1.1.3 Starting Multiple Daemons
  • 13.1.2 Stopping a Daemon
    • 13.1.2.1 Shutting Down a Daemon Using Oracle Studio for IMS, VSAM, and Adabas Gateways
    • 13.1.2.2 Shutting Down a Daemon Using the Command Line
    • 13.1.2.3 Disabling a Workspace
  • 13.1.3 Checking the Daemon
• 13.2 Managing Daemon Configurations
  • 13.2.1 Daemon Configuration Groups
  • 13.2.2 Adding and Editing Daemon Configurations
  • 13.2.3 Configuring Logging
• 13.3 Adding and Editing Workspaces
  • 13.3.1 Adding a Workspace
  • 13.3.2 Editing a Workspace
    • 13.3.2.1 WS Info
    • 13.3.2.2 WS Server
    • 13.3.2.3 WS Logging
    • 13.3.2.4 WS Security
    • 13.3.2.5 WS Governing
• 13.4 Managing Binding Configurations
  • 13.4.1 Server Binding
  • 13.4.2 Client Binding
  • 13.4.3 Binding Syntax
    • 13.4.3.1 <remoteMachines> Statement
    • 13.4.3.2 <datasources> Statement
    • 13.4.3.3 Sample Binding
  • 13.4.4 Environment Properties
    • 13.4.4.1 Sample Environment Properties

14 Managing Security for Oracle Connect for IMS, VSAM, and Adabas Gateways

• 14.1 Managing Design Time Security
  • 14.1.1 Setting Up the Password Caching Policy in Oracle Studio for IMS, VSAM, and Adabas Gateways
  • 14.1.2 Setting Up Administration Access to a Machine
  • 14.1.3 Assigning Design Roles
  • 14.1.4 Assigning Authorization Rights to a Workspace
  • 14.1.5 Setting Up a Master Password for a User Profile
• 14.2 Managing Runtime Security
  • 14.2.1 Granting Daemon Administration Rights to Users
  • 14.2.2 Granting Workspace Administration Rights to Users
  • 14.2.3 Granting Workspace Access Rights to a User
  • 14.2.4 Accessing a Server through a Firewall
    • 14.2.4.1 Specifying a Port Range for Workspace Servers
    • 14.2.4.2 Accessing a Server Using Fixed NAT
  • 14.2.5 Encrypting Network Communications
    • 14.2.5.1 Transport Encryption
    • 14.2.5.2 Setting an Encryption Protocol on the Gateway Side
    • 14.2.5.3 Specifying the Encryption Key on the Server Machine
  • 14.2.6 Setting Up Impersonation

Part VI Appendixes

A Using Response Files Non-Interactive Installation

• A.1 Introduction
• A.2 Installation Overview
• A.3 Creating the oraInst.loc File
• A.4 Preparing a Response File
  • A.4.1 Editing a Response File Template
  • A.4.2 Recording a Response File
• A.5 Running Oracle Universal Installer in Silent or Suppressed Mode

B Initialization Parameters

• B.1 Initialization Parameter File Syntax
• B.2 HS_DB_DOMAIN
• B.3 HS_DB_INTERNAL_NAME
• B.4 HS_DB_NAME
• B.5 HS_DESCRIBE_CACHE_HWM
• B.6 HS_LANGUAGE
  • B.6.1 Character Sets
  • B.6.2 Language
  • B.6.3 Territory
• B.7 HS_LONG_PIECE_TRANSFER_SIZE
• B.8 HS_OPEN_CURSORS
• B.9 HS_RPC_FETCH_REBLOCKING
• B.10 HS_RPC_FETCH_SIZE
• B.11 HS_TRANSACTION_MODEL
• B.12 IFILE
• B.13 HS_FDS_CONNECT_INFO
• B.14 HS_FDS_PARSER_TOKEN_SIZE
• B.15 HS_FDS_RECOVERY_ACCOUNT
• B.16 HS_FDS_RECOVERY_PWD
• B.17 HS_FDS_TRACE_LEVEL
• B.18 HS_NLS_NCHAR
• B.19 HS_NLS_NUMERIC_CHARACTER
• B.20 HS_FDS_DATASOURCE_NAME
• B.21 HS_FDS_ACCESS_METHOD

C Oracle Database Gateway Troubleshooting

• C.1 Verify Requirements
• C.2 What to do if an Installation Error Occurs
• C.3 Reviewing the Log of an Installation Session
• C.4 Silent Mode Response File Error Handling
• C.5 Cleaning Up after a Failed Installation

Index