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: 288 Location: Basel, Switzerland
at the end you want only the changed records,
or those from the day before and the changed records.
if you want only the changed records, then do it the
same way as for the 18million records the day before.
with the LOAD utility this is the fastest way to insert records...