IBM WAVV 2004 инструкция обслуживания

IBM IT Education Servi ces © 2004 IBM Corporation WAVV 2004 Setup of VSAM Redirector VSE Connectors Workshop[...]

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

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 y ou t o redirect all requ ests to a cert ain VSAM file into any other file system or dat abase on any other (Java- enabled) platform. VSE/ESA is the client, while the s erver part runs on any other J av a-enabled [...]

Initial state: Î You have a VSAM file that contains data ( FLIGHT.ORDERING.ORDERS ) Î You have applications that wo rk with that VSAM file (i.e. batch applications, CICS Ap plication, tools like Ditto ) Goal: Î Redirect all VSAM INSERT r equests to a HTML page on Windows Î This operation can be done with ex isting applications (without changing[...]

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 bro wser: http://www-1.ibm.com/server s/eserver/zseries/os/vse/ Click on "Service and Support" on the left side and then on "e-business connectors and utilities". The page yo[...]

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, t he JRE 1.3.x or later is needed (Java Runtime Environment), y to develop/compile Java programs, JDK 1.3.x or later is needed (Java Developer Ki[...]

Steps for installation on a workstation STEP1.4: Download VSE Redirector server Code With Java installed, navigate on VSAM Redirector S erver -> Details and Download to: Download latest Code via HTML and click on: redir270-pq 74694.zip (VSE 2.6 and 2.7). The file name may vary since it cont ains an APAR number. Please make sure you have applied [...]

Steps for installation on a workstation STEP1.5: Install VSE Redirector Server To install the VSAM Redirector se rver, 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 h t he installation pr oc ess of the VSAM Redire[...]

STEP1.6: Verify Redirector server Documentation To verify that the VSAM Redirector Server is installed properly, open the HTML Documentation (For Windows: START -> Programs -> V SAM Redirector -> Online Help The Help HTML page will be opened. STEP1.7: Start VSE Redirector server To start the VSAM Redir ec tor Server, e xecute: run.bat in t[...]

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 ma nipulation and conversion. Therefor e it must know the st ructure (map ping) of the VSAM record. The handler used in the workshop is the HtmlHandler.class stored[...]

STEP2.1: Configuration for Redirector Client on VSEESA To redirect requests for the: • VSAM cluste r: FL IGHT. ORDERING. ORDERS .TEAMxx • in VSAM catalog: VSESP.USER.CATALOG We have to setup the Configuration phase ( IES RDCFG. PHASE ). In this phase we have to def ine which VSAM cluster should be redirected to which remote location, and event[...]

In your skeleton SKRDCFG consider: – let the job load IESRDCFG int o t he SVA (Step 2) – let the job copy IESVEX 01 to IK QVEX01 in PRD2.C ONFIG (Step 3) – let the job load IK QVEX01 into the SVA (Step 4) – do NOT let the job load IESRDANC int o the SVA, because it has already be done (Step 5) – let the job execute IESRDL DA to register t[...]

STEP3.1: Change Handler to read VSAM record as string Exit Ditto on VSE and stop the Redirec tor server on Windows using command qui t. The handler on Windows should be changed to be able to use string fields only. The handler is stored in <redir>comibmvsehtm lhandler as HtmlHandler.java Edit the file and make following changes: 1. Change[...]

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/devel operworks/java/ 9 download VSAM Redirector Server http://www-1.ibm. com/serve rs/eserver/zseries/os/vse/ support/vseconn/ r[...]

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 app lications (without changing them) NOTE: The VSAM Redirector Server does NOT require [...]

Mapping of FFSTORES.DEMO.CLUSTER: Field name Type Offset Length STOREID STRING 0 6 STORENA ME STRING 6 25 LOCSTREET STRING 31 25 LOCCITY STRING 56 25 LOCZIP STRING 81 10 LOCCOUNTRY STRING 91 25 LOCREP STRING 116 20 STOREN1 UNSIGN ED 136 4 STOREN2 UNSIGN ED 140 4 LDATE STRING 144 10 WEBPIC1 STRING 154 20 WEBPIC2 STRING 174 20 ACODE STRING 194 10 To [...]

STEP4.3 : Create the tables in the database To continue with the next steps – you must have installed a databas e management system (i.e. DB2). – you must have a JDBC Driver for it (i.e. db2java.zip in <db2>java). – you must be able to connect to the database (userid/password) Make sure the JDBC driver is in the CLASSPATH. You may hav[...]

Before we can work with the data in the database, we have to load the data from VSAM into the databas e. To do t his we define a second clus ter, redirect this cluster and copy (repro) the original cluster into the redirected one. STEP4.4: Define clus ter F F STORES .REPRO.CLUS TER with the same attributes as FFSTORES.DE MO.CLUSTER: – KSDS – Ma[...]

STEP4.6: Copy FFSTORES.DEMO .CLUSTER into FFSTORES.REPRO.CLUSTER : Use the I DCA MS REPR O function to copy the contents of FFSTORES.DEMO.CLUSTER into the redirected FFSTORES.REPRO.CLUSTER: * $$ JOB JNM=R EPRO,CLASS =A,DISP=L // JOB REPRO C OPY FILE // DLBL COPYIN ,'FFSTORES .DEMO.CLUST ER' ,,VSAM,CAT =VSESPUC // DLBL COPYOU T,'FFSTO[...]

STEP4.7: Configure the Redirector for FFSTORES.DEMO.CLU STER: 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. DEM O .CLUSTER IESRDENT CATALOG='VSESP.USER. CATALOG', X CLUSTER=&ap[...]

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/home.html z e-business Connectivity for VSE/ES[...]