Deadlock value is 0 in Thread History Summary Display

Document ID:  TEC1688698
Last Modified Date:  07/11/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details


  • CA SYSVIEW Performance Monitor for DB2 for z/OS


  • CA Insight Database Performance Monitor for DB for z/OS:IDB2
  • Common Insight Services:CIDB

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



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. 



Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255


Not what you were looking for?

Search Again >

Product Information

Support by Product >


Join a Community >