A fix is available
APAR status
Closed as program error.
Error description
CQM2002E AGENT INSTALLATION FAILED FOR SUBSYSTEM. Unexpected Abends When multiple CQM or STAP address spaces are starting at the same time invalid storage pointers due to a timing issue are possible
Local fix
Space out the starting CQM and STAP by 30 seconds.
Problem summary
**************************************************************** * USERS AFFECTED: USERS AFFECTED: IBM Db2 Query Monitor z/OS * * users of component * * - CQM Data Offload and Batch Reporting * * - TCz * * - Installation and customization * * - CQM Data Collector * * - CAE server * * - ISPF Client * * - CAE Data Sharing * * - CAE Agent * * - CAE Alerts * **************************************************************** * PROBLEM DESCRIPTION: 1) Intermittent MSGCQM2002E or * * unexpected ABENDS during collector * * execution. * * * * 2) Update SCQMSAMP that Performance * * History Database Indexes not unique. * * * * 3) Comments on EXCEPTION_ANOMALIES, * * ALERT_ANOMALIES, ANOMALIES absent in * * CQMCOMM and CQMALT16 members. * * * * 4) Add message for TCz A0CNTFL for new * * DB2 before generation. * * * * 5) Add association with db2 in TCz jobs * * B0WDBAA,B1@LSTAA, B5VRUNAA. * * * * 6) Add validation for fields in Product * * Parameters(CCQPPRD) panel in TCz. * * * * 7) TCz A4BINDxx job BIND PLAN does not * * have OWNER keyword. * **************************************************************** * RECOMMENDATION: Apply this PTF. * **************************************************************** 1) Starting multiple CQM and/or STAP collectors at same time can cause overlays in CSA storage areas. 2) CQM can not provide the samples in SCQMSAMP with unique indexes as it is not known what exact data can be on customer's side and so it is impossible to select right set of columns. Every customer who wants to use unique indexes should select columns himself based on his workloads. But SCQMSAMP members refer to unique indexes. 3) The comments for EXCEPTION_ANOMALIES, ALERT_ANOMALIES, ANOMALIES were missed when CQMALT16 was created. 4) By default, the second run of A0CNTFL will delete already created CONTROL datasets and all Db2 ssids' information which was already added into it. 5) TCz generated the same name for jobs which are created by REXX part in jobs B0WDBAA, B1@LSTAA, B5VRUNAA for all DB2. Which means that the jobs will correspond to the Db2 ssid with latest run. 6) TCz did not validate fields "Started task proclib", "DB2 control file", "DB2 interval file", "DB2 profile file", "Parameter file data set name", "High-level qualifier for interval offload", "Batch Report data sets high-level qualifier", "Startup CLIST library". That can cause creating jobs which can not be run, if the customer did not understand what values are expected in these fields. 7) TCz A4BINDxx job includes BIND PACKAGE statements and BIND PLAN statement. BIND PLAN does not have OWNER keyword while all BIND PACKAGE statements have.
Problem conclusion
1) Improved serialization during collector startup. 2) Update SCQMSAMP members not to mention unique indexes. 3) Update SCQMSAMP members to have correct comments for EXCEPTION_ANOMALIES, ALERT_ANOMALIES, ANOMALIES. 4) TCz A0CNTFL job has detailed instruction of its usage. 5) Association with Db2 is added in modules CQM@LSTM, CQM@WDB2, CQMVRUN in order to avoid the same names of jobs. 6) The check for names correctness was added. 7) TCz A4BINDxx job and CQMBIND member in SCQMSAMP are updated to provide OWNER for BIND PLAN. Search Keywords: UNIQUE INDEX SCQMSAMP CQMCOMM TCZ A0CNTFL CQM@LSTM CQM@WDB2 CQMVRUN A4BIND OWNER BIND PLAN MSGCQM2002E CQMC0417E EDC8102I ERRNO_1102 CQMC0802I CQMC0107E
Temporary fix
Comments
APAR Information
APAR number
PH24622
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
2020-04-23
Closed date
2020-04-29
Last modified date
2020-05-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI69262
Modules/Macros
CQM#CTLF CQM#DRVX CQM$$PRM CQM@LSTM CQMALT15 CQMBIND CQMBLOB CQMCAE CQMCNTFL CQMCOMM CQMCPXPT CQMCREOR CQMDROP CQMEO CQMGRTB CQMINTER CQMJCC CQMPRMCR CQMQRY01 CQMVRUN CQMXDLST
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R330 PSY UI69262
UP20/04/30 P F004
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:
04 May 2020