SUDDEN performance drop in obtaining Pending Changes by user

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