Contents

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

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

Part II Installing and Configuring Oracle Database Gateway for VSAM

2 Configuring Access to VSAM Data

• Setting Up Access to a Computer Running Oracle Connect for IMS, VSAM, and Adabas Gateways
• Setting Up a VSAM Data Source
  • Defining the VSAM Data Source Connection
  • Defining the VSAM (CICS) Data Source Connection
  • Configuring the VSAM or VSAM (CICS) Data Source Properties
    • VSAM Data Source Parameters
    • VSAM (CICS) Data Source Parameters
• Setting Up the Metadata of the VSAM Data Source
  • Import the COBOL Copybooks
  • Apply Filters
  • Select Tables
  • Manipulate the Imported Tables
  • Create VSAM Indexes
  • Select the Metadata Model
  • Import the Metadata
• Setting Up the Metadata of the VSAM (CICS) Data Source
  • Import the COBOL Copybooks
  • Apply Filters
  • Select Tables
  • Manipulate the Imported Tables
  • Assign File Names
  • Assign Index File Names
  • Select the Metadata Model
  • Import the Metadata

3 Installing Oracle Database Gateway for VSAM

• Overview of Oracle Database Gateway for VSAM
• System Requirements for Oracle Database Gateway for VSAM
  • Hardware Requirements for Oracle Database Gateway for VSAM
  • Software Requirements for Oracle Database Gateway for VSAM
• Gateway Installation Configurations
• Gateway Installation Methods
  • Interactive Installation Method
  • Automated Installation Method Using Response Files
• Gateway Installation Considerations
  • Release Notes
  • Hardware and Software Certification
  • Multiple ORACLE_HOME Directories
    • Installing the Software on a System with an Existing Oracle Installation
• Upgrades
• Accessing the Installation Software
  • Downloading Oracle Software from the Oracle Technology Network Web Site
    • Downloading the Installation Files
    • Extracting the Installation Files
  • Copying the Gateway Software to a Hard Disk
    • Mounting the Installation Media
    • Copying the Oracle Database Gateway Software to a Hard Disk
• Running the Oracle Universal Installer

4 Configuring Oracle Database Gateway for VSAM

• Configuring the Gateway
  • Choose a System Identifier for the Gateway
  • Customize the Initialization Parameter File
• Configuring Oracle Net Services Listener for the Gateway
  • Configure Oracle Net Services Oracle Net Listener for the Gateway
    • Example of Address to Listen On in listener.ora File
    • Example of Gateway to Start in listener.ora File
  • Stop and Start the Oracle Net Listener for the Gateway
• Configuring the Oracle Database for Gateway Access
  • Configuring Oracle Net Services for the Oracle Database
    • Configuring tnsnames.ora
• Creating Database Links
• Gateway Password Encryption Tool
• Configuring the Gateway for Multiple VSAM Databases
  • Multiple Databases Example: Configuring the Gateway
  • Multiple Databases Example: Configuring Oracle Net Services Listener
  • Multiple Databases Example: Stopping and Starting the Oracle Net Listener
  • Multiple Databases Example: Configuring the Oracle Database for Gateway Access
    • Configuring Oracle Net Services on the Oracle Database for Multiple Gateway Instances
  • Multiple Databases Example: Accessing VSAM Data
• Performing Configuration Tasks
  • Configuring for Global Transactions
  • Enabling Automatic Recovery
• Testing the VSAM Data Source
  • Sample Log File

Part III Installing and Configuring Oracle Database Gateway for IMS

5 Configuring Access to IMS Data

• Setting Up Access to a Computer Running Oracle Connect for IMS, VSAM, and Adabas Gateways
• Setting Up an IMS Data Source
  • Defining the IMS-DLI Data Source
    • Setting Up the Daemon Workspace
    • Defining the IMS-DLI Data Source Connection
    • Configuring the IMS/DB DLI Data Source Properties
  • Defining the IMS/DB DBCTL Data Source
    • Define the IMS/DB DBCTL Data Source Connection
    • Configure the IMS/DB DBCTL Data Source Properties
    • Accessing IMS/DB Data under CICS
  • Defining the IMS/DB DBDC Data Source
    • Define the IMS/DB DBDC Data Source Connection
    • Configure the IMS/DB DBDC Data Source Properties
    • Access IMS/DB Data under IMS/TM
• Setting Up the IMS/DB Data Source Metadata
  • Select the Input Files
  • Apply Filters
  • Select Tables
  • Match DBD to COBOL
  • Manipulate the Imported Records
  • Select the Metadata Model
  • Import the Metadata

