A fix is available
APAR status
Closed as program error.
Error description
ABEND0C1 in low core at address x'8' when QM is restarted within seconds after being shutdown and STAP is still activity auditing workloads. Increased CPU in monitored workloads after CQM is restarted until workload ends.
Local fix
space out Stopping and Starting CQM by at least 60 seconds.
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM Db2 Query Monitor for z/OS * **************************************************************** * PROBLEM DESCRIPTION: 1) ABEND0C1 after branch to offset X'8' * * from CQCMCMB1. * * 2) ABEND0E0-29 in CQCMESC5 causing * * recovery loop. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** 1) ABEND0C1 during shutdown of Query Monitor when STAP is still active auditing. 2) ABEND0E0-29 when running the Db2 Admin tool application.
Problem conclusion
1) There is a small time window during commit processing where QM will branch to offset 8 when STAP is still active. The 0C1 abends are recovered and the SQL commit processing is not impacted but performance can be hindered for a brief period of time if the installation has a lot of commit processing. 2) Also, recovery was entered in ARMODE and DB2 came into it's DSNXERT process with an ALET of 5 in access register 14. Search Keywords: ABEND 0C1 ABEND 0E0-29 in CQCMESC5
Temporary fix
Comments
APAR Information
APAR number
PH26484
Reported component name
COMMON COLLECTO
Reported component ID
5639OLC00
Reported release
110
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-06-16
Closed date
2020-07-16
Last modified date
2020-08-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI70580
Modules/Macros
CQCMCMB1 CQCMCMC5 CQCMESB1 CQCMESC5
Fix information
Fixed component name
COMMON COLLECTO
Fixed component ID
5639OLC00
Applicable component levels
R110 PSY UI70580
UP20/07/17 P F007 ¢
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021