Freeing up RTC database space

Hi Brian,

• for deleting an attachment, you could refer to this material: https://jazz.net/downloads/rational-team-concert/milestones/3.0RC0?p=news#deleteAttachments
• for deleting a source file, you could refer to this material: https://www.youtube.com/watch?v=vFMiEanEELo&list=PLDB034BC533455720&index=60
  

Note that this kind of deletions shall normally be used/reserved to administrators.

Regards,
Stéphane

what kind of Files?

source  or attachments?  Attachments are almost impossible to remove.
if they are Source.. I assume there is a history, and thus all prior versions are retained, in case you should
want to go back.  

Hi Brian,
You can try cleaning your change event objects: http://www-01.ibm.com/support/docview.wss?uid=swg21390701.

You can also use the tips from https://jazz.net/forum/questions/111357/how-to-check-which-tables-are-using-the-most-space to check which objects are using the most of the space.

Best regards,
Krzysztof Kazmierczyk

Hi Brian, to me it seems that this is more of a database capability question.

The ways of reclaiming spaces from databases are different for each database systems. It is not clear from your post which database system you are using, but assuming you are using DB2, I think there is a way to setup automatic reclaiming of spaces through a policy if automatic maintenance is enabled or you can also check table reorganization for DB2.