It's all about the answers!

Ask a question

How to purge objects in project areas, except the ones in current and previous year?


omar pimentel (352024) | asked Dec 13 '13, 7:33 a.m.

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



permanent link
Abraham Sweiss (2.4k1131) | answered Jan 02 '14, 11:55 a.m.
Archiving artifacts will not decrease the size of the DB.  This is because these artifacts are not removed from the DB.

In the 4.0.x release  functionality was added to repotools which enables users to purge data from the DB.

Comments
omar pimentel commented Jan 07 '14, 3:17 p.m.

Thanks Mr. Abraham,

Would you tell me the name of this functionality added to reptools?


Stephanie Bagot commented Jan 07 '14, 3:47 p.m.
FORUM MODERATOR / JAZZ DEVELOPER

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.

Your answer


Register or to post your answer.