PH69156: REDUCE BUILDUP OF PASN-AL ENTRIES AFTER MANY RESTARTS OF DB2 WHILE QM IS ACTIVE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• QM builds up a number of entries in it's own and it's master
  address space's PASN-AL list over time after QM or it's master
  address remaining active over the Db2 restarts.
  

Local fix

• Recycle the QM address space and/or the QM master address space.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Query Monitor for z/OS          *
  ****************************************************************
  * PROBLEM DESCRIPTION: QM builds up a number of entries in its *
  *                       own and its master address spaces'     *
  *                      PASN-AL list over time after QM or its  *
  *                      master address space remaining active   *
  *                      over the Db2 restarts.                  *
  ****************************************************************
  * RECOMMENDATION: Workaround: Recycle the QM address space     *
  *                 and/or the QM master address space.          *
  ****************************************************************
  Reduce buildup of PASN-AL entries after many restarts of Db2
  while QM is active
  

Problem conclusion

• The code was updated to prevent a build up of entries in the
  PASN-AL lists for the QM address spaces.
  

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:

  UO06919

Modules/Macros

• CQC#XLVL CQCMINSD CQCMINST
  

Fix information

• Fixed component name

  COMMON COLLECTO

• Fixed component ID

  5639OLC00

Applicable component levels

• R110 PSY UO06919

     UP26/02/27 P F602

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.