PH44770: INTERMITTENT LOOP CQM#SSMN TCB STARTING STOPPING MULTIPLE CQM COLLECTORS PER LPAR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If there are multiple CQM collectors on an LPAR, concurrent
  stopping and starting of collectors may result in a loop
  in module CQCISMPX from CQM#SSMN TCB
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Query Monitor                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: INTERMITTENT LOOP CQM#SSMN TCB          *
  *                      STARTING STOPPING MULTIPLE CQM          *
  *                      COLLECTORS PER LPAR                     *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Intermittent loop at CQM startup if multiple collectors
  started / stopped at same time, especially if all share CQM
  Master Proc.
  

Problem conclusion

• Improved serialization between collector cleanup resource
  manager and startup processing
  

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#IVSM CQM#MSSP CQM#SSMN 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$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 CQMBLOB  CQMCFPAX CQMCHMOD CQMCPXPT CQMJAR   CQMMEBCX
  CQMMEBPX CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX CQMMECRX CQMMECSX
  CQMMEDCX CQMMEDPX CQMMEDRX CQMMEDSX CQMMOD   CQMPARSE CQMSSV
  CQMUPXPT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI81169

     UP22/07/01 P F206

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.