IBM WAVV 2004 user manual

Summary of the content on the page No. 1

IBM IT Education Services
VSE Connectors
Workshop
Setup of VSAM Redirector
WAVV 2004
© 2004 IBM
Corporation

Summary of the content on the page No. 2

VSE Connectors Workshop Setup of VSAM Redirector WAVV 2004 Connectors Wilhelm Mild, Ingo Franzki VSEESA@de.ibm.com © Copyright IBM Corporation 2004

Summary of the content on the page No. 3

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 server part runs on any other Java-enabled platform like Windows. For example you could use the VSAM Redirector to synchronize a VSAM file with a DB2 database running on a Windows. By using the VSA

Summary of the content on the page No. 4

Redirect VSAM requests to a HTML page on Windows - Overview 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 with existing applications (without changing/touching them) NOTE: The VSAM Redirector Server does NOT require the VSE Connector Client on Wi

Summary of the content on the page No. 5

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-business connectors and utilities". The page you see contains the VSAM Redirector Server and some tools that can be downloaded for free. Navigate to the VSAM Redirector Server which represents the remote componen

Summary of the content on the page No. 6

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. To just run Java programs, the JRE 1.3.x or later is needed (Java Runtime Environment), to develop/compile Java programs, JDK 1.3.x or later is needed (Java Developer Kit, which includes the JRE). To verify if a Java Virtual Machine is installed, open a command prompt and hit command: java -version You should see som

Summary of the content on the page No. 7

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 APAR number. Please make sure you have applied the corresponding APAR on your VSE system. The download process will be started. You will be prompted to specify where to save the code. Save it in a

Summary of the content on the page No. 8

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 trough the installation process of the VSAM Redirector Server. The VSAM Redirector Server consists of: the VSAM Redirector Server code a detailed HTML documentation about the functions and possibi

Summary of the content on the page No. 9

Verify installation of VSAM Redirector Server 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 VSAM Redirector Server, execute: run.bat in the directory or use START -> Programs -> VSAM Redirector -> Start Server) • Commands for Redirecto

Summary of the content on the page No. 10

Redirect a VSAM requests to a HTML page STEP1.8: Redirector Server -> Handler To be able to work with VSAM data on another platform (ASCII), the most important 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 the workshop is the HtmlHandler.class stored in directory: \com\ibm\vse\htmlhandler The handler needs a map to split the record into fields. This map d

Summary of the content on the page No. 11

Chapter2: VSE Settings to redirect a VSAM cluster 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 redirected to which remote location, and eventually filter which requests. For that a skeleton in ICCF Library 59 is shipped, called SKRDCFG It was copied t

Summary of the content on the page No. 12

VSE Settings to redirect a VSAM cluster 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 job execute IESRDLDA to register the new configuration (Step 6) – submit SKRDCFG and check for RC=0000 (this is only to test for errors) If the RC=0 tell the

Summary of the content on the page No. 13

Chapter3: Redirect a VSAM file to HTML 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 \com\ibm\vse\htmlhandler as HtmlHandler.java Edit the file and make following changes: 1. Change the HTML header tag to create an HTML page that will refresh itself all 5 seconds.