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', X
CLUSTER='FFSTORES.REPRO.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)
–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
Redirect a VSAM file to DB2