Redirect a vsam file to db2 – IBM WAVV 2004 User Manual
Page 20
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 .
Redirect a VSAM file to DB2