db2sysc - High CPU utilization

[sandeepveldi]

Hi,
Did anyone face the issue of db2sysc process using most of the CPU and all the CMOD transactions start failing? This is the second time that this issue occurred on our prod server. Everytime this occurs, we have bounce CMOD & DB2 to bring the CPU utilization down.

Any help on this highly appreciated.

Thanks in advance,
Sandeep Veldi

[Justin Derrick]

The most common cause of this is that someone, somewhere is doing a crazy query, like searching for a wildcard on string field with no index.

-JD.

[sandeepveldi]

We checked that. All the fields available for search are indexed ones.

[Justin Derrick]

There are lots of ways to create really insane queries -- check your System Log for queries that begin just before you start to experience the problem.

-JD.