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 .

Page 20
Image 20
IBM WAVV 2004 manual Ffstores.Demo.Cluster, Finished