IBM WAVV 2004 User's Manual
Contents
1. dbtable FFSTORES x MMM KRM KM KM 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 let the job load IESRDANC into the SVA if not already done Step 5 let the job execute IESRDLDA to register the new configuration Step 6 submit and check for RC 0000 IBM server For the next generation of e business 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 x 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 INFILE COPYIN OUTFILE COPYOUT NOREUSE amp E io HOD During the copy process the VSAM Redirector Client will get control at open time of FFSTORES REPRO CLUSTER and will connect to the VSAM Redirector Server In case this fails a VSAM open error message will be displayed To verify the data in the DB 2 table issue the following SQL statement or use the DB 2 Control Center SELECT FROM FFSTORES UNIGREAC STOREIL STORENA LOCSTREE LOCccITY LOCZIP LOCCOUN LOCREP STORET ood Frechdax Elbeplatz 2 Boeblinge 12. 1 for DB 2 2 for Oracle The tool now imports the XML file and tries to connect to the database Next the map info table is created FFSTORES_ MAP Enter Yes to continue Then the data table is created FFSTORES Enter Yes to continue Cluster Type Enter 1 KSDS without AIX Primary key field Enter the name of the key field STOREID Press enter to create the table and indexes IBM server For the next generation of e business 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 SKRDCFG from ICCF Library 59 to your primary library Edit add a entry to the configuration table Enter CASE M in the command line to switch to mixed case mode before editing IESRDENT CATALOG VSESP USER CATALOG ChUSITER FISTORES REPRO CLUSIER EXIT IESREDIR OWNER REDIRECTOR IP lt ip addr gt HANDLER com ibm vse db2handler DB2Handler OPTIONS dburl jdbc db2 lt db gt dbuser lt userid gt maptable FFSTORES_MAP map FFSTORES dbopassword lt password gt
3. First Name ZO 20 STRING no LAST NAME Last Name 40 4 UNSIGNED no FLIGHT NUMBER Flight Number 44 4 UNSIGNED no SEATS seats 48 1 BINARY no NON_SMOKE Smoker O no The Record length is 49 Bytes The Record Layout is reflected in the Map ORDERS_MAP IBM server For the next generation of e business Chapter2 VSE Settings to redirect a VSAM cluster STEP2 1 Configuration for Redirector Client on VSE ESA To redirect requests for the e VSAM cluster FLIGHT ORDERING ORDERS TEAMxx ein 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 lt was copied to your primary library The definitions for the redirected file were extracted into member RDCFGxx were xx is your team ID This was done to be able to build at the end one phase with the settings from all attendees Edit skeleton RDCFGxx Change the sample entry in the configuration as shown below Enter CASE M in the command line to switch to mixed case mode before editing IESRDENT CATALOG VSESP USER CATALOG CLUSTER FLIGHT ORDERING ORDERS TEHAMxx BALT TESREDIR OWNER VSAM LP Oecd y HANDLER com ibm vse htmlhandler HtmlHandler OPTIONS W x XK KM MM XM The most important parameter is OWNER OWNER VSAM means the READ req
4. Redirector server To start the VSAM Redirector Server execute run bat in the lt redirector gt directory or use START gt Programs gt VSAM Redirector gt Start Server e Commands for Redirector server status shows the status of the server stop x all stop client with number x show in status or stop all clients quit stop all clients and exit server IBM server For the next generation of e business Redirect a VSAM requests to a HTML page STEP1 8 Redirector Server gt 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 lt redir gt com ibm vse htmlhandler The handler needs a map to split the record into fields This map does not need to be defined on the VSE system but you can reuse a already defined map A map for a VSAM cluster can be defined with the Maptool VSE Navigator or IDCAMS RECMAP utility We work with the VSAM Cluster FLIGHT ORDERING ORDERS The ORDERS MAP is already defined In the used HTML handler lt redir gt com iom vse htmihandler HtmlHandler java the mapping is hard coded The Record Layout of the ORDERS Cluster is defined as follows Offset Length Type Key Field Name Description O 20 STRING no FIRST NAME
5. 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 do2java zip in lt db2 gt 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 Archive to the classpath set CLASSPATH xerces jar lt db2 gt java db2java zip SCLASSPATH Also the path must setup to contain the DB2 libraries Start the Create DB2 Tables utility create bat create sh or START Programs VSAM Redirector Create DB2 Tables The tool prompts you for the following XML Filename enter the name of the XML File you exported in the last step i e ffstores xml DB url enter a JDBC URL for your database i e jdbc do2 sample DB user enter a user id you use for accessing the database DB password enter the users password DB table name Enter the name of the data table i e FFSTORES This table will later contain the VSAM data Map table name Enter the name of the table that contains the mapping information i e FFSTORES MAP You can use the same map table for several clusters Map name Enter the name of the map i e FFSTORES This name is independent from the map defined with the VSE Navigator DB system Enter
6. must be installed on Windows eTo just run Java programs the JRE 1 3 x or later is needed Java Runtime Environment eto 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 something like Java version 1 3 1 Java TM 2 Runtime Environment Standard Edition lf the messages above are shown go to STEP1 4 STEP1 3 Install JDK if not on the system If following message is shown Java is not recognized as an internal or external command operable program or batch file gt your system has no Java virtual machine Runtime Environment installed To install a Java Virtual machine on the PC do On the same HTML page Service and Support gt VSE e business Connectors VSAM Redirector Server gt Details and Download in section Installation you will find a link were you can download the Java Developer Kit from IBM http www ibm com developerworks java or you can download a SUN Version from _http www sun com Install the downloaded JDK 1 3 x or later and reboot the workstation IBM server For the next generation of e business Steps for installation on a workstation STEP1 4 Download VSE Redirector server Code With Java installed navigate on VSAM Redirector Server gt Details and Download to Download latest Code via HTML a
7. 71032 Germany _ Hiller 31 fl Opppn072 Cate Kees Reeperbah TEUNA E SENTE a ej 3 a a Hille 3 EE E Frech 3 am nee GER n m ae d oo0007 Cafe Frech Blumenstr Boeblinge 71034 Germany ler 3 2 Sis EE el T 7 Cate Frech Rosenstra Boeblinge 71034 2 000010 Cafe Muell eege postings tat Germany Hiller gd 10000011 McDonalds Main Street Melbourne 20000 3 44 000012 Cafe Howa Harbor Re Sydney _ 10000 Australia Hille H 12 000013 woe 3 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 TESRDENT CATALOG VSESP USER CATALOG CLUSTER FFSTORES DEMO wCLUSTER EXIT IESREDIR OWNER REDIRECTOR I1P lt ip addr gt HANDLER com ibm vse db2handler DB2Handler OPTIONS dburl jdbc db2 lt db gt dbuser lt userid gt maptable FFSTORES_MAP map FFSTORES dbpassword lt password gt dbtable FFSTORES x MM MM KM Gi e 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 reg
8. VSE Connectors Workshop V I Bras a Eti hs D S bg M gel ta OT St EEE TEG EEEE fe beh md woterbebe Lie Seer rae 7 a D SBS LL BRES ERR eee ot essart Smee urea pons ages 8 F a d Sih E errero kum a pug i U TELC TIL i E REI O ch i di wg ae a ee tte CODE EEN zgsr rzcbr rdrseshs li te ERT ah ad EE ET ETH a be ee oho be Ree WR A ebe hed och beds dewbed ede ke BESEREER TE sr zbaieateg Hi ISE i RA A Dae A biss H H BEE TE G e el ee U EE T bk Sep Kasansrsasnree rage bh LE A4 aga SSSR ETS SSE EEE Se age of oa soe af LLE EEES E ss abada Ges i a DEE DA pan Peon eee ke al afshi e E tt ts a epee amp EX ad KA Sp vo bt a hig sd gps j CET Y BC Kei H li af a oe M i iiini Mi CR me wo laces cat Me See ee e E ee See SK Se rr r mmm eC j kri te wi ah aes 4 d I ka a e D WS bg SX bh d ZS vil a ip ey ed N e italy elt IEN ip ee je d Cas aa Ai e lt Setup of VSAM Redirector WAVV 2004 VSE Connectors Workshop setup of VSAM Redirector WAVV 2004 e business Wilhelm Mild Ingo Franzki VSEESA de ibm com Copyright IBM Corporation 2004 IBM server For the next generation of e business 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
9. ing applications without changing touching them NOTE The VSAM Redirector Server does NOT require the VSE Connector Client on Windows TCP IP IBM server For the next generation of e business 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 component of the VSAM Redirector VSAM Redirector Server Updated 062003 Use your existing applications e g COBOL programs without any changes to work with E data on any Java enabled platform Provides a Java based server which communicates with the YAM Redirector Client on WSE WW book IESVSMRD AY in PRO1 BASE Platform VSE ESSA 2 6 or later A Details and Download Click on Details and Download The page explains the most important functions of the VSAM Redirector Server which is the Java part of the VSAM Redirector function IBM server For the next generation of e business Steps for installation on a workstation STEP1 2 Verification if Java environment installed To install the VSAM Redirector a Java Virtual Machine
10. ister the new configuration Step 6 submit and check for RC 0000 STEP4 8 Finished You may have to reopen the VSAM file in CICS since the VSAM Redirector configuration becomes active at open time You can now work with your VSAM applications which will fully transparently access DB2 data and think they are working with VSAM data IBM server For the next generation of e business Additional Information VSE ESA Home Page http www ibm com servers eserver zseries os vse e business Connectors User s Guide SC33 6719 http www 1 ibm com servers eserver zseries os vse pdf ieswue21 pdf e business connectors tools http www ibm com servers eserver zseries os vse ebus home html CH Redbooks e business Connectivity for VSE ESA SG24 5950 e business Solutions for VSE ESA SG24 5662 Serviet and JSP Programming SG24 5755 Linux Web Hosting with WebSphere SG24 6007 DB2 and Domino VSEESA de ibm com Are you ek m business IBM server For the next generation of e business
11. n about the functions and possibilities etwo sample handlers one for relational databases i e DB2 and one for HTML eThe HTML handler allows to collect data inserted into a VSAM cluster on a HTML page on Windows e The DB2 handler allows the synchronization of a VSAM cluster with a remote DB2 database edocumentation how to develop own handlers NOTE The VSE Redirector Server does NOT require the VSE Connector Client IBM server For the next generation of e business 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 gt Programs gt VSAM Redirector gt Online Help Tt A YSE ESA Redirector documentation Microsoft Internet Explorer Ele Edt View Favortes Tools Help Bei SECH Bar Address 3 FWSAMRedirectordochredir html e Links VSE ESA Redirector documentation VOHES A Redirector version 1 1 0 Please report all bugs suggestions and comments to wseesa ilde ibr com Redirector documents How the VSAM Redirector works Redirector overview Redirector server and handler s e VSAM intecration considerations Game AT Sale RIN SAN e belleg VSAM Redirector cienron VONESA Be Baler a Kearector handier ample handler s NEW How to install the DE 2Handler How the VSAM Redirector works The VSAM Redirector connector consists of STEP1 7 Start VSE
12. nd 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 place you remember later on Download via FTP An alternative to the HTML download can be an FTP download if the code is on a FIP server For that issue commands ftp lt ppp xxx yyy zZzz gt cd lt pub gt bin mget zip After the code is downloaded it must be unzipped The ZIP file contains the following files install class install bat install cmd install sh Note The VSAM Redirector server is also shipped and installed with the VSE base product in Library PRD1 BASE as member jesvsmrd w You can download it from there in binary format and rename it to redir27 zip But the newest level will always be on the Internet IBM server For the next generation of e business 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 ethe VSAM Redirector Server code ea detailed HTML documentatio
13. ode Ditto works in HEX upper right corner Now from position 39 you can key in the numeric fields two times 4 byte numbers and a binary field that can be 00 or 01 as the map describes them in STEP7 8 Add as much records as you want At the command line hit save or press PF3 8 The Redirector Console on Windows should show a message that the output html page was created 9 Open the HTML page in lt redir gt dierctory outout html a ee Le ND You should see your inserted records only Change the OWNER to REDIRECTOR and you ll see each time you open in Ditto the cluster its empty because it will nor read from VSAM anymore IBM server For the next generation of e business 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 lt redir gt com ibm vselhtmihandler 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 lt html gt lt head gt lt title gt VSE ESA Redirector sample lt title gt lt meta http equiv refresh content 5 gt lt head gt 2 Change the lines in the source as below to read a string of 49 char Define all fields as String String firstname lastname flightnumber seats sm
14. oker Make the changes below in the source code it s in the last 3 rd firstname requestInfo getSsString 0 20 lastname requestiInfo getString 20 20 flightnumber requestInfo getString 40 4 seats requestiInfo getString 44 4 smoker regeustInfo getString 48 1 smoktmp requestInfo getString 48 1 if smoktmp length gt 0 if smoktmp 0 smoker false else smoker true htmloutput newLine htmloutput flush Save the changed file To be able to compile it we have to update the CLASSPATH temporary set CLASSPATH VsamRedir jar sCLASSPATHS In lt redir gt type javac com ibm vse htmlhandler HtmlHandler java 3 Test the changed handler Restart the Redirector server on Windows In lt redir gt type run bat Use Ditto again in CHAR mode right upper corner add some records with 49 characters each Now the output html should refresh itself each 5 seconds and show the inserted records IBM server For the next generation of e business A Rediroctor sample Mictosoft Internet Explorar e Fle Edt View Favoites Tons Heb Output from redirected VSAM FLIGHT ORDERING ORDERS cluster Phebt Number First name Lastname Seats Smoker 2413 Alexander Sch ttle 1 false 1999 Ingo brangc 2 false Sei Faul Talacher 1 true SCH J rg vchmidbaser 1 falee FSI Earsten Lat d true D Summary Major Steps to install VSAM Redirect
15. or Server on a Java Platform v install Java Runtime Environment JRE or v Java Developer Kit JDK v free download from SUN or IBM v version 1 3 x or later http www ibm com developerworks Java v download VSAM Redirector Server http www ibm com servers eserver zseries os vse support vseconn redir html V install VSAM Redirector Server v at a Windows command enter java install v Configure the VSAM clusters to be redirected on the VSE side using skeleton SKRDCFG from ICCF lib 59 IBM server For the next generation of e business Chapter4 Redirect VSAM requests to a DB2 database on Windows TCP IP Initial state You have a VSAM file that contains data i e FFSTORES DEMO CLUSTER gt You have applications that work with that VSAM file i e FFST CICS Application Goal gt Redirect all VSAM requests to DB2 UDB on Windows gt Access the data with existing applications without changing them NOTE The VSAM Redirector Server does NOT require the VSE Connector Client on Windows STEP4 1 Define a map To move the data into a database you must know the format of the records Therefore you must do a mapping containing all fields including their offset in the record length and type Start the VSE Navigator connect to the VSAM host and navigate to the VSAM cluster FFSTORES DEMO CLUSTER Right click the Cluster choose Create map definition Enter a name for the map e g MAP Righ
16. 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 Jaya plattorm Vio AM application eo AM F edirector VC AM Server Red rector For example you could use the VSAM Redirector to synchronize a VSAM file with a DB2 database running on a Windows By using the VSAM Redirector your existing VSAM programs doesn t require any revisions The VSAM Redirector makes use of a so called VSAM Data Access Exit VDA This exit intercepts all VSAM requests The exit gets control at OPEN CLOSE and for all data requests GET PUT INSERT A configuration table is used to define which VSAM files are being redirected The VSAM Redirector Client on VSE forwards all requests against a redirected file to the VSAM Redirector Server which then handles the request The VSAM Redirector Server is a Java application It can run on any Java enabled platform IBM server For the next generation of e business Redirect VSAM requests to a HTML page on Windows Overview Initial state gt You have a VSAM file that contains data FLIGHT ORDERING ORDERS gt You have applications that work with that VSAM file i e batch applications CICS Application tools like Ditto Goal gt Redirect all VSAM INSERT requests to a HTML page on Windows gt This operation can be done with exist
17. t click on the map choose Change map definition IBM server For the next generation of e business 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 VSAM Data On the Display Filter dialog box press OK to display all records no filter all records no filter To STORENAME ospae O LOCSTREET T OOOO Frochd a Elbeplat Boeblingen a 00000 Cate Keese Reeperbahin 15 Hamburg 000003 Hotel Sacher Hauptstr 15 wien 000004 Cate Frech Posiplat 3 Hoeblingen 000005 Cate Frech Filiale 1 Seestasse 2 Hoeblingen QOUU06 Cate Frech Filiale 2 ochoenalcherstrasse Hoeblingen UUUUU Cate een oe Blumenstrasse Boeblingen mom NN d e d m Ur 1 m STEP4 2 Export the mapping to a XML File The VSAM Redirector Create DB2 Tables tool reads the mapping from a XML file Right click on the map and choose Export map to XML Enter a filename e g fistores xml You will need this file in the next step IBM server For the next generation of e business Redirect a VSAM file to DB2
18. uests will be done from the VSAM cluster and the INSERTS will be done to VSAM and to the remote site specified in IP That means a synchronization takes place OWNER REDIRECTOR means all requests are redirected to the remote site IBM server For the next generation of e business 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 lf the RC 0 tell the instructor and he ll activate your definitions STEP2 2 Access the VSAM file with Ditto Make sure the Redirector server is started on your Windows STEP1 7 Use Ditto 2 Edit or update data gt 1 Edit VSAM data Enter the VSAM cluster name FLIGHT ORDERING ORDERS TEAMxx Enter the catalog name VSESP USER CATALOG Monitor the Redirector server console on Windows and press lt ENTER gt You must see the connection messages On VSE You should see the preloaded records from VSAM file if OWNER VSAM Make sure Ditto works in CHAR mode upper right corner Insert in the first 40 0 39 characters of the record first name last name Change the m
Download Pdf Manuals
Related Search