Inhaltszusammenfassung zur Seite Nr. 1
IBM IT Education Services
VSE Connectors
Workshop
Setup of VSAM Redirector
WAVV 2004
© 2004 IBM
Corporation
Inhaltszusammenfassung zur Seite Nr. 2
VSE Connectors Workshop Setup of VSAM Redirector WAVV 2004 Connectors Wilhelm Mild, Ingo Franzki VSEESA@de.ibm.com © Copyright IBM Corporation 2004
Inhaltszusammenfassung zur Seite Nr. 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
Inhaltszusammenfassung zur Seite Nr. 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
Inhaltszusammenfassung zur Seite Nr. 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
Inhaltszusammenfassung zur Seite Nr. 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
Inhaltszusammenfassung zur Seite Nr. 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
Inhaltszusammenfassung zur Seite Nr. 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
Inhaltszusammenfassung zur Seite Nr. 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
Inhaltszusammenfassung zur Seite Nr. 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
Inhaltszusammenfassung zur Seite Nr. 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
Inhaltszusammenfassung zur Seite Nr. 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
Inhaltszusammenfassung zur Seite Nr. 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. VSE/ESA Redir
Inhaltszusammenfassung zur Seite Nr. 14
Summary Major Steps to install VSAM Redirector Server on a Java Platform install Java Runtime Environment (JRE) or Java Developer Kit (JDK) free download from SUN or IBM version 1.3.x or later http://www.ibm.com/developerworks/java/ download VSAM Redirector Server http://www-1.ibm.com/servers/eserver/zseries/os/vse/support/vseconn/redir.html install VSAM Redirector Server at a Windows command enter: java install Configure the VSAM clusters to be redirected on the VSE side using sk
Inhaltszusammenfassung zur Seite Nr. 15
Chapter4: Redirect VSAM requests to a DB2 database on Windows TCP/IP Apache Program HTML DB2 UDB page CICS batch Transaction Handler Handler VSAM Request Redirector client Redirector server VSAM Initial state: VSE/ESA 2.6 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 th
Inhaltszusammenfassung zur Seite Nr. 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 20 WEBPIC2 STRING 174 20 ACODE STRING 194 10 To verify the mapping, use the VSE Navigator to display the VSAM data. Right click on the map, choose "Display V
Inhaltszusammenfassung zur Seite Nr. 17
Redirect a VSAM file to DB2 STEP4.3: Create the tables in the database To continue with the next steps –you must have installed a database management system (i.e. DB2). –you must have a JDBC Driver for it (i.e. db2java.zip in \java\). –you must be able to connect to the database (userid/password) Make sure the JDBC driver is in the CLASSPATH. You may have to edit the create.bat/create.cmd/create.sh batch files as well as the run.bat/run.cmd/run.sh batch files and add the JDBC Driver Ar
Inhaltszusammenfassung zur Seite Nr. 18
Redirect a VSAM file to DB2 Before we can work with the data in the database, we have to load the data from VSAM into the database. To do this we define a second cluster, redirect this cluster and copy (repro) the original cluster into the redirected one. STEP4.4: Define cluster FFSTORES.REPRO.CLUSTER with the same attributes as FFSTORES.DEMO.CLUSTER: –KSDS –Max/Avg. record length: 210 –Key Position: 0, Keylength: 6 STEP4.5: Configure the Redirector for FFSTORES.REPRO.CLUSTER: Copy skeleton
Inhaltszusammenfassung zur Seite Nr. 19
Redirect a VSAM file to DB2 STEP4.6: Copy FFSTORES.DEMO.CLUSTER into FFSTORES.REPRO.CLUSTER: Use the IDCAMS REPRO function to copy the contents of FFSTORES.DEMO.CLUSTER into the redirected FFSTORES.REPRO.CLUSTER: * $$ JOB JNM=REPRO,CLASS=A,DISP=L // JOB REPRO COPY FILE // DLBL COPYIN,'FFSTORES.DEMO.CLUSTER',,VSAM,CAT=VSESPUC // DLBL COPYOUT,'FFSTORES.REPRO.CLUSTER',,VSAM,CAT=VSESPUC // EXEC IDCAMS,SIZE=AUTO REPRO INFI
Inhaltszusammenfassung zur Seite Nr. 20
Redirect a VSAM file to DB2 STEP4.7: Configure the Redirector for FFSTORES.DEMO.CLUSTER: Edit skeleton SKRDCFG: Change the previously created entry in the configuration table. Enter case m in the command line to switch to mixed case mode before editing. Change FFSTORES.REPRO.CLUSTER to FFSTORES.DEMO.CLUSTER IESRDENT CATALOG='VSESP.USER.CATALOG', X CLUSTER='FFSTORES.DEMO.CLUSTER', X EXIT='IESREDIR', X OWNER=RE