Summary of the content on the page No. 1
SUN SEEBEYOND
eWAY™ ADAPTER FOR VSAM
USER’S GUIDE
Release 5.1.3
Summary of the content on the page No. 2
Copyright © 2007 Sun Microsystems, Inc., 4150 Network Circle, Santa Clara, California 95054, U.S.A. All rights reserved. Sun Microsystems, Inc. has intellectual property rights relating to technology embodied in the product that is described in this document. In particular, and without limitation, these intellectual property rights may include one or more of the U.S. patents listed at http://www.sun.com/patents and one or more additional patents or pending patent applications in the U.S. and
Summary of the content on the page No. 3
Contents Contents Chapter 1 Introducing the VSAM eWay 7 About VSAM 7 About the VSAM eWay 8 eWay Operation 8 What’s New in This Release 8 About This Document 9 VSAM eWay Javadoc 9 Scope 10 Intended Audience 10 Text Conventions 10 Related Documents 10 Sun Microsystems, Inc. Web Site 11 Documentation Feedback 11 Chapter 2 Installing the VSAM eWay 12 Installing the VSAM eWay 12 Installing the VSAM eWay on an eGate supported system 13 Adding the eWay to an Existing Sun Java Composite Application Pla
Summary of the content on the page No. 4
Contents Chapter 3 Setting Properties of the VSAM eWay 20 Creating and Configuring a VSAM eWay 20 Configuring the eWay Connectivity Map Properties 20 Transaction Support Levels Between Different Versions 22 Configuring the eWay Environment Properties 23 eWay Connectivity Map Properties 24 Connectivity Map (Outbound) CP eWay Properties 25 Connectivity Map Outbound non-Transactional eWay Properties 25 eWay Environment Properties 26 Inbound VSAM eWay Properties 26 (Outbound) VSAM CP eWay Propertie
Summary of the content on the page No. 5
Contents Delete Operations 51 Using Views 52 Using Prepared Statements 52 Chapter 6 Using VSAM Operations 53 VSAM eWay Database Operations (BPEL) 53 Activity Input and Output 53 VSAM eWay Database Operations (JCD) 55 The Table 55 The Query (Select) Operation 56 The Insert Operation 57 The Update Operation 58 The Delete Operation 58 Prepared Statement 59 Batch Operations 59 Chapter 7 Implementing the VSAM eWay Sample Projects 61 About the VSAM eWay Sample Projects 61 Operations Used in the VSAM
Summary of the content on the page No. 6
Contents Configuring the Integration Server 89 Creating the Deployment Profile 89 Creating and Starting the Domain 90 Building and Deploying the Project 91 Running the Sample Project 91 Building and Deploying the prjVSAM_JCD Sample Project 92 Creating a Project 92 Creating the OTDs 92 Creating a Connectivity Map 94 Populating the Connectivity Map 94 Creating the Collaboration Definitions (Java) 95 jcdDelete Collaboration 96 jcdInsert Collaboration 96 jcdPsSelect Collaboration 97 jcdTableSelect
Summary of the content on the page No. 7
Chapter 1 Introducing the VSAM eWay Welcome to the Sun SeeBeyond eWay™ Adapter for VSAM User’s Guide. This document includes information about installing, configuring, and using the Sun Java Composite Application Platform Suite VSAM eWay™ Adapter, referred to as the VSAM eWay throughout this guide. This chapter provides a brief overview of operations, components, general features, and system requirements of the VSAM eWay. What’s in This Chapter About VSAM on page 7 About the VSAM eWay on
Summary of the content on the page No. 8
Chapter 1 Section 1.2 Introducing the VSAM eWay About the VSAM eWay Maintains information about this data, which is stored or referenced in a catalog (catalog management). Supports Entry-sequenced Data Set (ESDS) and Key-sequenced Data Set (KSDS) files. The VSAM eWay allows you to utilize and extend all of these features. For more information on VSAM, see IBM’s Web site. 1.2 About the VSAM eWay The VSAM eWay enables eGate™ Integrator to exchange data with external IBM VSAM mainframe file s
Summary of the content on the page No. 9
Chapter 1 Section 1.4 Introducing the VSAM eWay About This Document Support for Runtime LDAP Configuration: eWay configuration properties now support LDAP key values. Connection Retry Support: Allows you to specify the number of attempts to reconnect, and the interval between retry attempts, in the event of a connection failure. Relaunchable OTD Support: An OTD can be rebuilt and saved (under the same name) then relaunched back to the same Java Collaboration or BPEL. This allows you to c
Summary of the content on the page No. 10
Chapter 1 Section 1.5 Introducing the VSAM eWay Related Documents Composite Application Platform Suite Installer. To access the full Javadoc, extract the Javadoc to an easily accessible folder, and double-click the index.html file. 1.4.1 Scope This user’s guide provides a description of the VSAM eWay Adapter. It includes directions for installing the eWay, configuring the eWay properties, and implementing the eWay’s sample Projects. This document is also intended as a reference guide, listing
Summary of the content on the page No. 11
Chapter 1 Section 1.6 Introducing the VSAM eWay Sun Microsystems, Inc. Web Site 1.6 Sun Microsystems, Inc. Web Site The Sun Microsystems web site is your best source for up-to-the-minute product news and technical support information. The site’s URL is: http://www.sun.com 1.7 Documentation Feedback We appreciate your feedback. Please send any comments or suggestions regarding this document to: CAPS_docsfeedback@sun.com VSAM eWay Adapter User’s Guide 11 Sun Microsystems, Inc.
Summary of the content on the page No. 12
Chapter 2 Installing the VSAM eWay This chapter explains how to install the VSAM eWay. What’s in This Chapter Installing the VSAM eWay on page 12 ICAN 5.0 Project Migration Procedures on page 15 Installing Enterprise Manager eWay Plug-Ins on page 16 2.1 Installing the VSAM eWay The Java Composite Application Platform Suite Installer, referred to throughout this guide as the Suite Installer, is a web-based application that is used to select and upload core products, composite applications, a
Summary of the content on the page No. 13
Chapter 2 Section 2.1 Installing the VSAM eWay Installing the VSAM eWay 2.1.1 Installing the VSAM eWay on an eGate supported system Follow the directions for installing the Sun Java Composite Application Platform Suite in the Sun Java Composite Application Platform Suite Installation Guide. After you have installed Core Products, do the following: 1 From the Sun Java Composite Application Platform Suite Installer’s Select Sun Java Composite Application Suite Products to Install table (Adminis
Summary of the content on the page No. 14
Chapter 2 Section 2.1 Installing the VSAM eWay Installing the VSAM eWay 7 When prompted, restart the IDE (Integrated Development Environment) to complete the installation. Copying JAR files to the eDesigner Library The VSAM eWay SAR file no longer includes the WebSphere Information Integrator Classic Federation JDBC Driver for VSAM databases. You are required to copy the product’s JDBC JAR file (cacjdbc30.jar) to the following location prior to running a VSAM project: \edesigner\
Summary of the content on the page No. 15
Chapter 2 Section 2.2 Installing the VSAM eWay ICAN 5.0 Project Migration Procedures Steps to extract the Sample Projects include: 1 Click the Documentation tab of the Sun Java Composite Application Platform Suite Installer, then click the Add-ons tab. 2 Click the VSAM eWay Adapter link. Documentation for the VSAM eWay appears in the right pane. 3 Click the icon next to Sample Projects and extract the ZIP file. Note that the VSAM_eWay_Sample.zip file contains two additional ZIP files for each
Summary of the content on the page No. 16
Chapter 2 Section 2.3 Installing the VSAM eWay Installing Enterprise Manager eWay Plug-Ins 2 Browse to and select your exported Project file. 3 Click Import. A warning message, “Missing APIs from Target Repository,” may appear at this time. This occurs because various product APIs were installed on the ICAN 5.0 Repository when the Project was created, that are not installed on the Java CAPS 5.1.3 Repository. These APIs may or may not apply to your Projects. You can ignore this message if yo
Summary of the content on the page No. 17
Chapter 2 Section 2.3 Installing the VSAM eWay Installing Enterprise Manager eWay Plug-Ins Enterprise Manager requires an eWay specific “plug-in” for each eWay you install. These plug-ins enable the Enterprise Manager to target specific alert codes for each eWay type, as well as start and stop the inbound eWays. The Sun Java Composite Application Platform Suite Installation Guide describes how to install Enterprise Manager. The Sun SeeBeyond eGate Integrator System Administration Guide descr
Summary of the content on the page No. 18
Chapter 2 Section 2.3 Installing the VSAM eWay Installing Enterprise Manager eWay Plug-Ins A From the Install New Alert Codes section, browse to and select the eWay alert properties file for the application plug-in that you added. The alert properties files are located in the alertcodes folder of your Sun Java Composite Application Platform Suite installation directory. B Click Deploy. The available alert codes for your application are displayed under Results. A listing of the eWay’s availab
Summary of the content on the page No. 19
Chapter 2 Section 2.3 Installing the VSAM eWay Installing Enterprise Manager eWay Plug-Ins Alert Code\Description Description Details User Actions DBCOMMON-XAEND- Error occurred during Look for the detailed error FAILED000001=XAEnd failed. commit on XA mentioned in the alert for the Reason: [{0}] connection. appropriate action. DBCOMMON-CANNOT-GET- Could not read Transaction isolation is one of the ISOLATION-LEVEL=Unable to transaction isolation following constants: get isolationLevel for t
Summary of the content on the page No. 20
Chapter 3 Setting Properties of the VSAM eWay This chapter explains how to set the properties of the VSAM eWay. What’s in This Chapter Creating and Configuring a VSAM eWay on page 20 Configuring the eWay Connectivity Map Properties on page 20 Configuring the eWay Environment Properties on page 23 eWay Connectivity Map Properties on page 24 eWay Environment Properties on page 26 3.1 Creating and Configuring a VSAM eWay All eWays contain a unique set of default configuration parameters. After
