PK23045: ENHANCEMENT TO ADD NEW OPTKEYS(CORRNAME)

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• A new startup parameter has been added to Query Monitor V2R2 to
  support enhanced summary aggregation by CORRNAME.
  OPTKEYS(CORRNAME) will be used to direct Query Monitor to move
  only certain subsets of bytes from the originating DB2
  correlation ID to the target summarization record during the
  collection process. These subsets of bytes vary depending on the
  type of connection to DB2. e.g.TSO, BATCH, RRSAF, CICS, IMS,
  etc.
  The following documents what bytes will be moved for the various
  connection types. The remaining rightmost bytes will be space
  padded with EBCDIC blanks:
  
  TSO, CAF, RRSAF - Bytes 1-8 of the originating correlation ID.
  
  CICS - Bytes 5-8 of the correlation ID (Transaction ID).
  
  IMS - Bytes 1-4 of the correlation ID (IMS PST#)
  
  Note:  The OPTKEYS(CORRNAME) and OPTKEYS(CORRID) are mutually
  exclusive parameters and if coded together will result in error
  message CQM1008E.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: A new startup parameter has been added  *
  *                      to Query Monitor V2R2 to support        *
  *                      enhanced summary aggregation by         *
  *                      CORRNAME. OPTKEYS(CORRNAME) will be     *
  *                      used to direct Query Monitor to move    *
  *                      only certain subsets of bytes from the  *
  *                      originating DB2 correlation ID to the   *
  *                      target summarization record during the  *
  *                      collection process. These subsets of    *
  *                      bytes vary depending on the type of     *
  *                      connection to DB2. e.g.TSO, BATCH,      *
  *                      RRSAF, CICS, IMS, etc. The following    *
  *                      documents what bytes will be moved for  *
  *                      the various connection types. The       *
  *                      remaining rightmost bytes will be       *
  *                      space padded with EBCDIC blanks:        *
  *                      TSO, CAF, RRSAF - Bytes 1-8 of the      *
  *                       originating correlation ID.            *
  *                      CICS - Bytes 5-8 of the correlation ID  *
  *                       (Transaction ID).                      *
  *                      IMS - Bytes 1-4 of the correlation ID   *
  *                       (IMS PST#)                             *
  *                      Note:  The OPTKEYS(CORRNAME) and        *
  *                      OPTKEYS(CORRID) are mutually exclusive  *
  *                      parameters and if coded together will   *
  *                      result in error message CQM1008E.       *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to implement this enhancement.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK15216

Modules/Macros

•    CQM$ACTV CQM$CALL CQM$CHLP CQM$CPRF CQM$FILT
  CQM$FLTC CQM$FLTL CQM$FLTU CQM$FLT2 CQM$FNAM CQM$FUPD CQM$FVIE
  CQM$HSTV CQM$MAIN CQM$OBJS CQM$PROF CQM$PR8I CQM$PR8U CQM$PR8V
  CQM$SM01 CQM$SQCE CQM$SQCL CQM$ZCMD CQM#COMM CQM#EXCP CQM#FEXP
  CQM#FEXS CQM#FMTR CQM#INIT CQM#INTV CQM#IVCV CQM#IVSM CQM#MQRR
  CQM#MQRY CQM#PARM CQM#QACT CQM#QAPI CQM#QEXC CQM#QEXP CQM#QEXT
  CQM#QOBJ CQM#QOBR CQM#QURR CQM#QURY CQM#UINT CQM#YDAT CQM#YMAP
  CQM@ITXT CQM@MTXT CQM@WDB2 CQMBLOB  CQMCAEPT CQMCALLS CQMCOMM
  CQMCORRN CQMC0167 CQMDDL7  CQMDDL8  CQMFCOLS CQMHFLTU CQMJAR
  CQMMALRT CQMMCMON CQMMESQL CQMMEXCP CQMMEXCW CQMMHSTV CQMMINDB
  CQMMINIT CQMMPGET CQMMSCLN CQMMSSQL CQMMSTRM CQMQLE   CQMQLE1
  CQMTTEXT CQMVIEWS CQM20    CQM208E  CQM25    CQM254E  H238220J
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R220 PSY UK15216

     UP06/06/13 P F606

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.