It's all about the answers!

Ask a question

Rational Team Concert database size grows with product not in use after upgrading to CLM 5.0.1


paulo lacerda (3311414) | asked Feb 03 '15, 8:22 p.m.
JAZZ DEVELOPER
After upgrading from CLM 4.0.3 to 5.0.1 RTC/Jazz Database is growing unexpectedly when the product is not in use by its users.

What can be done to stop this behaviour?

Today it grew about 6GB in 7 hours.

DBA made some analysis and found that the following SQL commands are being heavily executed:

INSERT INTO RTC.REPOSITORY_CHANGE_EVENT (STATE_ID, ITEM_ID, CONTEXT_ID, MODIFIED, MODIFIED_BY_ITEM_ID, EVENT_OWNER_NS, EVENT_TIME, EVENT_AUTHOR_ITEM_ID, EVENT_CATEGORY, EVENT_PRIORITY, EVENT_PROCESS_AREA_ITEM_ID, JZ_EVENT_PROCESS_AREA_DSCRMNTR, EVENT_EXPIRATION, ITEM_ITEM_ID, JZ_ITEM_DISCRIMINATOR) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 )
Insert Into JTS.REPOSITORY_ITEM_STATES (ITEM_UUID, KEY_UUID, MODIFIED, ITEM_TYPE_DBID, VAL_ENCODING, ITEM_VALUE) VALUES (:1 , :2 , :3 , :4 , :5 , :6 )
INSERT INTO JTS.REPOSITORY_CHANGE_EVENT (STATE_ID, ITEM_ID, CONTEXT_ID, MODIFIED, MODIFIED_BY_ITEM_ID, EVENT_OWNER_NS, EVENT_TIME, EVENT_AUTHOR_ITEM_ID, EVENT_CATEGORY, EVENT_PRIORITY, EVENT_PROCESS_AREA_ITEM_ID, JZ_EVENT_PROCESS_AREA_DSCRMNTR, EVENT_EXPIRATION, ITEM_ITEM_ID, JZ_ITEM_DISCRIMINATOR) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 )
Insert Into RTC.REPOSITORY_ITEM_STATES (ITEM_UUID, KEY_UUID, MODIFIED, ITEM_TYPE_DBID, VAL_ENCODING, ITEM_VALUE) VALUES (:1 , :2 , :3 , :4 , :5 , :6 )
Here are the database areas that are growing:

Today at 08:30

JTS LOBINDEX     0,63
JTS LOBSEGMENT    72,50
JTS INDEX 15985,44
JTS TABLE 49620,75
65679,32
RTC LOBINDEX     1,38
RTC LOBSEGMENT  1374,56
RTC INDEX 14596,81
RTC TABLE 41754,69
57727,44
TOTAL          123406,76(MB) = 120,5GB



Today at 15:30

JTS LOBINDEX     0,63
JTS LOBSEGMENT    72,50
JTS INDEX         16409,44
JTS TABLE         51708,75
68191,32
RTC LOBINDEX     1,38
RTC LOBSEGMENT  1374,56
RTC INDEX         15308,81
RTC TABLE         44322,69
61007,44
TOTAL          129198,76(MB) = 126.1GB


3 answers



permanent link
Philippe Chevalier (56114) | answered Feb 06 '15, 2:01 p.m.
JAZZ DEVELOPER
 What do the JTS and RTC Logs say within this period of time?



permanent link
AnuM C P (15814) | answered Nov 20 '15, 7:39 a.m.
 Give a check on the SQL setting for Database Recovery Model (simple) and shrinking log files.

Few more links to check
https://technet.microsoft.com/en-us/library/ms172411%28v=sql.110%29.aspx
http://stackoverflow.com/questions/7892334/get-size-of-all-tables-in-database
http://jazz.net/wiki/bin/view/Main/DatabaseMaintenanceFAQ
http://www.ibm.com/support/docview.wss?uid=swg21390701


permanent link
AnuM C P (15814) | answered Nov 20 '15, 7:40 a.m.
 Also 
http://www-01.ibm.com/support/docview.wss?uid=swg21649768

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.