Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction

• OracleAS Adapter for VSAM Overview
  • VSAM Data
    • Accessing VSAM Data
• 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 z/OS Hardware and Software Requirements
    • Hardware Requirements
    • Software Requirements
• Installing Oracle Connect on an IBM z/OS Series Platform
  • Installation Worksheet
  • Preinstallation Instructions
  • Importing the Installation Kit
  • Installation Instructions
  • Post-Installation Instructions
    • Post-Installation 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
  • Oracle Studio Requirements
  • Installing Oracle Studio on Windows
  • Installing Oracle Studio on Linux
    • Installing Oracle Studio with the Wizard (SH installation)
    • Installing with a Silent Installation (RPM)
• Configuring Oracle Connect
  • Setting Up the IBM 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 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
  • 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.5 VSAM Adapter
• Using the CCI API to Develop Applications
• Configuring Multiple Adapters
• Updating Configuration Information

4 BPEL Process Manager Examples

• Getting Started
• Deploy a BPEL Outbound Process
  • Beginning Tasks
  • Design-Time Configuration
    • Create a BPEL Project for a BPEL Outbound Process
    • Create a Database Adapter to Read the Doctor Data
    • Design a BPEL Outbound Process to Read the String
    • Create a Partner Link to the Database Adapter
    • Edit the Invoke_1 Activity
    • Edit the Assign_1 Activity
  • Runtime Configuration

5 Configuring an OracleAS Adapter for VSAM for Outbound Interactions

• Creating Outbound Interactions with the OracleAS Adapter for VSAM
  • Requirements
• Adding the VSAM Hospital Data Source
  • Prepare the System
  • Set up Machine Access to Oracle Connect
  • Add a VSAM Data Source
  • Import the Metadata
• Create the findDoctor and findPatient Interactions
  • Add a Database Adapter
  • Create Interactions

6 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

7 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
  • Debug
  • General
  • Language
  • Modeling
  • ODBC
  • OLEDB
  • Optimizer
  • Parallel Processing
  • Query Processor
  • Transaction
  • Tuning
  • XML
• Migration Considerations
• Security Considerations
  • Setting Design Time Security
  • Setting Run Time Security
• Transaction Support

A Advanced Tuning of the Metadata

• Metadata for VSAM
  • General Tab
  • Columns Tab
    • Column Definition Section
    • Column Properties
  • Indexes Tab
    • Table Information
    • Properties
  • Statistics Tab
    • Generating Statistics
  • Advanced Tab
• Adapter Metadata
  • Adapter Metadata General Properties
  • Adapter Metadata Interactions
    • Interaction Advanced Tab
  • Adapter Metadata Schema Records
  • Adapter Metadata XML

B Back-end Adapter Data Type Support

• Data Type Mapping

C Advanced Tuning of the Daemon

• Control
• Logging
• Security
• Workspaces
  • General
  • Server Mode
  • 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

F Editing XML Files in Oracle Studio

• Preparing to Edit XML Files in Oracle Studio
• Making Changes to the XML File
  • Remove Objects
  • Add DTD Information
  • Edit Namespaces
  • Add Elements and Attributes
  • Replace an Element

Index