RTC 3.0 DB2 db2syscs.exe CPU utilization is 100%
Hello
We had used RTC 2.0.0.2 for half year. It was good enough performance. then We upgrade the RTC from 2.0.0.2 iFix 3 to 3.0. We are using DB2 Express 9.7 FixPack 1 as JAZZ repository. Of course, the machine has a dual-core CPU. The db2syscs.exe CPU utilization is 100% now. However the Tomcat process CPU utilization is less than 5%. When I check the task manager, memory usage is not rising. No frequent hard disk access. CPU:Dual CPU Intel 2.26GHz Memory:4GB Application Servers:Apache Tomcat 5.5.30 Databases:DB2 Express Edition v9.7 Fix Pack 1 Operating Systems:Windows The database is changed from one JAZZ database to two JTS and JAZZ. So I did DB2 RUNSTATS ,REORG and BIND commands for both JTS and JAZZ. The problem is not solved yet. Has anyone seen that behaviour? |
One answer
|
I used DB2 snapshot monitor to capture information about trouble SQL from RTC. It was always the same SQL statement.
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> */ A user in the deliver source code, were canceled. I do not know whether It happens before migration or after. I found out that Every time he opens his workspace, 100% CPU utilization occurred. I checked the file hierarchy of his repository workspace. It was somehow wrong state. He created a new local workspace and The problem is solved! Snapshots were useful for determining the status of a database system. 1.STATEMENT and UOW monitor switch ON db2 update monitor switches using UOW ON db2 update monitor switches using STATEMENT ON 2.RTC launch and use... 3.capture information db2 get snapshot for applications on JAZZ Thank you |
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.