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 (15714) | 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 (15714) | 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.