ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Deadlock value is 0 in Thread History Summary Display

book

Article ID: 6841

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

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.