Deadlock value is 0 in Sysview for Db2 Thread History Summary Display

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Looking at the Sysview Performance Management Option for Db2 for z/OS (IDB2)
Thread History Summary Display, the Deadlock field has a value of 0.

 

Resolution

Request HTUDETL is missing the SUM function in the IQL.

Update the request with the following modification:
DEADLOCKS to SUM(DEADLOCKS)

Recycle the Data Collector to resolve the problem.