6 Installing Oracle Database Gateway for IMS

• Overview of Oracle Database Gateway for IMS
• System Requirements for Oracle Database Gateway for IMS
  • Hardware Requirements for Oracle Database Gateway for IMS
  • Software Requirements for Oracle Database Gateway for IMS
• Gateway Installation Configurations
• Gateway Installation Methods
  • Interactive Installation Method
  • Automated Installation Method Using Response Files
• Gateway Installation Considerations
  • Release Notes
  • Hardware and Software Certification
  • Multiple ORACLE_HOME Directories
    • Installing the Software on a System with an Existing Oracle Installation
• Upgrades
• Accessing the Installation Software
  • Downloading Oracle Software from the Oracle Technology Network Web Site
    • Downloading the Installation Files
    • Extracting the Installation Files
  • Copying the Gateway Software to a Hard Disk
    • Mounting the Installation Media
    • Copying the Oracle Database Gateway Software to a Hard Disk
• Running the Oracle Universal Installer

7 Configuring Oracle Database Gateway for IMS

• Configuring the Gateway
  • Choose a System Identifier for the Gateway
  • Customize the Initialization Parameter File
• Configuring Oracle Net Services Listener for the Gateway
  • Configure Oracle Net Services Oracle Net Listener for the Gateway
    • Example of Address to Listen On in listener.ora File
    • Example of Gateway to Start in listener.ora File
  • Stop and Start the Oracle Net Listener for the Gateway
• Configuring the Oracle Database for Gateway Access
  • Configuring Oracle Net Services for the Oracle Database
    • Configuring tnsnames.ora
• Creating Database Links
• Gateway Password Encryption Tool
• Configuring the Gateway for Multiple IMS Databases
  • Multiple Databases Example: Configuring the Gateway
  • Multiple Databases Example: Configuring Oracle Net Services Listener
  • Multiple Databases Example: Stopping and Starting the Oracle Net Listener
  • Multiple Databases Example: Configuring the Oracle Database for Gateway Access
    • Configuring Oracle Net Services on the Oracle Database for Multiple Gateway Instances
  • Multiple Databases Example: Accessing IMS Data
• Performing Configuration Tasks
  • Configuring for Global Transactions
  • Enabling Automatic Recovery
• Testing the IMS Data Source
  • Sample Log File

Part IV Installing and Configuring Oracle Database Gateway for Adabas

8 Configuring Access to Adabas Data

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

9 Installing Oracle Database Gateway for Adabas

• Overview of Oracle Database Gateway for Adabas
• System Requirements for Oracle Database Gateway for Adabas
  • Hardware Requirements for Oracle Database Gateway for Adabas
  • Software Requirements for Oracle Database Gateway for Adabas
• Gateway Installation Configurations
• Gateway Installation Methods
  • Interactive Installation Method
  • Automated Installation Method Using Response Files
• Gateway Installation Considerations
  • Release Notes
  • Hardware and Software Certification
  • Multiple ORACLE_HOME Directories
    • Installing the Software on a System with an Existing Oracle Installation
• Upgrades
• Accessing the Installation Software
  • Downloading Oracle Software from the Oracle Technology Network Web Site
    • Downloading the Installation Files
    • Extracting the Installation Files
  • Copying the Gateway Software to a Hard Disk
    • Mounting the Installation Media
    • Copying the Oracle Database Gateway Software to a Hard Disk
• Running the Oracle Universal Installer

10 Configuring Oracle Database Gateway for Adabas

• Configuring the Gateway
  • Choose a System Identifier for the Gateway
  • Customize the Initialization Parameter File
• Configuring Oracle Net Services Listener for the Gateway
  • Configure Oracle Net Services Oracle Net Listener for the Gateway
    • Example of Address to Listen On in listener.ora File
    • Example of Gateway to Start in listener.ora File
  • Stop and Start the Oracle Net Listener for the Gateway
• Configuring the Oracle Database for Gateway Access
  • Configuring Oracle Net Services for the Oracle Database
    • Configuring tnsnames.ora
• Creating Database Links
• Gateway Password Encryption Tool
• Configuring the Gateway for Multiple Adabas Databases
  • Multiple Databases Example: Configuring the Gateway
  • Multiple Databases Example: Configuring Oracle Net Services Listener
  • Multiple Databases Example: Stopping and Starting the Oracle Net Listener
  • Multiple Databases Example: Configuring the Oracle Database for Gateway Access
    • Configuring Oracle Net Services on the Oracle Database for Multiple Gateway Instances
  • Multiple Databases Example: Accessing Adabas Data
