View previous topic :: View next topic
|
Author |
Message |
nitinkhobragade1
New User
Joined: 07 Mar 2006 Posts: 16
|
|
|
|
Hi folks,
I have a technical issue over here with me.
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 |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
I think you can use the LOAD utility without the REPLACE keyword. The LOAD utility is documented in the fine manual.
O. |
|
Back to top |
|
|
martin9
Active User
Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
|
|
|
|
hy nitinkhobragade1,
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...
martin9 |
|
Back to top |
|
|
|