A fix is available
APAR status
Closed as program error.
Error description
NOVEMBER 2020 MAINTENANCE UPDATES
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: IBM Db2 Query Monitor for z/OS * * users of component * * - Documentation - Public use * * - CQM Data Collector * * - CAE Agent * * - CAE Server * * - SQL Codes * * - Summaries * * - ISPF Client * * - Profiles * * - Host Variables * * - SQL Text * **************************************************************** * PROBLEM DESCRIPTION: 1. Summaries metrics stop recording to * * METRD dataset when OBJSD dataset is * * overflowed. * * * * 2. Abend A03000 hex occurred during * * processing command 'CQM$MAIN' when user * * exits startup CLIST if user does not * * have access to Query Monitor plan and * * tries to look at SQL texts from SQL * * code panel. * * * * 3. ABEND S106-14 in CQM$SM01 or empty * * screen when user tries to sort large * * amounts of SQL texts and TSO userid * * storage is full (user region is * * small). * * * * 4. Message CQM149E message does not * * contain the name of the data set if * * the interval was created incorrectly * * or has already been removed during * * interval switch as the oldest one. * * * * 5. ABEND S378-00000014 drill down to * * D-DBRMs/Packages in SQL Code panel. * * * * 6. S0C4 in FEC@SCR1 after collector * * restart. * * * * 7. The following problems happen in * * CQM ISPF interface when dirty getmain * * is enabled: * * 7.1.Garbage symbols in SQLCODE * * Details, HVs and Profiles. * * 7.2.Huge values for Anomaly statistics. * * 7.3.Full dynamic SQL texts is not * * available if its length is longer than * * 80 characters and message CQM196I is * * issued. * * * * 8. Garbage in cursor field in CQM$QLC8 * * panel when it is called with * * 'no grouping'. * * * * 9. Panel 'CQM$PR8U' shows error when * * value from field 'Db2' and attempt to * * save. * * * * 10. defaultKeystore.jks keystore for * * USS server is not backed up during * * import. * * * * 11. Password is not requested by CAE * * Server on Monitoring Agents * * panel for LPAR having another * * password. * * * * 12. User credentials are not requested * * when user logged in under built-in * * administrator and navigates to * * "Activity Browser". * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** 1. METRD and OBJSD are processed by CQMMMETX and lacking of space in the second one leads to stopping writing to the first one. The symptoms are CQM2605E and CQM2610E messages for objects but data loss happens for objects and metrics. 2. Connection to Db2 was not terminated correctly if user does not have access to Query Monitor plan which causes ISPF Subtask Abend A03000. 3. Abend S106 in this case occurs due to insufficient memory and the absence of a handler for this error situation. 4. The problem occurs when the interval data sets were created/filled manually (outside Query Monitor via, for example, IDCAMS utility) or if the oldest interval was selected and was on the screen during switch interval process. 5. Incorrect length caused the overlay of CQM internal structures if D-DBRMs/Packages was the last drill down. It is shown as empty screen and ABEND S378-14 while returning from that drill down. 6. Attempt to reach '6. Work with Monitoring Agents' immediately after restart may lead to S0C4 in FEC@SCR1 module. 7. Problems occur due to unexpected values in Query Monitor memory acquired via getmain. 8. Value for cursor was converted incorrectly when called with 'no grouping'. 9. Panel 'CQM$PR8U' tried to show CQM124E message that field 'Db2' should be filled but used incorrect address of area. 10. While running 'cqmimportcerts' script in USS (CQMICERT job) to import the newly created certificates or already existed certificates, Keystore defaultKeystore.jks is not backed up like on Windows. 11. CAE Server does not prompt to do authentication against non-authenticated system on Monitoring Agents panel allowing non-authenticated user to view any information about monitoring status on that system. 12. CAE Server does not prompt to do authentication with real TSO credentials which blocks the user to work with "Activity Browser" at all.
Problem conclusion
1. CQM2605E and CQM2610E messages mean that there is no more space to enlarge dataset. The reason may be that the primary or secondary allocations for OBJSD file are too small and all 123 extents are used, or that there is no more space on the volume. With the fix Query Monitor supports multi-volume datasets for interval data and new parameter MAX_VOLUME_COUNT(n) was added to CQMPARMS to set the number of such volumes. 2. Logic was updated to terminate connection to Db2 correctly. 3. The Abend S106 handler was added to the recovery routine to avoid abend. Still, due to the lack of memory not all data will be displayed. To display all data the increase the size of the user TSO region is needed. 4. New message CQM185E will be displayed if interval becomes unavailable after switching. 5. Length was corrected. 6. Logic was changed to display correct message CQM005E instead of abend. 7. Logic was updated to clear memory before using it. 8. Conversion of cursor value was corrected. 9. Correct address of the area is passed to issue CQM124E message. 10. Added a step into the 'cqmimportcerts' script to back up the USS Keystore before starting to import the certificates. 11. Added authentication step prior to viewing any information on Monitoring Agents panel for that system. 12. Built-in administrator is not a correct user to view information on "Activity Browser" web page. Authentication step was added prior to loading any information on "Activity Browser" web page to avoid unexpected behavior with "empty" web page. Search Keywords: ABEND S378 D-DBRMS PACKAGES SQL CODES INCORROUT SQLCODE DETAILS HOST VARIABLES PROFILES CQM196I ANOMALY ABEND A03000 CQM$MAIN Abend S106 CQM185E MULTI-VOLUME MAX_VOLUME_COUNT INCORROUT CQM$QLC8 CQM$PR8U CQM124E
Temporary fix
Comments
APAR Information
APAR number
PH29001
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
2020-08-31
Closed date
2021-02-18
Last modified date
2021-03-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
PH34535 UI74033
Modules/Macros
CQM#ARCX CQM#CIDC CQM#CTLF CQM#FDSN CQM#INIX CQM#INTX CQM#IVCV CQM#IVSM CQM#LOAX CQM#PARM CQM#QAPI CQM#QAPX CQM#QSQL CQM#SDAQ CQM#SWTX CQM#UINX CQM$ACTV CQM$BUFP CQM$CALL CQM$CNCL CQM$CPRF CQM$DB2C CQM$DDB2 CQM$DELY CQM$DSCV CQM$ERRP CQM$FILT CQM$FLT2 CQM$FLTC CQM$HSTV CQM$INTD CQM$INTV CQM$LINK CQM$LOCK CQM$MAIN CQM$OBJS CQM$PRFS CQM$PROF CQM$QLCA CQM$QRPT CQM$RANG CQM$SM01 CQM$SMKY CQM$SQC2 CQM$SQC3 CQM$SQCD CQM$SQCE CQM$SQCI CQM$SQCL CQM$SQCM CQM$SQCP CQM$SQCS CQM$SQLT CQM$TEXT CQM$YLOG CQM$YXLG CQM18 CQM185E CQM@WDB2 CQMBLOB CQMCAEPT CQMCPXPT CQMDSECT CQMICRT CQMJAR CQMMEMTX CQMMEXXX CQMMQAPX CQMSSV CQMTTXTX CQMUPXPT
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R330 PSY UI74033
UP21/02/23 P F102
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.3.0"}]
Document Information
Modified date:
31 March 2021