search cancel

CA Sysview for DB2 (IDB2) Data Collector looping and causing high CPU

book

Article ID: 203120

calendar_today

Updated On:

Products

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 Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

 The CA Sysview for Db2 (IDB2) Data Collector experienced a looping condition that caused high CPU.

Environment

Release : 20.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS

Cause

Per the PTF SO14843 problem description:

The CA SYSVIEW Performance Management Option for DB2 for z/OS (IDB2)
data collector may go into a loop while processing IDB2 Accounting  
data, if the HIST-ACCT-DETAIL SYSPARM uses the SQL or PDTSQL option.
                                                                    
This problem may occur if either SO14016 or SO14642 are applied.    

Resolution

The application of PTF SO14843 is critical to resolve the DC looping condition. However, in the interim you can change the SYSPARM HIST-ACCT-DETAIL as a circumvention. Remove the value 'PDTSQL' and / or 'SQL' or comment out the statement entirely. You will no longer get the extended IDB2 accounting data if you comment it out, but that should resolve the error until the PTF SO14843 can be applied.