logaas
New User
Joined: 19 Feb 2005 Posts: 25 Location: chennai
|
|
|
|
HI.
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
thanks, |
|
martin9
Active User
Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
|
|
|
|
hy logaas,
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...
martin9 |
|