DB2 Delete Utility

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

Hi,

Is there any DB2 utility available to delete the records from the DB2 table , based on the keys from the input file?

Thanks,
Nagendran.R

Richa Jain · New User Joined: 18 Mar 2008 Posts: 35 Location: Gurgaon

IKJEFT01 utility can be used

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

Hi,

If we use IKJEFT01 we need to create an applicaion program, but without program is it possible to do.

thanks,
Nagu

dick scherrer · Posted: Tue Aug 05, 2008 7:46 pm

Hello,

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

Hello,

Thanks for ur response.

If we use SPUFI, we need to hardcode query for each records that needs to be deleted.

But i dont like to do it so, i am having millions of record needs to be deleted.

My requirement is, input file is having arounfd 10 million records,
I want to delete all the records that present in the input file. I just want to know whether it is possible by using utility?

Thanks,
Nagu

Craq Giegerich · Posted: Tue Aug 05, 2008 8:08 pm

It would probably be better to unload the database, delete the records from the unload, then reload the database.

dbzTHEdinosauer · Posted: Tue Aug 05, 2008 8:26 pm

Pandora-Box · Posted: Wed Aug 06, 2008 12:10 pm

Nagendran,

Try to do a LOAD REPLACE with a dummy file.

Regds,
Prem

vini_srcna · Posted: Thu Aug 07, 2008 12:55 am

Dont do Load replace with Dummy SYSREC unless you have to delete all the records in the table.!!!

Do you have any idea how the keys came into file.? was it a unload.???

Deleting 10 million records thru DELETE sql is not preferable. If the file contains unload data, then UNLOAD the data apart from the data in the delete file. Now you can do a LOAD REPLACE with the later data so that the data in delete file is no more in table. This is how it is done in most of the shops.

There is an another option of doing REORG with DISCARD option also.