PH35517: QM parameter parser stops prematurely on missing/invalid continuation syntax

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• QM parameter parser stops prematurely on missing/invalid
  continuation syntax
  

Local fix

• Put a space between ) and - in the CQMPARMS dataset.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor for z/OS      *
  *                 users of component:                          *
  *                 - CQM Data Collector                         *
  *                 - TCz                                        *
  *                 - Documentation - Public use                 *
  *                 - ISPF Client                                *
  *                 - Summaries                                  *
  *                 - Data Sharing                               *
  *                 - CQM Data Offload and Batch Reporting       *
  *                 - CAE Server                                 *
  *                 - CAE Agent                                  *
  *                 - CAE - Monitoring profile                   *
  *                 - CAE - QM Subsystem Management              *
  *                 - CAE - EO (HostVar Collection)              *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Abbreviation IDAA should be          *
  *                      replaced by "IBM Db2 Analytics          *
  *                      Accelerator" or just "accelerator".     *
  *                      Comments in SAMPLIBs and DENULIB        *
  *                      contain misspelling of MAXPARTITIONS.   *
  *                      2. Query Monitor parameter parser       *
  *                      stops prematurely on missing/invalid    *
  *                      continuation syntax.                    *
  *                      WPSIZE parameter range was defined      *
  *                      incorrectly.                            *
  *                      3. If two members of the same Db2       *
  *                      Datasharing group on the same LPAR are  *
  *                      monitored by the same Query Monitor,    *
  *                      static SQL texts are marked by one      *
  *                      ssid, dynamic SQL texts are marked by   *
  *                      another.                                *
  *                      4.Setting range of intervals starting   *
  *                      from the currently active one caused    *
  *                      excepted CQM1048E message in OFFLOAD    *
  *                      but all other intervals were not        *
  *                      processed. Setting range of intervals   *
  *                      higher than the currently active        *
  *                      caused uploading current incomplete     *
  *                      interval.                               *
  *                      5. Help is not available for AVG        *
  *                      column in Buffer Pool Statistics.       *
  *                      6. CAE Agent DBRMs do not show the      *
  *                      correct version.                        *
  *                      7. "Wrong token guest" warning message  *
  *                      is displayed in the CAE Server log      *
  *                      during logon procedure on CAE logon     *
  *                      web page.                               *
  *                      8. The user who does not have an        *
  *                      access to CQM.CHANGE.PROFILE.** RACF    *
  *                      profile can activate Db2 monitoring on  *
  *                      QM Subsystems Management panel, but     *
  *                      profile is not correct.                 *
  *                      9. "View Profile" logic on Monitoring   *
  *                      Agents panel has different              *
  *                      behavior in ISPF and Web.               *
  *                      CAE always displays the updated         *
  *                      profile by clicking "View Profile"      *
  *                      button on Monitoring Agents             *
  *                      panel.                                  *
  *                      10. "Add Profile" logic works           *
  *                      incorrectly if any other profile is     *
  *                      selected in data grid.                  *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  1. IDAA should be replaced by "IBM Db2 Analytics Accelerator"
  or just "accelerator".
  MAXPARTITIONS is misspelled in comments.
  2. There was no algorithm to check for the existence of at
  least one space before the continuation character. It was
  possible for the WPSIZE parameter to be a larger value than
  Query Monitor supports.
  3. If two members of the same Db2 Datasharing group on the
  same LPAR are monitored by the same Query Monitor, static SQL
  texts are marked by one ssid, dynamic SQLtexts are marked by
  another. When ssid for static SQL texts goes down, Query
  Monitor shows empty lines instead of static SQL texts in
  datasharing mode.
  4. There was an error in the algorithm for selecting intervals
  for uploading, when the list of uploaded intervals contained
  the currently active interval.
  5. There was no mention of AVG column in help panel for
  "Buffer Pool Statistics". Help panel also did not contain
  algorithms for the "Buffer Pool Hit Ratio (%)" and "Hiper
  Pool Hit Ratio (%)" lines.
  6. CAE Agent DBRMs showed the BETA0410 as a version. The DBRMs
  should show the correct APAR number as a version.
  7. For the welcome page CAE server internally uses an account
  without token. As a result warning message "Wrong token guest"
  is displayed in the CAE Server log.
  8. A user that does not have an access to
  CQM.CHANGE.PROFILE.** RACF profile and has an access to
  CQM.ACTIVATE.** RACF profile can only Re-activate Db2
  monitoring with the profile under which the Db2 had been
  monitored previously.
  Any attempt to activate Db2 monitoring under different
  profile will lead to activation with empty profile.
  9. By clicking "View Profile" button user should see the
  actual profile under which Db2 is currently being monitored.
  When the user updates the monitoring profile they shouldn't
  see updated profile by clicking "View Profile" button,
  but should see old profile.
  To update the monitoring profile, the user should press
  "Refresh Db2 Profile" button to have the changes in place.
  10.By clicking "Apply" button in "Add profile" pop-up
  window the changes are applied for a newly created profile,
  but subsequent clicks of "Apply" button will
  lead to changes having been applied to a profile previously
  chosen from the data grid.
  

Problem conclusion

• 1.In the jobs comments and in the REXX procedure comments the
  IDAA abbreviation is changed to "Accelerator".
  "MAXPARTITION" spelling is also corrected.
  2. Parsing algorithm was changed to check if there is at least
  one space before the continuation character. WPSIZE parameter
  range was corrected.
  3. Logic was corrected to extract static SQL via another
  member of the same Db2 Datasharing group.
  4. The algorithm for selecting intervals for uploading was fixed
  when the list of uploaded intervals contains the currently
  active interval.
  5. Help panels were added to describe AVG column.
  The calculation algorithm for the lines "Buffer Pool Hit
  Ratio (%)" and "Hiper Pool Hit Ratio (%)" was added
  to the field description panel.
  6. The build logic of the CAE Agent DBRMs has been corrected
  to pick up the APAR number.
  7. "Wrong token guest" warning message has been supressed.
  8. The logic has been corrected. Any attempt to activate
  Db2 monitoring under different profiles will lead to
  authorization error. Only Re-activating is possible.
  9. The logic was changed. By clicking "View Profile" button
  the user will see actual monitoring profile under which Db2
  is currently being monitored.
  The status bar displays "Getting active profile" instead of
  "Getting profile".
  10. Now all "Apply" click changes will be applied for a
  newly created profile.
  
  
  Search Keywords:
  IDAA MAXPARTITIONS WPSIZE EMPTY STATIC SQL DATASHARING
  STARTED_INTERVAL
  DBRM VERSION APPLY BUTTON
  ACTIVATE CAE VIEW PROFILE WRONG TOKEN GUEST
  

Temporary fix

Comments

APAR Information

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

  PH34175

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

  UI74527

Modules/Macros

• CQM#IVSM CQM#PARM CQM#QAPI CQM#QSQL CQM$BUFP CQM$CALL CQM$CHLP
  CQM$DELY CQM$DSCV CQM$SM01 CQM@LIDA CQM@WDB2 CQMBLOB  CQMC0280
  CQMCAE   CQMCPXPT CQMCREOR CQMDDL   CQMEO    CQMIDAA  CQMIDAAL
  CQMIDAD1 CQMIDAM1 CQMIDAM3 CQMIDEL  CQMLDTAS CQMMEACX CQMMEAPX
  CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX CQMXDLST
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI74527

     UP21/03/24 P F103

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.