Page 2 - Setup of; VSE Connectors
Wilhelm Mild, Ingo Franzki [email protected] WAVV 2004 Connectors Setup of VSAM Redirector VSE Connectors Workshop © Copyright IBM Corporation 2004
Page 3 - VSAM Redirector
VSE/ESA 2.6/2.7 VSAM Redirector The VSAM Redirector is a new VSE/ESA connector, introduced with VSE/ESA 2.6. The VSAM Redirector allows you to redirect all requests to a certain VSAM file into any other file system or database on any other (Java-enabled) platform. VSE/ESA is the client, while the se...
Page 4 - Redirect VSAM requests to a HTML; Apache
Initial state: Î You have a VSAM file that contains data ( FLIGHT.ORDERING.ORDERS ) Î You have applications that work with that VSAM file (i.e. batch applications, CICS Application, tools like Ditto ) Goal: Î Redirect all VSAM INSERT requests to a HTML page on Windows Î This operation can be done wi...
Page 5 - Navigate to VSE Redirector Server home page
Chapter1: Steps for installation of VSAM Redirector server on Windows STEP1.1: Navigate to VSE Redirector Server home page Open the VSE Homepage with a web browser: http://www-1.ibm.com/servers/eserver/zseries/os/vse/ Click on "Service and Support" on the left side and then on "e-busines...
Page 6 - Verification if Java environment installed
Steps for installation on a workstation STEP1.2: Verification if Java environment installed To install the VSAM Redirector a Java Virtual Machine must be installed on Windows. y To just run Java programs, the JRE 1.3.x or later is needed (Java Runtime Environment), y to develop/compile Java programs...
Page 7 - Download VSE Redirector server Code
Steps for installation on a workstation STEP1.4: Download VSE Redirector server Code With Java installed, navigate on VSAM Redirector Server -> Details and Download to: Download latest Code via HTML and click on: redir270-pq74694.zip (VSE 2.6 and 2.7). The file name may vary since it contains an ...
Page 8 - Install VSE Redirector Server
Steps for installation on a workstation STEP1.5: Install VSE Redirector Server To install the VSAM Redirector server, open a Windows command line and change current directory to the one where install.class resides. Type: java install or start the install program install.bat This will guide you troug...
Page 9 - status; - shows the status of the server; quit; - stop all clients and exit server; Verify installation of
STEP1.6: Verify Redirector server Documentation To verify that the VSAM Redirector Server is installed properly, open the HTML Documentation (For Windows: START -> Programs -> VSAM Redirector -> Online Help The Help HTML page will be opened. STEP1.7: Start VSE Redirector server To start the...
Page 10 - The Record Layout of the; ORDERS; Cluster is defined as follows:; Redirect a VSAM requests to a
STEP1.8: Redirector Server -> Handler To be able to work with VSAM data on another platform (ASCII), the mostimportant component is the Handler . The handler is responsible for data manipulation and conversion. Therefore it must know the structure (mapping) of the VSAM record.The handler used in ...
Page 11 - Configuration for Redirector Client on VSE\ESA; Chapter2: VSE Settings to
STEP2.1: Configuration for Redirector Client on VSE\ESA To redirect requests for the:• VSAM cluster: FLIGHT.ORDERING.ORDERS.TEAMxx • in VSAM catalog: VSESP.USER.CATALOG We have to setup the Configuration phase ( IESRDCFG.PHASE ). In this phase we have to define which VSAM cluster should be redirecte...
Page 12 - Access the VSAM file with Ditto; VSE Settings to redirect a VSAM
In your skeleton SKRDCFG consider: – let the job load IESRDCFG into the SVA (Step 2) – let the job copy IESVEX01 to IKQVEX01 in PRD2.CONFIG (Step 3) – let the job load IKQVEX01 into the SVA (Step 4) – do NOT let the job load IESRDANC into the SVA, because it has already be done (Step 5) – let the jo...
Page 13 - Change Handler to read VSAM record as string; lastname; Chapter3: Redirect a VSAM file
STEP3.1: Change Handler to read VSAM record as string Exit Ditto on VSE and stop the Redirector server on Windows using command quit. The handler on Windows should be changed to be able to use string fields only. The handler is stored in <redir>\com\ibm\vse\htmlhandler as HtmlHandler.java Edit...
Page 14 - Summary; Major Steps to install VSAM Redirector Server on a; install Java Runtime Environment (JRE) or; free download from SUN or IBM; download VSAM Redirector Server; at a Windows command enter:; Configure the VSAM clusters to be redirected on the VSE side
Summary Major Steps to install VSAM Redirector Server on a Java Platform 9 install Java Runtime Environment (JRE) or 9 Java Developer Kit (JDK) 9 free download from SUN or IBM 9 version 1.3.x or later http://www.ibm.com/developerworks/java/ 9 download VSAM Redirector Server http://www-1.ibm.com/serv...
Page 15 - NOTE: The VSAM Redirector Server does NOT require the; Define a map; Chapter4: Redirect VSAM requests; Program
Initial state: Î You have a VSAM file that contains data (i.e. FFSTORES.DEMO.CLUSTER) Î You have applications that work with that VSAM file (i.e. FFST CICS Application) Goal: Î Redirect all VSAM requests to DB2 UDB on Windows Î Access the data with existing applications (without changing them) NOTE:...
Page 16 - Redirect a VSAM file to DB2
Mapping of FFSTORES.DEMO.CLUSTER: Field name Type Offset Length STOREID STRING 0 6 STORENAME STRING 6 25 LOCSTREET STRING 31 25 LOCCITY STRING 56 25 LOCZIP STRING 81 10 LOCCOUNTRY STRING 91 25 LOCREP STRING 116 20 STOREN1 UNSIGNED 136 4 STOREN2 UNSIGNED 140 4 LDATE STRING 144 10 WEBPIC1 STRING 154 2...
Page 21 - Additional Information
Additional Information z VSE/ESA Home Page http://www.ibm.com/servers/eserver/zseries/os/vse/ z e-business Connectors User's Guide SC33-6719 http://www-1.ibm.com/servers/eserver/zseries/os/vse/pdf/ieswue21.pdf z e-business connectors tools z http://www.ibm.com/servers/eserver/zseries/os/vse/ebus/hom...