Contents

List of Figures

List of Tables

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 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
  • 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 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

5 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 Back-end Adapter Data Type Support

• Data Type Mapping

C Advanced Tuning of the Daemon

• Daemon Control
• Daemon Logging
• Daemon Security
• Workspaces
  • WS Info.
  • WS Server
  • WS Logging
  • WS 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

Index