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.result s where updated <= (current_timest amp - 30 day )
What parameters can I tune to make this happen quickly?
thanks
jaclyn
Last Activity: Oct 15 '07, 05:22 PM
Joined: Oct 15 '07
Location:
-
deleting large amounts of records
-
Slow, hanging when deleting large number of records.
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.result s where updated <= (current_timest amp - 30 day )
What parameters can I tune to make this happen quickly?
thanks
No activity results to display