I just moved to a new work team and received a business request to clean up a large business table. The table, currently has 600 million rows and upwards. If i were to cleanup this table, would it be effective using a COBOL-DB2 program where i make use of the YEAR and QUARTER functions of DB2 ? Basically i am looking at efficient ways of cleaning up a large DB2 table using COBOL. This table was used for archiving transactions done by business. Any pointers on the same would be helpful, thanks.
IF It is a conditional clean up then
take a back up and then delete by DB2 utility-additionally if you have any
partions on date then and need to delete any specific range data then
use a partion number while you do a delete
Also look for TRUNCATE.
It is not efficient to do one by one in COBOL-DB@ program (if thats what you were asking)