IBM WAVV 2004 manual Ffstores.Demo.Cluster, Finished

Page 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=REDIRECTOR,

X

IP='<ip-addr>',

X

HANDLER='com.ibm.vse.db2handler.DB2Handler',

X

OPTIONS='dburl=jdbc:db2:<db>;dbuser=<userid>;

X

maptable=FFSTORES_MAP;map=FFSTORES;

X

dbpassword=<password>;dbtable=FFSTORES'

 

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

Image 20
Contents VSE Connectors Workshop VSE Connectors Workshop VSE/ESA 2.6/2.7 Vsam Redirector Redirect Vsam requests to a Html On Windows Overview TCP/IPSteps for installation of Vsam Redirector server on Windows Navigate to VSE Redirector Server homeInstall JDK if not on the system Steps for installation on a WorkstationVerification if Java environment installed Download VSE Redirector server Code Download latest Code via HtmlInstall VSE Redirector Server Java installVerify installation Vsam Redirector Server Verify Redirector server DocumentationStart VSE Redirector server For Windows Start Programs Vsam Redirector Online HelpRedirect a Vsam requests to a Html Redirector Server HandlerVSE Settings to redirect a Vsam cluster Configuration for Redirector Client on VSE\ESAAccess the Vsam file with Ditto Redirect a Vsam file To Html Change Handler to read Vsam record as stringSummary Redirect Vsam requests To a DB2 database on Windows GoalRedirect a Vsam file to DB2 Field name Type Offset LengthCLASSPATH% Ksds FFSTORES.REPRO.CLUSTER FFSTORES.REPRO.CLUSTERFFSTORES.DEMO.CLUSTER FinishedAdditional Information