A fix is available
APAR status
Closed as program error.
Error description
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. Eliminate 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. Internal CQM abend SOC4-003A in program:CQMMEXXX+046AC for some commit statements caused missing/incorrect information for this commit in the interface. Also can result in Orphaned Exception Blocks causing CQM12* series messages. 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.
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 number
PI97589
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
2018-05-03
Closed date
2020-04-01
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:
PH23890 UI68764
Modules/Macros
CQM#INTX CQM#STMT CQM$ACTA CQM$ACTV CQM$BUFP CQM$DB2C CQM$DELY CQM$DSCV CQM$EXC1 CQM$EXCS CQM$MAIT CQM$QRPT CQM$SLBS CQM$SLIP CQM$SLMD CQM$SM01 CQM$SQ85 CQM$SQ87 CQM$SQ89 CQM$SQ8C CQM$SQ8E CQM$SQ8S CQM$SQC2 CQM$SQC3 CQM$SQC4 CQM$SQC5 CQM$SQC9 CQM$SQCF CQM$SQCL CQM$SQCM CQM$SQCS CQM$SU8K CQM$SU8P CQM$SU8Q CQM$SUMB CQM$SUMK CQM$SUML CQM$SUMP CQM$SUO8 CQM$SUSP CQM$XQVE CQM00 CQM002E CQM005E CQM01 CQM010E CQM012I CQM192E CQM253E CQM255E CQM310E CQM312E CQM314E CQM317E CQM320E CQM324E CQM326E CQM328E CQM911I CQMBLOB CQMC0176 CQMC0178 CQMC0180 CQMC0182 CQMC0277 CQMHACT1 CQMHACTA CQMHDDB2 CQMHDSCV CQMHEXC1 CQMHHNL0 CQMHMST1 CQMHSQC2 CQMHSQC3 CQMHSQCC CQMHSQCE CQMHSQCF CQMHSQCT CQMHSUJ1 CQMHSUL1 CQMHSUMB CQMHSUMC CQMHSUMJ CQMHSUMK CQMHSUSP CQMJAR CQMMACTX CQMMEXCX CQMMEXXX CQMSWD CQMUPXPT
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R330 PSY UI68764
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.
[{"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:
14 December 2020