PH23890: CQM 3.3 ROLLUP APAR #5

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CQM 3.3 Rollup APAR #5 Containing Cumulative ISPF changes
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: USERS AFFECTED:                              *
  *                 IBM Db2 Query Monitor for z/OS 3.3.0         *
  *                 users of components:                         *
  *                 - Data Sharing                               *
  *                 - ISPF Client                                *
  *                 - CAE server                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: CQM 3.3 Rollup APAR #5 includes 17      *
  *                      internal bugs.                          *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Order of records was not preserved after pressing Enter on
  Current Activity panel in data sharing view.
  2. In Data sharing mode after pressing Enter the data on panels
  corresponding to D-Delay/L-Locks/Q-Misc/B-Buff became the
  summary of the data from all data sharing members.
  3. Abend S0C4-0000003B happened on Exceptions panel in ISPF
  after restarting Query Monitor started task.
  4. When parent thread had only SQL call PREPARE, thread
  unexpectedly showed N in PARALLEL column in Current Activity and
  Exceptions panels.
  5. Cursor position was not saved in Exceptions in Data sharing
  view.
  6. H letter did not disappear on Call Level Statistics panel if
  Host Vars were not collected and CQM103I was displayed.
  7. CQM$SU8K and CQM$OBJ8 panels had different representation of
  HitRatio column.
  8. CQMUDFHV User Defined Function, which was used in CAE to
  display Archive data, did not recognize host variable type
  VARGRAPHIC.
  9. There was a confusion, what "DB2 QM Subsystem ID" and "DB2
  QM Subsystem" meant - Db2 ssid or CQM subsystem.
  10. Information cut in column REQ SITE on 'Current Activity'
  and 'Exceptions' panels for SQLs with 3-part names.
  11. "Description" column in panel Calls does not have help.
  12. Hidden abend SOC4-003A in program:CQMMEXXX+046AC for some
  commit statements caused missing/incorrect information for this
  commit in the interface.
  13. Some threads may not be displayed or the values for them
  may be wrong in Current Activity after installing DB2 V12 FL506
  level.
  14. Call type panel displayed as Unknown SQL type: CREATE
  TRUSTED CONTEXT, ALTER TRUSTED CONTEXT, DROP TRUSTED CONTEXT.
  15. Length of LOB host variables became negative if size of
  object was more than 32Kb.
  16. In some cases CAE Web Browser showed DECLARE H VARIABLE as
  detail SQL text for COMMIT short SQL text.
  This issue can happen if a customer collects data with calls
  optkey turned off. In this case SQL text can be showed
  incorrectly on SQL Text tab and in Description column for CALL
  drill-down.
  17. Help for "SP Application Elapsed Time" was not clear in
  ISPF.
  18. On the web interface of Db2 Query Monitor v3.3, users can
  sort the columns, but it works incorrectly for Archive
  Connection source on Exceptions drill-down of Summaries
  perspective.
  

Problem conclusion

• Logic was updated and behavior with the fix is the next:
  1. Order of records is kept in the same way as in single mode.
  2. In data sharing view the data on panels corresponding to
  D-Delay/L-Locks/Q-Misc/B-Buff is not changed after pressing
  Enter.
  3. Abend S0C4-0000003B on Exceptions panel is fixed.
  4. When parent thread has only SQL call PREPARE, thread shows
  correctly P(parent) in PARALLEL column in Current Activity and
  Exceptions panels.
  5. Cursor position is kept to the last called line in Exceptions
   in Data sharing view.
  6. Pressing Enter causes letter 'H' to disappear in CMD line
  before displaying message CQM103I.
  7. Both CQM$SU8K and CQM$OBJ8 panels have number with '%' sign
  at the end and have 9 characters' length. "Hit Ratio" is written
   as two words.
  8. CQMUDFHV User Defined Function, which is used in CAE to
  display Archive data, recognizes host variable type VARGRAPHIC.
  9. "DB2 QM Subsystem ID" is renamed to "Target" on panel
  CQM$MAIN, "DB2 QM Subsystem" is renamed to "QM Subsystem" on
  other ISPF panels and messages.
  10. Column REQ SITE on 'Current Activity' and 'Exceptions'
  panels display full information for SQLs with 3-part names.
  11. The help text for "Description" column in panel Calls is
  created.
  12. Some kinds of commits can not have long REQ SITE data, so
  only short 16 bytes information is displayed for them in column
  REQ SITE on 'Current Activity' and 'Exceptions' panels.
  13. The logic was updated to support the changes of DB2 V12
  FL506 level.
  14. CREATE TRUSTED CONTEXT, ALTER TRUSTED CONTEXT, DROP TRUSTED
  CONTEXT are recognized correctly.
  15. ISPF and CAE Web Client show correct host variables values'
  length which can be up to 65525.
  16. CAE logic was changed to find detail SQL text correctly.
  17. Help for
  'SP Application Elapsed Time" was updated in ISPF.
  18. Sorting of 'Delay' and 'Delay Count' columns in Exceptions
  perspective was corrected for Archive Connection source.
  
  
  Search Keywords:
  CQM$EXSA CQM$ACTA REAL HITRATIO S0C4-3B ABEND TRUSTED CONTEXT
  HOSTVAR LOB HOSTVAR DELAY DELAY COUNT ARCHIVE CONNECTION
  COMMIT STATEMENT DESCRIPTION COLUMN UNKNOWN TYPE
  

Temporary fix

Comments

APAR Information

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

  PI97589

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

  UI68765

Modules/Macros

• CQM#BCMX CQM#SSMN CQM$ACTS CQM$CALL CQM$CHLP CQM$DDB2 CQM$EXC2
  CQM$EXCA CQM$EXSA CQM$HSTV CQM$LOCK CQM$MAIN CQM$OBJS CQM$SLBT
  CQM$SLM1 CQM$SLMN CQM$SLPV CQM$SM02 CQM$SMKY CQM$SQ82 CQM$SQ83
  CQM$SQ84 CQM$SQ86 CQM$SQ88 CQM$SQ8D CQM$SQ8T CQM$SQC6 CQM$SQC7
  CQM$SQC8 CQM$SQCC CQM$SQCD CQM$SQCE CQM$SQCP CQM$SQCT CQM$SU8J
  CQM$SUCT CQM$SUMC CQM$SUMJ CQM$SUMQ CQM$SUMT CQM$SUOJ CQM$YLOG
  CQM07    CQM078E  CQM254E  CQM257E  CQM311E  CQM313E  CQM315E
  CQM316E  CQM318E  CQM321E  CQM325E  CQM327E  CQM329E  CQM@WDB2
  CQMC0166 CQMC0177 CQMC0179 CQMC0181 CQMCAEPT CQMCPXPT CQMFSU8P
  CQMHDB21 CQMHDB2C CQMHDDB1 CQMHEXCA CQMHMAI9 CQMHMAIN CQMHMST3
  CQMHNL0  CQMHPOFF CQMHSMKY CQMHSQ02 CQMHSQCD CQMHSQCL CQMHSQCM
  CQMHSQCP CQMHSQCS CQMHSTXT CQMHSUCT CQMHSUM3 CQMHSUM6 CQMHSUML
  CQMHSUMP CQMHSUMQ CQMHSUMT CQMHTEMP CQMPTFRM CQMSSV   CQMUDFHV
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI68765

     UP20/04/03 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.