Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction

• OracleAS Adapter for IMS/DB Overview
• OracleAS Adapter for IMS/DB Architecture
  • Integration Flow from Oracle Application Server to the Legacy Application

2 Configuring the OracleAS Adapter for IMS/DB

• Setting Up the IBM z/OS Platform in Oracle Studio
• Securing Access to Oracle Connect
  • Setting Password Access to Oracle Studio
  • Specifying Users with Administrative Rights
  • Setting Up Run-Time User Access to the IBM z/OS Platform
• Modeling Interactions for OracleAS Adapter for IMS/DB
  • Setting Up the IMS/DB Data Source
  • Configuring the Data Source Driver
    • Configuring the Data Source Driver Advanced Properties
  • Importing Metadata for the IMS/DB Data Source
    • Selecting the Imput Files
    • Applying Filters
    • Selecting Tables
    • Matching DBD to COBOL
    • Import Manipulation
    • Metadata Model Selection
    • Import the Metadata
  • Setting Up an Oracle Connect Adapter
  • Generating Outbound Interactions
  • Modifying Existing Interactions

3 Integrating OracleAS Adapter for IMS/DB with WebLogic

• Overview of Integrating OracleAS Adapter for IMS/DB with WebLogic
• Configuring the IMS/DB Adapter
• High Availability

4 Integrating OracleAS Adapters for IMS/DB

• Configuring OracleAS Adapter for IMS/DB
  • Creating JCA Configuration Files
  • Configuring the Binding for Outbound Interactions

5 Configuring an OracleAS Adapter for IMS/DB for Outbound Interactions

• Creating Outbound Interactions with the OracleAS Adapter for IMS/DB
  • Requirements
• Adding the IMS/DB Hospital Data Source
  • Prepare the System
  • Set up Machine Access to Oracle Connect
  • Add an IMS/DB Data Source
  • Import the Metadata
• Create the findDoctor and findPatient Interactions
  • Add a Database Adapter
  • Create Interactions
  • Create the JCA Configuration Files

6 Creating the Project in JDeveloper Examples

• Getting Started
  • Prerequisites
  • Beginning Tasks
• Deploy a BPEL Outbound Process
  • Design-Time Configuration
    • Create a BPEL Project for a BPEL Outbound Process
    • Use a Third-Party Adapter to Read the Doctor Table
    • Design a BPEL Outbound Process
    • Edit the Invoke_1 Activity
    • Deploy the Project
  • Run-time Configuration
• Deploy a Mediator Process
  • Design-Time Tasks
    • Create a Mediator Project for a Mediator Outbound Process
    • Use a Third-Party Adapter to Read the Doctor Data
    • Design an Outbound Mediator
    • Create Mapping Rules and Map the Files
    • Deploy the Project

7 Troubleshooting OracleAS Adapter for IMS/DB

• Troubleshooting the Daemon
  • Starting the Daemon
    • Task: Starting the Daemon
  • Shutting Down the Daemon
  • Monitoring the Daemon During Run Time
    • Daemon (Computer) Options
    • Workspace Options
    • Server Options
  • Daemon Logs
    • The Daemon Log Monitor
    • The Workspace Log Monitor
    • The Server Log Monitor
• Resolving Communication Errors
• Resolving Specific Errors

8 Advanced Features of OracleAS Adapter for IMS/DB

• Configuring the Daemon for High Availability
  • Adding a New Daemon Workspace Configuration
  • Editing the Workspace
  • Configuring the Server Mode
• Configuring a Binding Environment
  • Debug
  • General
  • Language
  • Modeling
  • ODBC
  • OLEDB
  • Optimizer
  • Query Processor
  • Parallel Processing
  • Transactions
  • Tuning
  • XML
• Migration Considerations
• Security Considerations
  • Setting Design Time Security
  • Setting Run Time Security
• Transaction Support

A Advanced Tuning of the Metadata

• Metadata for the IMS/DB Data Source
  • General Tab
  • Columns Tab
    • Column Definition Section
    • Column Properties
  • Indexes Tab
    • Table Information
    • Properties
  • Statistics Tab
    • Generating Statistics
  • Advanced Tab
• Adapter Metadata
  • Adapter Metadata General Properties
  • Adapter Metadata Interactions
    • Interaction Advanced Tab
  • Adapter Metadata Schema Records
  • Adapter Metadata XML

B Back-end Adapter Data Type Support

• Data Type Mapping

C Advanced Tuning of the Daemon

• Control
• Logging
• Security
• Workspaces
  • General
  • Server Mode
  • Security

D Supported SQL Syntax and SQL Enhancements

• Supported SQL Statements
• Supported Operators
• Supported Functions
• SQL Enhancements
  • Generating Hierarchical Results
  • Accessing Hierarchical Data Using SQL
  • Flattening Hierarchical Data Using SQL
    • Using an Alias

E Globalization Settings

• Defining the Language and Code Page

Index