Skip Headers
Oracle® Database Gateway for IMS, VSAM, and Adabas Installation and Configuration Guide
11g Release 1 (11.1) for Microsoft Windows
Part Number B32525-01
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
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.1.1
Checking the Hardware Requirements
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.2
Copying the 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.1.1
Checking the Hardware Requirements
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.2
Copying the 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.1.1
Checking the Hardware Requirements
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.2
Copying the 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
Using Response Files to Install Oracle Components in Non-Interactive Mode
A.3
Customizing a Sample Response File
A.4
Creating a New Response File
A.5
Running Oracle Universal Installer and Specifying a Response File
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.3.1
Fatal Errors
C.4
Noninteractive Installation Response for File Error Handling
C.5
Cleaning Up after a Failed Installation
Index