Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Deleting large number of records in DB2
Greg, Based on what I've read and been told to date, doing a commit should clear the log files. So, I'm trying to do a limited number of deletes between commit statements. After increasing my number of primary log files to 50 x 50000, my latest delete script has been running for over 5hrs and... -
Deleting large number of records in DB2
My simplistic script does a commit after deleting each days worth of records... as stated in my post. The script consists of 31 deletes and 31 commits... Delete from mytable where month=<targetMonth> and day=1; commit; Delete from mytable where month=<targetMonth> and day=2; commit; .... etc... -
Deleting large number of records in DB2
Hi all, I have "some" OJT in DB2 v7.2 and have to support a db that collects about 100 million records a month. We don't have the disk space to keep all of this data so I have to delete records where Month(datefield) = Month(Current Date) - 2. I created a very simplistic script that deletes...
