Joined: 20 Oct 2006 Posts: 6968 Location: porcelain throne
I have always been a believer in cursors.
especially when so many updates (a delete is an update) are involved.
Until a commit is performed (either explicitly or the rookie method of program end),
all those deleted rows are maintained by DB2 in the event of rollback.
that is quite a systems resource hog.
and why are you doing mass deletes during online processing??????