Insight still consuming about 50% of CPU.

book

Article ID: 6461

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

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

 

 

 

Environment

Release:
Component: CIDB

Resolution

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.