It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,951
×6,028

question asked: Jun 12 '13, 3:56 a.m.
question was seen: 4,738 times
last updated: Jan 06 '14, 5:27 p.m.

Related questions

REPOSITORY_ITEM_STATES grows too quickly

0
Isaias Zaral (1●1●1) | asked Jun 12 '13, 3:56 a.m.
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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Abraham Sweiss (2.4k●13●31) | answered Jun 12 '13, 8:07 a.m.
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,

I already try this option inside a copy instance without a relevant change. I found too that already someone posted last month a defect about this topic:
 https://jazz.net/jazz02/web/projects/Rational%20Asset%20Manager#action=com.ibm.team.workitem.viewWorkItem&id=84508

We are still looking for a solution and investigating what is the cause for growing so quickly.

Thanks for the answer.

0
permanent link
Abraham Sweiss (2.4k●13●31) | answered Jun 13 '13, 11:30 a.m.
Hello Isaias,

The referenced defect is for Rational Asset Manager.

CLM does not currently have a method to purge data from the DB.

0
permanent link
Abraham Sweiss (2.4k●13●31) | answered Jul 03 '13, 3:21 p.m.
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. 
0
permanent link
Antoinette Iacobo (650●7●12) | answered Jan 06 '14, 5:27 p.m.
 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

Register or to post 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.