I run a sql statement like the following. At times there are thousands of records selected for deletion. I have a db/2 server with 8 gig of RAM. The deletion takes several minutes and sometimes times out and hangs.
delete from db2inst1.results where updated <= (current_timestamp - 30 day )
What parameters can I tune to make this happen quickly?
thanks