Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

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


0 votes



3 answers

Permanent link
 What do the JTS and RTC Logs say within this period of time?


0 votes


Permanent link
 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

0 votes


Permanent link
 Also 
http://www-01.ibm.com/support/docview.wss?uid=swg21649768

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Feb 03 '15, 8:22 p.m.

Question was seen: 4,150 times

Last updated: Nov 20 '15, 7:40 a.m.

Confirmation Cancel Confirm