A fix is available
APAR status
Closed as program error.
Error description
Convert segmented Db2 table spaces in Query Monitor to Partition-by-growth (UTS) table spaces. Sorting by AELAP_ROLLLM on CQM$EXCA Causes 0C1 Abend
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: IBM Db2 Query Monitor for z/OS 3.3.0 * * users of components: * * - CAE Agent * * - CAE Server * * - CAE Archive Connections * * - CAE - DSM - Data Studio * * - TCz * * - CQM Data Offload and Batch Reporting * * - Exceptions * * - Users of DB2 Query Monitor monitoring SQL * * workloads that contain long running COMMITs * * or ROLLBACKs that cross QM interval * * boundaries. * **************************************************************** * PROBLEM DESCRIPTION: 1. Convert segmented Db2 table spaces * * in Query Monitor to Partition-by-growth * * (UTS) table spaces. * * 2. Setting sort by AELAP_ROLLLM field * * in exceptions causes Abend 0C1 in * * CQM$ACTV. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** 1. Convert segmented Db2 table spaces for OFFLOAD, Staging tables and statement types in Query Monitor to Partition-by-growth (UTS) table spaces. 2. Setting sort by AELAP_ROLLLM failed due to internal problem with processing this filter name.
Problem conclusion
1. Convert segmented Db2 table spaces for OFFLOAD and statement types in Query Monitor to Partition-by-growth (UTS) table spaces 2. Logic was updated to process AELAP_ROLLLM filter name correctly. Search Keywords: SEGMENTED UTS TABLESPACES OFFLOAD SORT AELAP_ROLLLM EXCEPTIONS CQM$EXCS ABEND 0C1 CQM$ACTV
Temporary fix
Comments
APAR Information
APAR number
PH13449
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
2019-06-14
Closed date
2020-05-27
Last modified date
2020-06-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI69691
Modules/Macros
CQM$ACTV CQMDDL CQMDDLST CQMMEACX CQMMEAPX CQMMEARX CQMMEASX CQMMEBCX CQMMEBPX CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX CQMMECRX CQMMECSX CQMMEMTX CQMUTS1 CQMUTS2 CQMUTS3 CQMXDLST
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R330 PSY UI69691
UP20/05/28 P F005
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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z Systems"}],"Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
14 December 2020