It's all about the answers!

Ask a question

RTC 3.0 DB2 db2syscs.exe CPU utilization is 100%


Simon Sasaki (161) | asked Jan 05 '11, 5:14 a.m.
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



permanent link
Simon Sasaki (161) | answered Jan 07 '11, 10:36 a.m.
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


Register or to post your answer.