Contents

Title and Copyright Information

List of Tables

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

1 Overview of the Oracle Application Server Integration Adapter for IMS/DB

Overview of Application Integration

Overview of IMS/DB and Oracle Application Server Integration Adapter for IMS/DB

IMS/DB Data

Accessing IMS/DB Data Under CICS

Accessing IMS/DB Data Under IMS/TM

Accessing IMS/DB Data Directly

Architecture of the Oracle Application Server Integration Adapter for IMS/DB

Inbound Interactions

Integrating Oracle Application Server ProcessConnect with the Adapter for IMS/DB

The Modeling Phase

Runtime

Modeling the IMS/DB Adapter Using Oracle Studio

The Configuration Perspective

The Metadata Perspective

The Metadata Import Perspective

The Runtime Manager Perspective

2 Installing the Oracle Application Server Integration Adapter for IMS/DB

Before You Begin

Determining the Hardware and Software Requirements for the OS/390

Hardware Requirements

Software Requirements

Determining the Hardware and Software Requirements for Windows

Hardware Requirements

Software Requirements

Installing Oracle Connect for IMS/DB on an OS/390 Platform

Installation Worksheet

Preinstallation Instructions

Installing the Kit on the Mainframe

Installation Instructions

Postinstallation Instructions

General Postinstallation Procedures

Starting the Daemon

Setting Up Oracle Connect for IMS/DB for Reentrancy

Setting Up Oracle Connect for IMS/DB to Work Under CICS

Setting Up Oracle Connect for IMS/DB to Work Under IMS/TM

Updating Oracle Connect with IMS/DB

Installing Oracle Studio

Installing Oracle Studio from the CD-ROM

Configuring Oracle Connect for IMS/DB

Task: Setting Up the IBM OS/390 Machine

Securing Access to Oracle Connect for IMS/DB

Setting Password Access to Oracle Studio

Task: Setting Up a Master Password to Access Oracle Studio

Specifying Users with Administrative Rights to a Machine

Task: Setting Administrative Rights to a Machine

Setting Up Runtime User Access to the IBM OS/390 Machine

3 Modeling Interactions for Oracle Application Server Integration Adapter for IMS/DB

Setting Up the IMS/DB Data Source

Task: Adding the IMS/DB Data Source Definition

Importing Metadata for the IMS/DB Data Source

Task 1: Defining an Import Procedure

Task 2: Generating Metadata for the IMS/DB Data

Setting Up the Oracle Connect for IMS/DB Backend Adapter

Task: Setting Up the Adapter

Generating Outbound Interactions

Task 1: Setting Up the Metadata Perspective

Task 2: Generating Outbound Interactions

Task 3: Modifying the Generated Outbound Interactions

Generating Inbound Interactions

Task 1: Defining an Import Procedure

Task 2: Generating Inbound Interactions

4 Using Interactions in a Business Process

Adding the IMS/DB Adapter in Oracle Application Server ProcessConnect

Defining the Delivery Channel

Task: Setting Up the Delivery Channel

Modifying an Adapter in Oracle Studio

Comparing a ProcessConnect XSD to an Oracle Connect Record Schema

5 Oracle Application Server Integration Adapter for IMS/DB Features and Restrictions

Accessing IMS/DB Using SQL

Generating Hierarchical Results

Accessing Hierarchical Data Using SQL

Flattening Hierarchical Data Using SQL

Sending Inbound Interactions Using a CICS Transaction

Task 1: Setting Up the IBM OS/390 Machine

Task 2: Setting Up a Call to the CICS Transaction

Sending Inbound Interactions Using an IMS/TM Transaction

Task 1: Setting Up the IBM OS/390 Machine

Task 2: Setting Up a Call to the IMS/TM Transaction

High Availability with Oracle Connect

Known Restrictions

IMS/DB Data Source Restrictions

6 Troubleshooting the Oracle Application Server Integration Adapter for IMS/DB

Design-Time Troubleshooting

Specifying the Wrong Adapter Name

Specifying the Wrong Workspace Name

Specifying the Wrong Machine

Specifying the Wrong Port Number

When the Connection with the OS/390 Machine Is Down

Troubleshooting the Daemon

Starting the Daemon

Task: Starting the Daemon

Shutting Down the Daemon

Monitoring the Daemon During Runtime

Daemon (Machine) 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

7 Configuring the OS/390 Working Environment

Configuring the Daemon for High Availability

Task: Adding a New Daemon Workspace Configuration

Task: Editing the Workspace

Task: Configuring the Server Mode

Configuring a Binding Environment

Task: Setting a Binding Environment

comm Category

debug Category

miscellaneous Category

odbc Category

oledb Category

optimizer Category

queryProcessor Category

transactions Category

tuning Category

A The Oracle Connect for IMS/DB Metadata Definitions

Metadata for the IMS/DB Data Source

General Tab

Columns Tab

Indexes Tab

Statistics Tab

Generating Statistics

Source Tab

Interaction Metadata for the Adapter

General Tab

Interaction General Tab

Interaction Advanced Tab

Schema General Tab

Schema Record Tab

Source Tab

B Datatype Support

Datatype Mapping for the IMS/DB Data Source

IMS/DB Data Source Metadata Datatypes

Datatype Mapping for the Oracle Connect for IMS/DB

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 Daemon Configuration Settings

Daemon Control

Daemon Logging

Daemon Security

Workspaces

WS Info.

WS Server

WS Logging

WS Security

WS Governing

E COBOL APIs to Applications

Connection APIs

The Connect Function

The Disconnect Function

Transaction APIs

The Set Autocommit Function

The Transaction Commit Function

The Transaction Rollback Function

The Execute Function

The Get Event Function

The Ping Function

The Get Error Function

F National Language Settings

Defining the Language and Codepage

Index