Deadlock value is 0 in Thread History Summary Display

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

Products

  • CA SYSVIEW Performance Monitor for DB2 for z/OS

Components

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

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

 

Workaround:

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

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing