PH45542: HIGH CPU AND INCORROUT SEEN AFTER PH42885 ( UI79607 )

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After applying PH42885 a thread could experience excessive CPU
  usage during SQL data collection. Other symptoms could be
  internal DDX diagnostic traps or abend0cx.
  

Local fix

• Set startup parameter OBJECTS to OBJECTS(N). This will force CQM
  to skip object collection and thus remove the incorrout
  exposure.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Query Monitor                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: High CPU and incorrout seen after       *
  *                      PH42885                                 *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  After applying PH42885 a thread could experience excessive CPU
  usage during SQL data collection.  Other symptoms could be
  internal DDX diagnostic traps or ABEND0Cx.
  

Problem conclusion

• The problem was isolated to invalidating some objects collected
  

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:

  UI80307

Modules/Macros

• CQCEUFC5 CQCMABD5 CQCMALOX CQCMB2C5 CQCMB2D5 CQCMB3C5 CQCMB3D5
  CQCMB4C5 CQCMB4D5 CQCMBNC5 CQCMBND5 CQCMBRC5 CQCMBRD5 CQCMC1D5
  CQCMC2C5 CQCMC2D5 CQCMCLD5 CQCMCMC5 CQCMCMD5 CQCMCMDS CQCMCNC5
  CQCMCND5 CQCMCOC5 CQCMCOD5 CQCMCRD5 CQCMCXD5 CQCMDLC5 CQCMDLD5
  CQCMDZC5 CQCMDZD5 CQCMESB1 CQCMESC5 CQCMESD5 CQCMFRC5 CQCMFRD5
  CQCMINSD CQCMINST CQCMLCD5 CQCMLRD5 CQCMPRD5 CQCMR1D5 CQCMRLC5
  CQCMRLD5 CQCMRRD5 CQCMSCLN CQCMSIC5 CQCMSID5 CQCMSRD5 CQCMTPC5
  CQCMTPD5 CQCMTRC5 CQCMTRD5 CQCMUGC5 CQCMUGD5 CQCMZBC5 CQCMZBD5
  CQCOXGBX CQCOXGC5 CQCOXGD5 CQCPCR1X CQCTEDC5 CQCTEDD5 CQCTK1C5
  CQCTK1D5 CQCTK2C5 CQCTK2D5 CQCTK3C5 CQCTK3D5 CQCTK4C5 CQCTK4D5
  CQCTK5C5 CQCTK5D5 CQCTK6C5 CQCTK6D5 CQCTK9C5 CQCTK9D5 CQCTTEX1
  CQCTXLC5 CQCTXLD5
  

Fix information

• Fixed component name

  COMMON COLLECTO

• Fixed component ID

  5639OLC00

Applicable component levels

• R110 PSY UI80307

     UP22/04/29 P F204 ­

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.