• Performing Configuration Tasks
  • Configuring for Global Transactions
  • Enabling Automatic Recovery
• 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

• System Requirements for Oracle Studio for IMS, VSAM, and Adabas Gateways
  • Hardware Requirements for Oracle Studio for IMS, VSAM, and Adabas Gateways
  • Software Requirements for Oracle Studio for IMS, VSAM, and Adabas Gateways
• Installing Oracle Studio for IMS, VSAM, and Adabas Gateways on Linux (SH Installation)

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

• Using Workbench Parts
  • Main Screen
  • Main Menu Bar
  • Working with Views
    • Customizing Views
    • Properties View
    • Error Log View
    • Configuration View
    • Metadata View
  • Working with Perspectives
    • Design Perspective
    • Runtime Perspective
    • Selecting a Perspective
• Setting Oracle Studio for IMS, VSAM, and Adabas Gateways Preferences
  • Studio
    • Configuration
    • Metadata
    • Runtime Manager
  • Keys
    • Default Keyboard Shortcuts

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

• Starting and Stopping Daemons
  • Starting a Daemon
    • Enabling Automatic Startup
    • Manually Starting a Daemon on z/OS Platforms
    • Starting Multiple Daemons
  • Stopping a Daemon
    • Shutting Down a Daemon Using Oracle Studio for IMS, VSAM, and Adabas Gateways
    • Shutting Down a Daemon Using the Command Line
    • Disabling a Workspace
  • Checking the Daemon
• Managing Daemon Configurations
  • Daemon Configuration Groups
  • Adding and Editing Daemon Configurations
  • Configuring Logging
• Adding and Editing Workspaces
  • Adding a Workspace
  • Editing a Workspace
    • WS Info
    • WS Server
    • WS Logging
    • WS Security
    • WS Governing
• Managing Binding Configurations
  • Server Binding
  • Client Binding
  • Binding Syntax
    • <remoteMachines> Statement
    • <datasources> Statement
    • Sample Binding
  • Environment Properties
    • Sample Environment Properties

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

• Managing Design Time Security
  • Setting Up the Password Caching Policy in Oracle Studio for IMS, VSAM, and Adabas Gateways
  • Setting Up Administration Access to a Machine
  • Assigning Design Roles
  • Assigning Authorization Rights to a Workspace
  • Setting Up a Master Password for a User Profile
• Managing Runtime Security
  • Granting Daemon Administration Rights to Users
  • Granting Workspace Administration Rights to Users
  • Granting Workspace Access Rights to a User
  • Accessing a Server through a Firewall
    • Specifying a Port Range for Workspace Servers
    • Accessing a Server Using Fixed NAT
  • Encrypting Network Communications
    • Transport Encryption
    • Setting an Encryption Protocol on the Gateway Side
    • Specifying the Encryption Key on the Server Machine
  • Setting Up Impersonation

Part VI Appendixes

A Using Response Files for Non-Interactive Installation

• Introduction
• Installation Overview
• Creating the oraInst.loc File
• Preparing a Response File
  • Editing a Response File Template
  • Recording a Response File
• Running Oracle Universal Installer in Silent or Suppressed Mode

B Initialization Parameters

• Initialization Parameter File Syntax
• HS_DB_DOMAIN
• HS_DB_INTERNAL_NAME
• HS_DB_NAME
• HS_DESCRIBE_CACHE_HWM
• HS_LANGUAGE
  • Character Sets
  • Language
  • Territory
• HS_LONG_PIECE_TRANSFER_SIZE
• HS_OPEN_CURSORS
• HS_RPC_FETCH_REBLOCKING
• HS_RPC_FETCH_SIZE
• HS_TRANSACTION_MODEL
• IFILE
• HS_FDS_CONNECT_INFO
• HS_FDS_PARSER_TOKEN_SIZE
• HS_FDS_RECOVERY_ACCOUNT
• HS_FDS_RECOVERY_PWD
• HS_FDS_TRACE_LEVEL
• HS_NLS_NCHAR
• HS_NLS_NUMERIC_CHARACTER
• HS_FDS_DATASOURCE_NAME
• HS_FDS_ACCESS_METHOD

C Oracle Database Gateway Troubleshooting

• Verify Requirements
• What to do if an Installation Error Occurs
• Reviewing the Log of an Installation Session
• Silent Mode Response File Error Handling
• Cleaning Up after a Failed Installation

Index