Redirect a vsam file to db2 – IBM WAVV 2004 User Manual

Page 18

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='', X

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

OPTIONS='dburl=jdbc:db2:;dbuser= X

maptable=FFSTORES_MAP;map=FFSTORES; X

dbpassword=;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