Contents

List of Figures

List of Tables

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 Installing and Configuring the OracleAS Adapter for IMS/DB

• Preinstallation Tasks
  • IBM OS/390 or z/OS Hardware and Software Requirements
    • Hardware Requirements
    • Software Requirements
  • Windows Hardware and Software Requirements
    • Hardware Requirements
    • Software Requirements
• Installing Oracle Connect on an IBM OS/390 or z/OS Series Platform
  • Installation Worksheet
  • Preinstallation Tasks
  • Importing the Installation Kit
  • Installation Instructions
  • Postinstallation Instructions
    • Postinstallation Procedures
    • Starting the Daemon
    • Setting Up Oracle Connect for Reentrancy
    • Setting Up Oracle Connect to Update IMS/DB Data
• Updating an Existing Oracle Connect Installation with IMS/DB
• Installing Oracle Studio
  • Installing Oracle Studio from the CD-ROM
• Configuring Oracle Connect
  • Setting Up the IBM OS/390 or 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 OS/390 or z/OS Platform
  • Modeling Interactions for OracleAS Adapter for IMS/DB
    • Setting Up the IMS/DB Data Source
    • Configuring the Data Source Driver
    • Importing Metadata for the IMS/DB Data Source
    • Setting Up an Oracle Connect Adapter
    • Generating Outbound Interactions
    • Modifying Existing Interactions
  • Viewing the XML Schema
  • Creating XML Schemas

3 Integrating OracleAS Adapter for IMS/DB with OC4J

• Integrating OracleAS Adapter for IMS/DB with OC4J
• Configuring the J2CA 1.5 IMS/DB Adapter
• Using the CCI API to Develop Applications
• Configuring Multiple Adapters
• Updating Configuration Information

4 Integrating OracleAS Adapters for IMS/DB with Oracle BPEL Process Manager

• Overview of Integrating OracleAS Adapters for IMS/DB with Oracle BPEL Process Manager
• Configuring Oracle BPEL Process Manager to interact with the OracleAS Adapter for IMS/DB
  • Setting up the Connection to the Oracle Connect Server
  • Checking Metadata Availability Using Oracle JDeveloper
  • Configuring the WSDL for Outbound Applications

5 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

6 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
  • comm Category
  • debug Category
  • miscellaneous Category
  • odbc Category
  • oledb Category
  • optimizer Category
  • queryProcessor Category
  • transactions Category
  • tuning Category
• Migration Considerations
• Security Considerations
  • Setting Design Time Security
  • Setting Runtime Security
• Transaction Support

A Advanced Tuning of the Metadata

• Metadata for the IMS/DB Data Source
  • General Tab
  • Columns Tab
  • Indexes Tab
  • Statistics Tab
    • Generating Statistics
  • Source Tab
• Metadata for the Back-end Adapter
  • General Tab
  • Interaction Tab
  • Interaction Advanced Tab
  • Schema General Tab
  • Schema Record Tab
  • Source Tab

B Back-end Adapter Data Type Support

• Data Type Mapping

C Advanced Tuning of the Daemon

• Daemon Control
• Daemon Logging
• Daemon Security
• Workspaces
  • WS Info.
  • WS Server
  • WS Logging
  • WS 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 Codepage

Index