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?
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.
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
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