REPOSITORY_ITEM_STATES grows too quickly
The tablespace RQMDATA is huge 96G! due this table that grows in terms of 3 millions records per week! during the last two months. We tryed to solve and reduce this tablespace deleting all records from the last two years, but after this we could not start CLM plus the RQM. So we had to restore from our Backup.
Can anybody suggest us what to do? Thanks in Advance. |
4 answers
Hello Isaias,
The first thing I would suggest is to reorg the DB. If this does not reduce the size of the DB, then the next action would be to query the users to determine if they recently started uploading large objects to workItems or via change sets. , Comments
Isaias Zaral
commented Jun 13 '13, 3:50 a.m.
Hi Abraham,
|
Hello Isaias,
The referenced defect is for Rational Asset Manager. CLM does not currently have a method to purge data from the DB. |
In 4.0 looks like we have added ability to purge data from the DB. See the following post for more details
https://jazz.net/forum/questions/117448/rtc-is-there-a-way-to-reduce-size-of-current-db-apart-from-change-events-scrubbing?redirect=%2Fforum%2Fquestions%2F117448%2Frtc-is-there-a-way-to-reduce-size-of-current-db-apart-from-change-events-scrubbing Comments
James Paulus
commented Jan 06 '14, 1:42 p.m.
The problem is that this is only for source control. Is there an enhancement/defect out there to have purging for CLM? Based on Abraham's statement nothing currently exists. |
In RQM 4.0.4, "permanent delete" was added. Before that, deleted artifacts were not deleted from the repository and were in a sense only archived. But this new feature will allow users who are granted permission to move artifacts to the "Trash" view (archive them) and where they can be viewed and then permanently delete them from the database.
Take a look at this link:
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/index.jsp?re=1&topic=/com.ibm.rational.test.qm.doc/topics/c_deleting_artifacts.html&scope=null
Given that you are growing so quickly and can delete a couple of years of data, it might be worth it to upgrade for this.
Hope this helps.
Toni |
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.