Краткое содержание страницы № 1 
                    
                        IBM IT Education Services
VSE Connectors
Workshop
Setup of VSAM Redirector
WAVV 2004
© 2004 IBM 
Corporation                                                                                                                                                                                                                                                                                                                                                                                                        
                    
                    Краткое содержание страницы № 2 
                    
                        VSE Connectors Workshop Setup of VSAM Redirector  WAVV 2004            Connectors Wilhelm Mild, Ingo Franzki VSEESA@de.ibm.com © Copyright IBM Corporation 2004                                                                                                                                                                                                                                                                                                                                                     
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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 
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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
                    
                    Краткое содержание страницы № 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