LOCKCONT & HSUDLKTO report less than NEVENTS

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

DB2MSTR reported over 1147deadlocks. Insight LOCKCONT & HSUDLKTO report only the last 26. 

 

 

 

Environment

Release:
Component: CIDB

Resolution

There is no problem with LOCKCONT or HSUDLKTO . Considering the number of deadlocks user wanted to see, NEVENTS is too small. The recommendation is to change the NEVENTS to at least 5000 for both requests. After the changes to both requests, the DC(datacollector) needs to be recycled.