PH68632: AVOID REPEATED OPENING OF THE CQM INTERVAL DATASET DURING METRICS API REQUESTS WITH OBJECT FILTERING.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Avoid repeated opening of the CQM interval dataset during
  metrics API requests with object filtering.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Query Monitor for z/OS.         *
  ****************************************************************
  Avoid repeated opening of the CQM interval dataset during
  metrics API requests with object filtering.
  

Problem conclusion

• The code was updated to prevent the issue.
  

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#BCMX CQM#INIX CQM#QAPI CQM#QAPX CQM#QSQL CQM$ACTV CQM$BUFP
  CQM$CALL CQM$DELY CQM$DSCV CQM$INTV CQM$LINK CQM$LOCK CQM$MAIN
  CQM$QRPT CQM$SM01 CQM$SQCE CQM$SQCL CQM$SQLT CQM$STAT CQM@STX8
  CQM@WDB2 CQMBIND  CQMBLOB  CQMCAE   CQMCAEAP CQMCAPI  CQMCFPAX
  CQMCPXPT CQMCREOR CQMHACTA CQMHBUF8 CQMHBUFS CQMHCALL CQMHCODI
  CQMHCODS CQMHCPRF CQMHCTX8 CQMHDB2C CQMHDDB2 CQMHDEL8 CQMHDELS
  CQMHDSCD CQMHDSCV CQMHEXCA CQMHFIL0 CQMHFILT CQMHFILU CQMHFLTC
  CQMHFLTR CQMHFLTV CQMHHSTV CQMHINNV CQMHINTD CQMHINTV CQMHLOC8
  CQMHLOCS CQMHMAI1 CQMHMAI2 CQMHMAI3 CQMHMAI4 CQMHMAI5 CQMHMAIN
  CQMHMST1 CQMHOBJS CQMHPARL CQMHPRGI CQMHPRIA CQMHPRIE CQMHPRIS
  CQMHPROF CQMHPRSA CQMHPRSE CQMHPRSS CQMHQLCA CQMHRAN0 CQMHSMKY
  CQMHSQC2 CQMHSQC3 CQMHSQCC CQMHSQCD CQMHSQCE CQMHSQCF CQMHSQCL
  CQMHSQCM CQMHSQCP CQMHSQCS CQMHSQCT CQMHSUCT CQMHSUMB CQMHSUMC
  CQMHSUMJ CQMHSUMK CQMHSUML CQMHSUMP CQMHSUMQ CQMHSUMT CQMHSUSP
  CQMHTEX8 CQMHTEXT CQMHUPRF CQMHVPRF CQMJAR   CQMMEMTX CQMMEXXX
  CQMMFREX CQMMQAPX CQMMZIIP CQMPIKEY CQMPRKEY CQMZEMTR CQMZEXCP
  CQMZEXCS
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R340 PSY UO06198

     UP25/12/18 P F512

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.