PH67245: COLLECT AND DISPLAY QUERYNO, DECLARE STATEMENT NUMBER, DYNAMIC AND STATIC STATEMENT IDS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Collect and display Queryno, Declare Statement Number, Dynamic
  and Static Statement IDs for summaries, exceptions, current
  activity and SQL Codes.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Query Monitor for z/OS.         *
  ****************************************************************
  Collect and display Queryno, Declare Statement Number, Dynamic
  and Static Statement IDs for summaries, exceptions, current
  activity and SQL Codes.
  

Problem conclusion

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#EXCP CQM#FEXP CQM#FEXS CQM#FMTR CQM#FOBJ CQM#INTX
  CQM#IVCV CQM#IVSM CQM#QAPI CQM#QAPX CQM#QSQL CQM#XLVL 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$FLT2 CQM$FLTC
  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$SU8J CQM$TEXT CQM$XQVE CQM$YLOG CQM$YXLG CQM$ZCMD CQM@WDB2
  CQMALT05 CQMBLOB  CQMC0291 CQMC0292 CQMC0293 CQMCAE   CQMCAPI
  CQMCFPAX CQMCOMM  CQMCPXPT CQMCREOR CQMDDL   CQMHINTC CQMHOPTN
  CQMHPARL CQMHSQCE CQMHSQCF CQMHSQCL CQMHSUCT CQMHSUMJ CQMHSUSP
  CQMIDAM6 CQMJAR   CQMMALRX CQMMECCX CQMMECPX CQMMECRX CQMMECSX
  CQMMEDCX CQMMEDPX CQMMEDRX CQMMEDSX CQMMEMTX CQMMEXCX CQMMEXXX
  CQMMINIX CQMMMETX CQMMSCCX CQMMSCPX CQMMSCRX CQMMSCSX CQMMSDCX
  CQMMSDPX CQMMSDRX CQMMSDSX CQMMSQLX CQMMZIIP CQMPARSE CQMPIKEY
  CQMPRKEY CQMZEMTR CQMZEXCP CQMZEXCS
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R340 PSY UO04724

     UP25/09/05 P F509  

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.