It's all about the answers!

Ask a question

Freeing up RTC database space


Brian Reynolds (1689) | asked May 20 '13, 3:32 p.m.
If you actually delete entire files in RTC, as opposed to versions, is the space automatically
reclaimed in the underlying database? That is, if you delete a 5  1GB files in RTC, will the
database shrink 5 GB?

Are there any official recommendations about how to shrink the DB?

4 answers



permanent link
Stephane Leroy (1.4k149) | answered May 21 '13, 4:26 a.m.
JAZZ DEVELOPER
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

permanent link
sam detweiler (12.4k6180201) | answered May 20 '13, 4:59 p.m.
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.  


permanent link
Krzysztof Ka┼║mierczyk (7.4k34796) | answered May 21 '13, 3:14 a.m.
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

permanent link
Indradri Basu (1.8k1514) | answered May 21 '13, 5:30 a.m.
edited May 21 '13, 5:30 a.m.
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.

Your answer


Register or to post your answer.