Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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.

0 votes



One answer

Permanent link
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.

0 votes

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.

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,030

Question asked: Dec 13 '13, 7:33 a.m.

Question was seen: 3,608 times

Last updated: Jan 07 '14, 3:47 p.m.

Confirmation Cancel Confirm