PH28474: DECEMBER 2020 MAINTENANCE UPDATES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• OCTOBER 2020 MAINTENANCE UPDATES
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor for z/OS      *
  *                 users of component:                          *
  *                   - CQM Data Collector                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. ABEND0C4-003A in CQMMEXXX+X'05106',  *
  *                      ABEND0C4-3B in CQMMEMTX+X'9E50',        *
  *                      ABEND0C4-3A in CQMMEMTX+X'9E42' if      *
  *                      OPTKEYS(SP) is specified in CQMPARMS.   *
  *                                                              *
  *                      2. ABEND0C4-3B in CQMMEXXX+X'4FF4'      *
  *                      during processing of a COMMIT call.     *
  *                                                              *
  *                      3. ABEND0C4-04 CQMMEXXX+X'00770' due    *
  *                      to hitting max allocations.             *
  *                                                              *
  *                      4. Abend0C1 in CQMMINDB if there are    *
  *                      many SQL texts.                         *
  *                                                              *
  *                      5. Abend0C4-0004 in CQMMECCX+X'01664'   *
  *                      if Anomaly Detection is used.           *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Attempt to extract Stored Procedure name for the threads
  which do not work in Stored Procedure caused abends in CQMMEXXX
  and CQMMEMTX.
  
  2. A COMMIT call does not have Req Site name, but logic tried
  to extract it and caused abend in CQMMEXXX.
  
  3. When MAXALLOCATION limit is hit, the attempt to drive ISM
  abend exit was done but finished with abend in CQCMALOX due to
  lack of memory and no CQM internal structure was built. But a
  routine tried to work with that internal structure and caused
  an abend in CQMMEXXX.
  
  4. Under a heavy workload and if there are a lot of SQL texts,
  Abend0C1 in CQMMINDB may happen due to overlay of CQM
  internal structure.
  
  5. There was no check if data was received when Anomaly
  Detection was used. It caused an abend in CQMMECCX.
  

Problem conclusion

• 1. Logic was corrected to search for Stored Procedure name only
  for the threads which call Stored Procedure.
  
  2. Logic was corrected for a COMMIT call.
  
  3. Logic was changed to ensure that the internal structure is
  allocated.
  
  4. Programs were updated to avoid overlay.
  
  5. The check for data existence was corrected.
  
  Search Keywords:
  ABENDS S0C4 CQMMEXXX+X'05106' CQMMEMTX+X'9E50'
  CQMMEMTX+X'9E42' OPTKEYS(SP) CQMMEXXX+X'4FF4'
  COMMIT CQMMEXXX+X'00770' MAXALLOCATION CQMMECCX+X'01664'
  ANOMALY DETECTION ABEND0C1 CQMMINDB
  

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:

  UI72938

Modules/Macros

• CQMMCALX CQMMEACX CQMMEAPX CQMMEARX CQMMEASX CQMMEBCX CQMMEBPX
  CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX CQMMECRX CQMMECSX CQMMEXXX
  CQMMFREX CQMMFRX1 CQMMINDX CQMMSACX CQMMSAPX CQMMSARX CQMMSASX
  CQMMSBCX CQMMSBPX CQMMSBRX CQMMSBSX CQMMSCCX CQMMSCPX CQMMSCRX
  CQMMSCSX
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI72938

     UP20/12/09 P F012

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.