Contents

List of Tables

Title and Copyright Information

Preface

Audience

Documentation Accessibility

Related Documentation

Conventions

1 Introduction

OracleAS Adapter for VSAM Overview

VSAM Data

Accessing VSAM Data Under CICS

Accessing VSAM Data Directly

OracleAS Adapter for VSAM Architecture

Integration Flow from Oracle Application Server to the Legacy Application

2 Installing and Configuring OracleAS Adapter for VSAM

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 Instructions

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

Updating an Existing Oracle Connect Installation with VSAM

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 VSAM

Setting Up the VSAM Data Source

Importing Metadata for the VSAM Data Source

Setting Up an Oracle Connect Adapter

Generating Outbound Interactions

Generating Inbound Interactions

Viewing the XML Schema

Creating XML Schemas

3 Deployment and Integration with the Oracle OC4J Container

Integrating OracleAS Adapter for VSAM with OC4J

Configuring the J2CA 1.0 VSAM 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 VSAM with Oracle BPEL Process Manager

Using Oracle Adapter for VSAM as Outbound Link

Using Oracle Adapter for VSAM as Inbound Link

Updating Outbound and Inbound Interactions

5 Troubleshooting OracleAS Adapter for VSAM

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 VSAM

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 Run Time Security

Transaction Support

A Advanced Tuning of the Metadata

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