Ibm it education services © 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 2004.
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...
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...
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...
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...
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 apa...
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...
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 red...
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 th...
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...
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...
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...
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...
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:...
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...
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 i...
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 ...
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 ...
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 catalo...
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...