It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787

question asked: Apr 26 '11, 1:29 p.m.
question was seen: 4,267 times
last updated: Apr 26 '11, 1:29 p.m.

Related questions

FAQ - How this Forum works

SUDDEN performance drop in obtaining Pending Changes by user

0
Kevin Ramer (4.5k●8●183●200) | asked Apr 26 '11, 1:29 p.m.
Hi,

RTC v2.0.0.2 ifix4, DB2 v9.5. User community hit issue not being able to refresh their pending changes. Statistics page shows .. compareWorkspaces() averaging >850sec.
DB2 process db2sysc hitting CPU in high 90% range. The active applications can be seen
running this query 


SELECT JZ_PARENT_ID, ITEM_ITEM_ID, JZ_ITEM_DISCRIMINATOR, STATE_COL, PARENT, NAME_COL, LOCKED_BY FROM SCM.CONFIGURATION_SELECTIONS WHERE JZ_PARENT_ID IN (?,?) AND ITEM_ITEM_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) /* <OPTGUIDELINES><INLIST2JOIN><INLIST2JOIN><NLJOIN><ACCESS><ACCESS></NLJOIN></OPTGUIDELINES> */


With very high read counts on the SCM.CONFIGURATION_SELECTIONS table.

While I look for the data warehouse reports to deploy on this RTC any suggestions out there ?

Kevin

Be the first one to answer this question!

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.