PH59464: EXAGGERATED CPU VALUES FOR FETCH INTENSIVE WORKLOADS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Fetch intensive workloads may show exaggerated DB2 CPU values
  DB2 TOOLS SQL COLLECTOR ABEND=0C4-000000xx Dump generated
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor               *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Fetch intensive workloads may show exaggerated DB2 CPU values
  Also m/s DB2 TOOLS SQL COLLECTOR ABEND=0C4-00000011 may occur
  

Problem conclusion

• Corrected bypass of collecting CPU times
  Corrected gap in 64-bit pointer format during commit collection
  

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$BUFP CQM$INTV CQM$LINK CQM$MAIN CQM$MALT CQM@LSTM CQM@SETP
  CQM@STX8 CQM@TBL8 CQM@WDB2 CQMBLOB  CQMCAE   CQMCAPI  CQMCFPAX
  CQMCLIST CQMCPXPT CQMCREOR CQMICSF  CQMJAR   CQMMEBCX CQMMEBPX
  CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX CQMMECRX CQMMECSX CQMMEDCX
  CQMMEDPX CQMMEDRX CQMMEDSX CQMMSBCX CQMMSBPX CQMMSBRX CQMMSBSX
  CQMMSCCX CQMMSCPX CQMMSCRX CQMMSCSX CQMMSDCX CQMMSDPX CQMMSDRX
  CQMMSDSX CQMODP   CQMUPXPT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI95792

     UP24/02/29 P F402

• R340 PSY UI95793

     UP24/03/12 P F403

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.