We have not deleted any our inbox documents in over one year. We want to purge anything older than 40 days. We have about 6,000 reports for over 100 users to purge. I have read on a BOB user group that is will take a long time. We want to run it at night but kill it if it is still running in the morning. Does it do incremental commits?
Not exactly sure how it works. Keep in mind that it only purges UNREAD inbox documents. Once read, the documents are removed from the repository. I hadnât heard that this takes a long time. Itâs just deleting records.
First Delete Documents older than 70 days then 60 days and then 50 Days and 40 Days. So with each deletion some documents will get removed. You can do all of them in a single night or evening.
If posiible try to a scan and repair after each delete or perform it after all stages are complete.
For that many documents, it will take a long time to delete them thru Supervisor. You might also run into the possibility of getting locked up.
You can delete them directly from the repository. But of course, a word of caution is that you MUST know what you are doing.
The following is the SQL script for Oracle:
delete from OBJ_M_ACTORDOC
where M_ACTDC_N_ACTORID = â123â
(If you are using different database, you have to find out the field and table first)
You can query the database to get a list of the users and their âactoridâ. Then you can write a small script to loop thru the list to execute the SQL script, with the âactoridâ as input parameter. I suggest you to do that in batches.
Although substring is exactly correct, this is very dangerous. Youâd be manipulating the repository directly.
I like the other method: Do it in stages. In V6, it shows you what youâd be deleting ahead of time. So you can see what youâd be doing to your database.