A fix is available
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 number
PH44770
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
330
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-03-10
Closed date
2022-06-24
Last modified date
2022-09-08
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.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.3.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
08 September 2022