PH70770: IMPROVE PERFORMANCE WHEN MONITORING CURSORS WITH A PROFILE THAT HAS NO ALERTS OR EXCEPTIONS SPECIFIED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Improve Performance when monitoring cursors with a profile that
  has no alerts or exceptions specified
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Query Monitor for z/OS          *
  ****************************************************************
  Improve Performance when monitoring cursors with a profile that
  has no alerts or exceptions specified
  

Problem conclusion

• Improvements in Db2 Class II time.
  

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#CINT CQM#FCMD CQM#FEXP CQM#FEXS CQM#FMTR CQM#FOBJ CQM#INIX
  CQM#IVSM CQM#QAPI CQM#QAPX CQM#QSQL CQM#UINX CQM$ABND CQM$ACTV
  CQM$BUFP CQM$CALL CQM$CHLP CQM$CNCL CQM$CPRF CQM$DB2C CQM$DDB2
  CQM$DELY CQM$DSCV CQM$ERRP CQM$FILT CQM$FLAC CQM$FLAU CQM$FLEC
  CQM$FLEU CQM$FLT1 CQM$FLT2 CQM$FLTC CQM$FLTL CQM$FLTU CQM$HSTV
  CQM$INTD CQM$INTV CQM$LINK CQM$LOCK CQM$MAIN CQM$OBJS CQM$OPTN
  CQM$PRFG CQM$PRFS CQM$PROF CQM$QLCA CQM$QRPT CQM$RANG CQM$SLIP
  CQM$SM01 CQM$SM02 CQM$SMKY CQM$SQC2 CQM$SQC3 CQM$SQCD CQM$SQCE
  CQM$SQCI CQM$SQCL CQM$SQCM CQM$SQCP CQM$SQCS CQM$SQLT CQM$TEXT
  CQM$XQVE CQM$YLOG CQM$YXLG CQM$ZCMD CQM20    CQM208E  CQM212E
  CQM33    CQM336E  CQM337E  CQM338E  CQM@LDB2 CQM@LIDA CQM@LSTM
  CQM@WDB2 CQMHFIL3 CQMHFILU CQMHFLTC CQMHFLTL CQMHFLTU CQMHFLTV
  CQMMECCX CQMMECPX CQMMECRX CQMMECSX CQMMEDCX CQMMEDPX CQMMEDRX
  CQMMEDSX CQMMEMTX CQMMMETX CQMMQAPX CQMOREDX CQMPARSE CQMQSTAT
  CQMZEMTR CQMZREDC
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R340 PSY UO07968

     UP26/05/28 P F605

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.