It's all about the answers!

Ask a question

SUDDEN performance drop in obtaining Pending Changes by user


Kevin Ramer (4.5k6167186) | 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.