How to purge objects in project areas, except the ones in current and previous year?
![](http://jazz.net/_images/myphoto/f5d6d046f76275997e3279c0391f47c4.jpg)
Hello,
I have been asked to investigate how to maintain in a reduced size the ALM Database. I know that I can archive some objects (I do not know if it reduce significantly the DB size).
If I backup the DB, is there a way to purge the objects in project areas, except the ones in current and previous year.
Thanks.
One answer
![](http://jazz.net/_images/myphoto/f5d6d046f76275997e3279c0391f47c4.jpg)
In the 4.0.x release functionality was added to repotools which enables users to purge data from the DB.
Comments
![](http://jazz.net/_images/myphoto/f5d6d046f76275997e3279c0391f47c4.jpg)
Thanks Mr. Abraham,
Would you tell me the name of this functionality added to reptools?
![](http://jazz.net/_images/myphoto/acd418b84bc251066fc0ef4d5b64a491.jpg)
I assume Abraham means deleteProjectAreaResouces command. This will only delete obsolete RRC resources.
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m5/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/r_repotools_deleteprojectarearesources.html
You can also look at compacting the DB indices:
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m5/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/r_repotools_compacttdb.html
I would also recommend contacting your DBA to look at database utilities which can be used to reduce the space, such as reorg, and if they are applicable in your situation.