Contents

List of Tables

Title and Copyright Information

Preface

Audience

Documentation Accessibility

Related Documentation

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

Generating Inbound Interactions

Modifying Existing Interactions

Viewing the XML Schema

Creating XML Schemas

3 Deployment and Integration with OC4J

Integrating OracleAS Adapter for IMS/DB with OC4J

Configuring the J2CA 1.0 IMS/DB Adapter

Using the CCI API to Develop Applications

Configuring Multiple Adapters

Updating Configuration Information

4 Deployment and Integration with Oracle BPEL Process Manager

Integrating OracleAS Adapter for IMS/DB with Oracle BPEL Process Manager

Using Oracle Adapter for IMS/DB as Outbound Link

Using Oracle Adapter for IMS/DB as Inbound Link

Updating Outbound and Inbound Interactions

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 General Tab

Interaction Advanced Tab

Schema General Tab

Schema Record Tab

Source Tab

B IMS/DB Back-end Adapter Data Type Support

Data Type Mapping

C 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

D Advanced Tuning of the Daemon

Daemon Control

Daemon Logging

Daemon Security

Workspaces

WS Info.

WS Server

WS Logging

WS Security

E Globalization Settings

Defining the Language and Codepage

Index