OnDemand User Group

Support Forums => MP Server => Topic started by: sandeepveldi on February 10, 2011, 10:38:02 AM

Title: db2sysc - High CPU utilization
Post by: sandeepveldi on February 10, 2011, 10:38:02 AM

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

Title: Re: db2sysc - High CPU utilization
Post by: Justin Derrick on February 12, 2011, 01:23:52 AM

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.

Title: Re: db2sysc - High CPU utilization
Post by: sandeepveldi on February 14, 2011, 09:57:12 AM

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

Title: Re: db2sysc - High CPU utilization
Post by: Justin Derrick on February 15, 2011, 04:27:37 AM

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.