Data migration uses a combination of
CICS®
VT and
DB2®
utilities. It is a 3-step process as
follows:
- Unload the VSAM file to a sequential data set by using the
CICS
VT VIDUNLOD program.
- Convert the sequential data set into a
DB2
LOAD format data set using the
CICS VT
VIDLOAD
program.
CICS
VT
services are invoked at this stage to handle any field re-engineering,
according
to how the data set is mapped.
- Use the
DB2 LOAD
utility to load the output data set from step 2 into the
DB2 table.
You should use the automated data migration facility to generate the
CICS
VT
batch job utility and control cards.
The data migration process can involve some degree of data
cleansing, particularly
where you are mapping fields to DECIMAL, INTEGER, SMALLINT, or DATE column
types.