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

RTC built in SQL query causes system down

Hi,

We are experimenting some problems with RTC 4.0. Sometimes, it becomes unstable and hangs for a while. We're using Oracle 11g. When I check the Enterprise Manager during the hang, I see that there is a query that is consuming most of the resources. This is the query:

SELECT distinct q1.ITEM_ID, q1.MODIFIED
FROM TEAMCONCERT.REPOSITORY_CHANGE_ EVENT q1 LEFT OUTER JOIN TEAMCONCERT.REPOSITR_CHNG_VNT_ VNT_CNTRBTRS q2 ON q2.JZ_PARENT_ID = q1.ITEM_ID
WHERE q1.MODIFIED >= :1 and q1.JZ_ITEM_DISCRIMINATOR = :2 and (q1.EVENT_AUTHOR_ITEM_ID = :3 or q2.ITEM_ID = :4 ) order by q1.MODIFIED desc

Could you tell me what is this query related to? Could it be related to RQM reports?

I don't see anything bad in the logs (Wesphere)

I would really appreciate your help.

Thanks

0 votes



One answer

Permanent link
This is a known issue.
This query is used by the change event scrubber to find the change events that have expired. Please  make sure the table stats are up to date on the change events table.  

How many rows are in JAZZDBUSER.REPOSITR_CHNG_VNT_V NT_CNTRBTRS table?
How about  JAZZDBUSER.REPOSITORY_CHANGE_EVENT;

1 vote

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
× 37
× 7

Question asked: Apr 17 '13, 4:37 p.m.

Question was seen: 6,732 times

Last updated: Apr 18 '13, 6:01 a.m.

Confirmation Cancel Confirm