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
3 answers
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