User ManualTable of ContentsContents5Preface11Audience11Documentation Accessibility11Related Documents12Conventions121 Introduction13OracleAS Adapter for IMS/DB Overview13OracleAS Adapter for IMS/DB Architecture14Integration Flow from Oracle Application Server to the Legacy Application142 Installing and Configuring the OracleAS Adapter for IMS/DB15Preinstallation Tasks15IBM z/OS Hardware and Software Requirements15Hardware Requirements15Software Requirements16Installing Oracle Connect on an IBM z/OS Series Platform16Installation Worksheet17Preinstallation Tasks18Importing the Installation Kit19Installation Instructions19Post-Installation Instructions22Post-Installation Procedures22Starting the Daemon24Setting Up Oracle Connect for Reentrancy24Setting Up Oracle Connect to Update IMS/DB Data25Updating an Existing Oracle Connect Installation with IMS/DB25Installing Oracle Studio26Oracle Studio Requirements26Installing Oracle Studio on Windows27Installing Oracle Studio on Linux27Installing Oracle Studio with the Wizard (SH installation)27Installing with a Silent Installation (RPM)27Configuring Oracle Connect27Setting Up the IBM z/OS Platform in Oracle Studio28Securing Access to Oracle Connect29Setting Password Access to Oracle Studio29Specifying Users with Administrative Rights30Setting Up Run-Time User Access to the IBM z/OS Platform31Modeling Interactions for OracleAS Adapter for IMS/DB33Setting Up the IMS/DB Data Source33Configuring the Data Source Driver35Configuring the Data Source Driver Advanced Properties37Importing Metadata for the IMS/DB Data Source39Selecting the Imput Files39Applying Filters41Selecting Tables43Matching DBD to COBOL43Import Manipulation44Metadata Model Selection52Import the Metadata54Setting Up an Oracle Connect Adapter55Generating Outbound Interactions56Modifying Existing Interactions593 Integrating OracleAS Adapter for IMS/DB with OC4J61Integrating OracleAS Adapter for IMS/DB with OC4J61Configuring the J2CA 1.5 IMS/DB Adapter62Using the CCI API to Develop Applications63Configuring Multiple Adapters64Updating Configuration Information644 Integrating OracleAS Adapters for IMS/DB with Oracle BPEL Process Manager65Integrating OracleAS Adapters for IMS/DB with Oracle BPEL Process Manager65Configuring Oracle BPEL Process Manager66Setting up the Connection to the Oracle Connect Server66Checking Metadata Availability Using Oracle JDeveloper66Configuring the WSDL for Outbound Applications665 BPEL Process Manager Examples71Getting Started71Deploy a BPEL Outbound Process72Beginning Tasks72Design-Time Configuration73Create a BPEL Project for a BPEL Outbound Process73Create a Database Adapter to Read the Doctor Table74Design a BPEL Outbound Process to Read the String75Create a Partner Link to the Database Adapter76Edit the Invoke_1 Activity77Edit the Assign_1 Activity78Runtime Configuration796 6 Configuring an OracleAS Adapter for IMS/DB for Outbound Interactions81Creating Outbound Interactions with the OracleAS Adapter for IMS/DB81Requirements81Adding the IMS/DB Hospital Data Source81Prepare the System81Set up Machine Access to Oracle Connect82Add an IMS/DB Data Source82Import the Metadata83Create the findDoctor and findPatient Interactions84Add a Database Adapter84Create Interactions847 Troubleshooting OracleAS Adapter for IMS/DB87Troubleshooting the Daemon87Starting the Daemon87Task: Starting the Daemon88Shutting Down the Daemon88Monitoring the Daemon During Run Time88Daemon (Computer) Options88Workspace Options89Server Options90Daemon Logs90The Daemon Log Monitor91The Workspace Log Monitor91The Server Log Monitor91Resolving Communication Errors92Resolving Specific Errors928 Advanced Features of OracleAS Adapter for IMS/DB105Configuring the Daemon for High Availability105Adding a New Daemon Workspace Configuration105Editing the Workspace106Configuring the Server Mode106Configuring a Binding Environment110Debug111General112Language112Modeling113ODBC113OLEDB113Optimizer113Query Processor113Parallel Processing113Transactions113Tuning114XML114Migration Considerations115Security Considerations115Setting Design Time Security116Setting Runtime Security116Transaction Support117A Advanced Tuning of the Metadata119Metadata for the IMS/DB Data Source119General Tab120Columns Tab121Column Definition Section122Column Properties123Indexes Tab125Table Information125Properties126Statistics Tab126Generating Statistics128Advanced Tab129Adapter Metadata131Adapter Metadata General Properties131Adapter Metadata Interactions133Interaction Advanced Tab134Adapter Metadata Schema Records136Adapter Metadata XML138B Back-end Adapter Data Type Support139Data Type Mapping139C Advanced Tuning of the Daemon141Control141Logging143Security145Workspaces147General147Server Mode151Security156D Supported SQL Syntax and SQL Enhancements159Supported SQL Statements159Supported Operators159Supported Functions160SQL Enhancements161Generating Hierarchical Results161Accessing Hierarchical Data Using SQL162Flattening Hierarchical Data Using SQL162Using an Alias162E Globalization Settings163Defining the Language and Codepage163Index167A167B167C167D167E167F168G168H168I168L168M168N168O168P168Q168R168S168T169U169W169X169Y169Size: 1.36 MBPages: 170Language: EnglishOpen manual