IBM WAVV 2004 manual Redirect Vsam requests To a DB2 database on Windows, Goal

Page 15

Chapter4: Redirect VSAM requests

to a DB2 database on Windows

Apache

TCP/IP

 

HTML

Program

DB2 UDB

 

 

page

 

 

 

 

CICS

batch

 

 

Transaction

 

Handler

Handler

VSAM Request

 

 

 

 

Redirector server

Redirector client

 

 

 

 

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 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"

Right click on the map, choose "Change map definition":

Image 15
Contents VSE Connectors Workshop VSE Connectors Workshop VSE/ESA 2.6/2.7 Vsam Redirector TCP/IP Redirect Vsam requests to a Html On Windows OverviewNavigate to VSE Redirector Server home Steps for installation of Vsam Redirector server on WindowsSteps for installation on a Workstation Verification if Java environment installedInstall JDK if not on the system Download latest Code via Html Download VSE Redirector server CodeJava install Install VSE Redirector ServerFor Windows Start Programs Vsam Redirector Online Help Verify installation Vsam Redirector ServerVerify Redirector server Documentation Start VSE Redirector serverRedirector Server Handler Redirect a Vsam requests to a HtmlConfiguration for Redirector Client on VSE\ESA VSE Settings to redirect a Vsam clusterAccess the Vsam file with Ditto Change Handler to read Vsam record as string Redirect a Vsam file To HtmlSummary Goal Redirect Vsam requests To a DB2 database on WindowsField name Type Offset Length Redirect a Vsam file to DB2CLASSPATH% Ksds FFSTORES.REPRO.CLUSTER FFSTORES.REPRO.CLUSTERFinished FFSTORES.DEMO.CLUSTERAdditional Information