Author Topic: db2sysc - High CPU utilization  (Read 15846 times)

sandeepveldi

  • Guest
db2sysc - High CPU utilization
« 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

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: db2sysc - High CPU utilization
« Reply #1 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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

sandeepveldi

  • Guest
Re: db2sysc - High CPU utilization
« Reply #2 on: February 14, 2011, 09:57:12 AM »
We checked that. All the fields available for search are indexed ones.

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: db2sysc - High CPU utilization
« Reply #3 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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR