MVSFORUMS.com

[nitink.c]

Hello,
Greetings to everyone!

I have a requirement where I need to load the data from flat file to DB2. I know I can use the DB2 utility DSNUTILB to do that. This utility give us three options to load data in DB2 table:
Option 1
LOAD REPLACE: This options deletes all the records from tablespace before performing bulk load on the target DB2 table.

Option 2
RESUME YES: This option expects the target table to be empty to perform the bulk load

Option 3:
RESUME NO: This is like appending data to target table. But this option will reject any records with duplicate keys.

My requirement is that I want to replace the record having duplicate keys. In case of duplicate keys, the file record should overwrite the record in target table.

Does anyone have any idea how to achieve this using DSNUTILB.

Thanks!

[papadi]

Unload the table, match the unloaded data with the new data discarding duplicates, and then load the combined old/new data that has no duplicates.
_________________
All the best,

di

[kolusu]

nitink.c,

It depends on the volume of the records to be updated/replaced. If you have at least 50% updated records then you might want to consider LOAD REPLACE.

If you have only few hundreds of records to be updated, Use a program to Update the rows.

Kolusu

[nitink.c]

Kolusu/Papadi, Thanks for the reply!

I have thought of both the options and the reason I am looking for Bulk load solution rather than program or 'unload-merge-load' is:
1. I have tables that contain tens of millions of rows
2. The number of records coming in flat file will be in thousands
3. I want to perfom the load on 40 tables

So, if I should write a program, there will be 40 programs required (or less depending on design but not less than 15).
Using unload-merge-load mechanism will be too costly on tables having rows > 20 millions.

If these is no bulk load solution at all, I know I will have to use one of the option that you have mentioned.

Has anyone here used DB2 Import utility on Z/OS installation? How it works?

[kolusu]

nitink.c,

If you have only few thousands of records to be updated you probably can generate UPDATE statements and run them via DSNUTILB

Kolusu