IBM 2004 User Manual - Redirect A Vsam File to Db2
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='
HANDLER='com.ibm.vse.db2handler.DB2Handler', X
OPTIONS='dburl=jdbc:db2:
maptable=FFSTORES_MAP;map=FFSTORES; X
dbpassword=
–
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