Hi all,

We are attempting to delete 5.7 million rows from an 8.1 million row table that only contains a primary key index using the following delete statement:

delete from tablename where nonindexed_field in (1, 2, 3) and nonindexed_field > 8

This command has now been running for more than 26 hours. All foreign keys that accessed the table were dropped previously. We were able to select the data before the delete started using the following statement:

select * from tablename where nonindexed_field in (1, 2, 3) and nonindexed_field > 8

This query took less than 3 minutes to return the full data set.

Can anyone give me any tips on how to troubleshoot this issue? What could be slowing down this delete?

Thanks In Advance,
D

DB2 & UDB email list listserv db2-l LazyDBA home page