PI73646: QUERY MONITOR TASK USING HIGH ZIIP CPU

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Query Monitor task using high zIIP CPU.
  
  Remove the conflict with a CQM zIIP storage memory clean up
  manager and the CQM zIIP current activity collection
  (INFLIGHT(Y) ).
  
  Additional symptoms addressed by this APAR included no Current
  Activity displayed or Current Activity not getting refreshed.
  

Local fix

• - Restart the CQM Collector to resume Current Activity display.
  - Also, add INFLIGHT(N) to the CQMPARMS parameter file, until
  the permanent fix is applied (recycle CQM to pickup the change).
  Add INFLIGHT(N) - to the CQMPARMS parameter file, until the
  permanent fix is applied recycle CQM to pickup the change).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Query Monitor z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Query Monitor task using high zIIP CPU. *
  *                      Remove the conflict with a CQM zIIP     *
  *                      storage memory clean up manager and     *
  *                      the CQM zIIP current activity           *
  *                      collection (INFLIGHT(Y) ).              *
  *                      Additional symptoms addressed by this   *
  *                      APAR included no Current Activity       *
  *                      displayed or Current Activity not       *
  *                      getting refreshed.                      *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• CQM#EXCP
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R320 PSY UI43870

     UP17/01/18 P F701 Ž

• R330 PSY UI43871

     UP17/01/18 P F701 Ž

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.