It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,549
×11,755
×14

question asked: Oct 24 '13, 11:00 a.m.
question was seen: 3,814 times
last updated: Oct 29 '13, 11:46 a.m.

Related questions

FAQ - How this Forum works

How to delete unused file to free up CCM tablespace

0
Kevin Lou (31●19●24) | asked Oct 24 '13, 11:00 a.m.
 Some of the projects have very large codebase (thousands of files) and our DB kept running into out-of-space issue. I am looking for a way delete the old, unused source files to free up the tablespace. I read the article https://jazz.net/library/article/1006 but it only covers how to delete content with individual file. Is there a way to to delete the contents of ALL the files that were added under a changeset (the one that initially loads the files to repository)?

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Matt Lennon (612●2●5) | answered Oct 24 '13, 12:59 p.m.
JAZZ DEVELOPER
Hi Kevin.

RTC will not let you delete files or file history once you've checked them in - you can only delete the content of individual file versions. Have you run a "Latest Metrics by Namespace" report to verify that it's file content and not something else (build results, attachments, etc.) taking up so much space?

-Matt
Comments
Kevin Lou commented Oct 24 '13, 1:45 p.m.

We don't have many builds managed by RTC. I am planing to move several "Learning" streams (each has 4GB+ code) to a different repository. Is there a way to delete the file contents all together? Note we have hundreds of files (this is Curam code) in the stream. 
0
permanent link
Kevin Lou (31●19●24) | answered Oct 29 '13, 11:46 a.m.
I found a "solution" to delete the contents of ALL the files in a component. I used the option "-j" (scm history -w streamUUID -c "componentName" -j) to output the component history in the JSON format (I hate the "scm list states" command since it run so slow), which has the "uuid" and "stateID" for each change.  I then wrote a Java program to parse the history JSON  file and grab "uuid" and "stateID" pairs for each change and produce the "scm delete state-content uuid stateID" command. I know this is not pretty (and very slow since the files need to be deleted one by one and I have 40K+ files), but it seems working for me at the moment. 

I really hope IBM provides a solution to remove/archive the unused source code to save the DB space. 

Your answer

Register or to post your answer.