Configuring DFWorks for 60 day Mailpiece.zip file retention

Product Feature: General

Operating System: Windows 8 64bit

Database: Oracle 11G

Configuration: Any

To change the number of days to retain mailpiece zip files to 60 days (instead of 90)

Go into SQL Developer.

run the following SQL
UPDATE CLEANUPFILES SET DELETE_ZIP_DAYS_OLD=60 WHERE NAME='costmanager';

To check and make sure the setting took.

Look again the next day (or 12+ hours later). About 1/3 of the zipped files (the oldest ones) should now be deleted if it's changed from 90 days to 60

Question

Subject: Cannot configure DFWorks to less than 90 days Mailpiece Zip retention

Initial Details: Wells has custom config. where mailpiece.zip files usually stored on DC server are stored on WebApp. Jim A stated he deleted the files (based on 60 day retention) and recovered 80 Gig of data. He is requesting change to system so it can be configured to save only 60 day of zip files.

UPDATED: April 04, 2017