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 VSAM

Overview of Application Integration

Overview of VSAM and Oracle Application Server Integration Adapter for VSAM

VSAM Data

Accessing VSAM Data Under CICS

Accessing VSAM Data Directly

Architecture of the Oracle Application Server Integration Adapter for VSAM

Inbound Interactions

Integrating Oracle Application Server ProcessConnect with the Adapter for VSAM

The Modeling Phase

Runtime

Modeling the VSAM 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 VSAM

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 VSAM 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 VSAM for Reentrancy

Setting Up Oracle Connect for VSAM to Update VSAM Data

VSAM Running Under CICS

VSAM Not Running Under CICS

Updating Oracle Connect with VSAM

Installing Oracle Studio

Installing Oracle Studio from the CD-ROM

Configuring Oracle Connect for VSAM

Task: Setting Up the IBM OS/390 Machine

Securing Access to Oracle Connect for VSAM

Setting Password Access to Oracle Studio

Task: Setting Up a Master Password to Access Oracle Studio

Specifying Users with Administrative Rights

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 VSAM

Setting Up the VSAM Data Source

Task: Adding the VSAM Data Source Definition

Importing Metadata for the VSAM Data Source

Task 1: Defining an Import Procedure

Task 2: Generating Metadata for the VSAM Data

Setting Up an Oracle Connect for the VSAM 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 VSAM Adapter in Oracle Application Server ProcessConnect

Setting Up 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 VSAM Features and Restrictions

Accessing VSAM 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

High Availability with Oracle Connect

Known Restrictions

VSAM Data Source Restrictions

VSAM Under CICS

VSAM Not Under CICS

Array Updates

6 Troubleshooting the Oracle Application Server Integration Adapter for VSAM

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 VSAM Metadata Definitions

Metadata for the VSAM 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 VSAM Data Source

VSAM Data Source Metadata Datatypes

Datatype Mapping for Oracle Connect for VSAM

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