search cancel

Insight still consuming about 50% of CPU.


Article ID: 6461


Updated On:


Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS


Insight Datacollector is consuming about 50% of CPU. What could be the possible cause(s) of the CPU spike.





Component: CIDB


CPU Spike or excessive CPU usage needs to be investigated on case by case basis. In general there are two data base exceptions in the Insight exception system that have extremely high overhead at r17. They are the data base "high space used" and "high number of extents" exceptions. They were re-written at r19 and are quite efficient now, but on r17 they should be inactivated if they are causing high CPU usage in the data collector.