PK14074: CORRECT POTENTIAL LOOP IN DB2 PRECEDED BY LOOPING IN MODULES CQMMSQ71 OR CQMMSQ81

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This is evidenced by a general slowing of DB2 workloads until
  DB2 recycle is required.  The looping in DB2 is preceded by
  looping in QM modules CQMMSQ71 or CQMMSQ81 which is a result of
  either:
  
  * CQM being deactivated.
     In this case we are talking about deactivating the
     Monitoring Agent. This is done by:
     - selecting option M. (Work with Monitoring Agents)
       from the main "IBM DB2 Query Monitor" panel,
     - then entering a D-(Deactivate) next to a Monitoring
       Profile.
  * or CQM not getting fully installed.
    We have seen this situation where QM is at a lower
    dispatch priority than DB2 so QM can not keep up
    with DB2 processing.  Without this APAR QM may not
    fully install itself opening a window for this
    looping problem.
  

Local fix

• * Shut down CQM (as opposed to deactivation) and
  * Set QM dispatch priority to that of DB2.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Code will be changed to address a       *
  *                      possible loop in DB2 when Query         *
  *                      Monitor ( CQM ) is deactivated.         *
  ****************************************************************
  * 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:

  UK09078

Modules/Macros

•    CQM#COMM CQMMSQ71 CQMMSQ81
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R210 PSY UK09078

     UP05/11/17 P F511

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.