Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction

• OracleAS CDC adapter for VSAM Overview
• OracleAS CDC Adapter for VSAM Architecture
  • The Staging Area

2 Installing Oracle Connect and Oracle Studio

• Preinstallation Tasks
  • z/OS Hardware and Software Requirements
    • Hardware Requirements
    • Software Requirements
  • Windows Hardware and Software Requirements
    • Hardware Requirements
    • Software Requirements
  • UNIX Requirements
• Installing Oracle Connect on an IBM z/OS Series Platform
  • Installation Worksheet
  • Preinstallation Instructions
  • Importing the Installation Kit
    • Transferring the Kit to the Dataset
  • Installation Instructions
  • Data Source Configuration Instructions
  • Post-Installation Instructions
    • Copy and Install Programs into CICS
    • 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 Connect on UNIX
  • Installing Oracle Connect on a UNIX Platform
    • Preinstallation Tasks
    • Installing Oracle Connect
    • Installation Tasks
    • Post-Installation Tasks
• Installing Oracle Connect on Windows
  • Installing Oracle Connect on a Windows Platform
• 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)

3 Configuring the OracleAS CDC Adapter for VSAM

• 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
• Setting up Metadata for the OracleAS VSAM Data Source
  • Setting Up the VSAM Data Source
  • Configuring the Data Source Driver
    • VSAM (CICS) Properties
    • VSAM Properties
    • Configuring the Data Source Driver Advanced Properties
  • Importing Metadata for the VSAM Data Source
    • Select the COBOL Copybooks
    • Applying Filters
    • Selecting Tables
    • Import Manipulation
    • Create VSAM Indexes
    • Assigning File Names
    • Assigning Index File Names
    • Metadata Model Selection
    • Importing the Metadata
  • Verifying the Metadata Definition
• Setting Up a Change Data Capture with the OracleAS CDC Adapter for VSAM
  • Managing the CICS User Journal (VSAM CICS Only)
    • Setting up the CICS User Journal for VSAM
    • Print out the CICS User Journal Content
  • Configuring the Logger (VSAM Batch Only)
    • Creating the Logstream
    • Creating the CDC$PARM Data Set
    • Updating Jobs and Scripts
  • Setting up a Change Data Capture in Oracle Studio
    • Create a CDC Project
    • Set up the CDC Server
    • Set up the Staging Area Server
  • Deploying a Change Data Capture
    • Activating and Deactivating Solution Workspaces

4 Oracle BPEL Process Manager Deployment and Integration

• Overview of Oracle BPEL Process Manager Integration
• Configuring the VSAM CDC Adapter In the Application Server
  • CDC Stream Positions Table Definition
  • Configuring the VSAM CDC Adapter Connection Factory
• Configuring the Oracle BPEL Process Manager
  • Setting up the Connection to the Oracle Connect Server Metadata
  • Using JDeveloper to Integrate a CDC Inbound Process to the Inbound Application
    • Configuring a CDC Adapter Partner Link
    • Configuring WSDL
• Troubleshooting Rollback Loops

5 Runtime Tasks and Troubleshooting

• Adding and Removing Tables
• Handling Metadata Changes
• Staging Area Maintenance
• Monitoring the Change Data Capture
  • Service Context Table
  • Monitoring the Status
• Daemon Life-Cycle Tasks
  • Starting the Daemon
    • Task: Starting the Daemon
  • Shutting Down the Daemon
  • Monitoring the Daemon During Runtime
    • Daemon (Computer) Options
    • Workspace Options
    • Server Options
  • Daemon Logs
    • The Log Monitor
• Resolving Communication Errors
• Resolving Specific Errors

6 Advanced Features of OracleAS CDC 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
  • Transactions
  • Tuning
  • XML
• 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
    • 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 Advanced Tuning of the Daemon

• Control
• Logging
• Security
• Workspaces
  • General
  • Server Mode
  • Security

C Editing Properties for the OracleAS CDC Adapter for VSAM

• Editing Properties in Oracle Studio
  • Editing the OracleAS CDC Adapter Properties
• Configuration Properties
  • CDC Logger Properties
  • CDC$PARM Properties (VSAM Batch Only)
  • OracleAS CDC Adapter Configuration Properties
    • CDC Queue Adapter Properties
    • Common CDC Adapter Properties
  • Change Router Properties
  • Referential Integrity Considerations
• Access to Change Events
• Transaction Support
  • Single Program Transaction Manager
  • Logical Transaction Manager
• Security

D Back-end Adapter Data Type Support

• Data Type Mapping

E 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

F Globalization Settings

• Defining the Language and Codepage

Index