How Do I Delete Data from the RM Database After 6.0?
By default in CLM, when you delete data from one of the applications, that application "forgets" about the data, but it remains in the database. Over time, this can cause the database to be much larger than it needs to be. Data flagged as deleted in CLM should be able to be removed from the database as well. In particular, my team has a need of removing data from the RM database.
I decided to try this out by uploading an 800MB artifact to RM in a test environment. I did this and then confirmed that the RM database increased in size by ~800MB. I then deleted the RM artifact. I ran the aforementioned task and then tried to execute the "Shrink Database" command in our SQL Server 2012 instance. The database size remained unchanged. The 800MB was still present.
Has anyone done this successfully? The tech note explains that some databases may have a delay before the database is resized to account for deleted data. In our instance, we've waited 2 or 3 weeks since this test. I can imaging that different database architectures may handle purging of data in different ways. It's conceivable that SQL Server needs to have some kind of explicit command executed in order to purge deleted data, but a couple of internet searches have not revealed any such command.
I have an open Service Request with IBM asking for help on this, but the rep handling the request is taking the position that she believes the CLM task is working as it should (how can we even tell that?) and if the database isn't shrinking, that's our problem with SQL Server. Can anyone confirm?
|
3 answers
I have done some testing and compared the result with the technote, and believe that for RDNG 6.0.x, there is no way to release space for individual deleted artifacts. As you have observed, the database size remains unchanged. The only way the I found is the delete _all_ artifacts in a project area, and then use the deleteJFSResources command. These are the sizes that I observed of the RDNG database.
1. After registering in JTS - 106.06 MB. 2. After creating two sample projects - 180.06 MB. 3. After deleting all the artifacts in RDNG GUI - 205.06 MB. 4. After running deleteJFSResources command and shrink the database - 153.89 MB. Also, I don't think the CleanUpUnusedIndexesVersionsTask will do the same thing as the deleteJFSResources command. It maintains the index, so it could be something similar to what "-reindex all" does. |
So, is there actually a way to do this then or does a work item need to be created?
|
A couple of follow-ups/update on this topic:
|
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.
Comments
It may be that another step is required to shrink the database. For DB2 the process is described in the RTC technote. This may not apply to RM, so please take this with a grain of salt, but perhaps something like reorg and then alter tablespace (database shrink) is necessary.
Reducing the size of the Rational Team Concert repository database
https://jazz.net/library/article/1459