A fix is available
APAR status
Closed as program error.
Error description
It was long discussion around, and we definitely decided in a reason to do not default value and a range.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM Db2 Query Monitor for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: 1. Query Monitor stops displaying * * current activity under high load. * * 2. ABEND CQMMCALC+2622D is seen in DDX. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** 1. A restart of Query Monitor under heavy workload may cause threads to be missing in Current Activity due to exhaustion of memory for THREAD space. 2. Some calculations used the logic and offsets for older versions of Db2 that may cause problems for Db2 v11-v12.
Problem conclusion
1. Logic was changed to correctly clear memory under heavy workloads. 2. Logic was updated to use correct calculations and offsets for every supported Db2 version. Search Keywords: MEMORY LEAK CURRENT ACTIVITY ABEND CQMMCALC 2622D
Temporary fix
Comments
APAR Information
APAR number
PH35956
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
2021-04-01
Closed date
2021-06-16
Last modified date
2021-07-02
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#PARM CQM#SSMN CQM$ACTV CQMMACTX CQMMCALX CQMMEACX CQMMEAPX CQMMEARX CQMMEASX CQMMEBCX CQMMEBPX CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX CQMMECRX CQMMECSX CQMMEXCX CQMMEXXX CQMMINDX
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R330 PSY UI75914
UP21/06/22 P F106
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.
[{"Type":"MASTER","Line of Business":{"code":"","label":""},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":""},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Document Information
Modified date:
03 July 2021