PH60433: MINOR DEFECT FIXES AND SERVICEABILITY IMPROVEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Getpages in Object panel in current activity are not updated for
  threads initiated inside DB2 (child threads or for threads
  issued by NSP).
  Serialize stopping of master across QM address space cleanup
  processes.
  CQM@NRPB bind job altered package name to CQMHPO34.
  ACQMSAMP(CQMLDTAS) reference changed to Accelerator Loader 2.1
  (5639-OLE).
  v13 values are uploaded to DB2_VERSION/DB2_VERSION_LONG columns
  of the Performance History Tables.
  Enhance Message CQM1033E/ADHQ1033E to include master levels for
  debugging. .
  UPDATE SCQMDENU(CQMDDL), CQM_INTERVALS table has UNUSED_0001
  column instead of TOTAL_GETPAGES.
  Last line in a monitoring profile with 1+ lines cannot be
  deleted and saved.
  Removed Deprecated Samplib members CQM@CNVT CQMCSMGT CQMMIDAA.
  Increase length of DSN names parm in CQM customization.
  Eliminate the requirement to connect to Db2 before installing
  monitoring agent.
  Possible invalid data in Db2 version related Control File
  fields.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor               *
  ****************************************************************
  1. Getpages in Object panel in current activity are not updated
  for threads initiated inside DB2 (child threads or for threads
  issued by NSP).
  2. Eliminate the requirement to connect to Db2 before
  installing monitoring agent.
  3. Serialize stopping of master across QM address space
  cleanup processes.
  4. Sample JCL CQM@NRPB bind job altered package name to
  CQMHPO34.
  5. Sample JCL CQMLDTAS reference changed to Accelerator
  Loader 2.1 (5639-OLE).
  6. v13 values are now uploaded to DB2_VERSION/DB2_VERSION_LONG
  columns of the Performance History Tables.
  7. Possible invalid data in Db2 version related Control File
  fields
  8. Enhance Message CQM1033E/ADHQ1033E to include master levels
  for debugging.
  9. TCz script CQMDDL, CQM_INTERVALS table has UNUSED_0001
  column instead of TOTAL_GETPAGES.
  10. Last line in a monitoring profile with 1+ lines cannot be
  deleted and saved.
  11. Increase length of DSN names parm in CQM customization.
  12. Removed deprecated Samplib members CQM@CNVT CQMCSMGT
  CQMMIDAA.
  

Problem conclusion

• 1. The code is updated to prevent described problems and
  enhance the installation experience
  2. Obsolete sample members are removed
  3. New sample member is added to alter UNUSED_0001 column in
  CQM_INTERVALS table
  

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:

  UI96961

Modules/Macros

• CQM#INIX CQM#PCIX CQM#SDIR CQM#SSMN CQM$$PRM CQM$CPRF CQM$SQCI
  CQM@CNVT CQM@NRPB CQM@WDB2 CQMALT02 CQMC2LST CQMCOMM  CQMCSMGT
  CQMDDL   CQMLDTAS CQMMIDAA CQMMINDX CQMMSBCX CQMMSBPX CQMMSBRX
  CQMMSBSX CQMMSCCX CQMMSCPX CQMMSCRX CQMMSCSX CQMMSDCX CQMMSDPX
  CQMMSDRX CQMMSDSX CQMZEXCP CQMZEXCS
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R340 PSY UI96961

     UP24/05/23 P F405

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.