How to purge objects in project areas, except the ones in current and previous year?
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
In the 4.0.x release functionality was added to repotools which enables users to purge data from the DB.
Comments
Thanks Mr. Abraham,
Would you tell me the name of this functionality added to reptools?
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.