We have an old IBM DB2 5.2 database running on a server that is running out of space, a few weeks at best. All options have been explored and the best option for now, is to see if there is a utility, with DB2 or third party, that can combact the databae. A utility that will go through and delete the deleted records/ reclaim unused space, something along the lines of Compact and Repair in MS Access. I have compacted and repaired Access databased from 5 gig down to 700 meg.
Is there a similiar utility/command/tool for DB2 5.2?