Archiving data on very large tables

Sachindra Kumar Meshram v · *nix forums Guru Wannabe Joined: 12 May 2005 Posts: 227

Just deleting rows periodically is probably not the biggest problem.
Open a cursor on the table and do positioned deletes on that cursor and
issue a commit every xxxx deletes.

The main problem will be to keep the table and indexes organized to free up
unused space.

--
Message posted via http://www.dbmonster.com

Cedric · *nix forums beginner Joined: 21 Feb 2005 Posts: 1

We have a table in db2 that has about 40 million rows added to it daily and
want to keep a rolling period of 180 days worth of data on the table. We
want to remove either one day or a few days worth of data in batch, but it
must not cause significant locking on the table.
Would using a MDC on the date field in the table help significantly in
speeding up the deletes or is the only real way to remove the old data to
partition the table into weekly partitions and unload the data from each
partition.

Google