Deadlock value is 0 in Thread History Summary Display
book
Article ID: 6841
calendar_today
Updated On:
Products
CA Bind Analyzer for DB2 for z/OSCA DetectorCA SQL-Ease for DB2 for z/OSCA Sysview Performance Management Option for DB2 for z/OSCA Database Detector for DB2 for z/OSCA Plan Analyzer for DB2 for z/OSCA 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.