I am extracting the records (about 18 million records) from a VSAM
file and loading it into a DB2 table.
On the very next day some of the records (say 1 million records) in
the VSAM file are getting changed/updated. Now, I want to load only
these changed records from VSAM file to the same DB2 table and not all
the 18 million records. So what kind of DB2 utility I need to use for
that...please throw ur suggestions
Joined: 01 Mar 2006 Posts: 287 Location: Basel, Switzerland
first of all, you should consider a clever way, how to find out
the changed/updated vsam records only. maybe you should
do this with an update-timestamp.
for loading the changed/updated vsam records to db2,
you can do this with APPEND...