PH22035: CQM2002E AGENT INSTALLATION FAILED FOR SUBSYSTEM, UNEXPECTED ABENDS

Obtain the fix for this APAR.

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 is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  PH24622 UI69261

Modules/Macros

• CQM#CTLF CQM#DRVX CQM$$PRM CQM$$SEQ CQM@LSTM CQM@WDB2 CQMALT15
  CQMALT17 CQMBIND  CQMBLOB  CQMC2LST CQMCAE   CQMCAEPT CQMCAESV
  CQMCAPI  CQMCLST1 CQMCNTFL CQMCOMM  CQMCPXPT CQMCREOR CQMCUNPX
  CQMCUPPT CQMDDL   CQMDROP  CQMEO    CQMGRTB  CQMINDEX CQMINTER
  CQMJAR   CQMJCC   CQMJCC4  CQMLNCH  CQMMSTR  CQMPRMCR CQMPROC
  CQMPROFS CQMPTFRM CQMQRY01 CQMRBIND CQMUPXPT CQMVRUN  CQMXDLST
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI69261

     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.