Deadlock value is 0 in Thread History Summary Display

Article Id: 6841

Status: Published

Updated On: 14-02-2018 08:14

Legacy Id: TEC1688698

Products:

CA Bind Analyzer for DB2 for z/OS , 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:

Looking at the Thread History Summary Display, the Deadlock field has a value of 0. Why?

Environment:

Release:
Component: CIDB

Resolution:

R18 HTUDETL is missing SUM function in the IQL. Update the request with the following modification DEADLOCKS to SUM(DEADLOCKS) and recycle the Data Collector to resolve the problem.