PI19811: OVERLAY IN EB ( EXECUTION BLOCK ) IN DB2 ADDRESS SPACE MAY CAUSE ABEND04E RC00E50076 ABEND04E RC0E501A1 IN DB2

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Overlay in EB - Execution control block in DB2 address space
  by Query Monitor may cause DB2 to be in an inconsistent state
  and abend with Abend04e RCRC00E50076 , ABEND04E RC00E501A1.
  *
  Additional symptoms
  High CPU, CQM1205E
  

Local fix

• The following steps will help to minimize the exposure
  to this problem:
  
  1. Stop all products around the same time:  CQM, CQR and S-TAP.
  
  2. Stop associated CQM/S-TAP master address space
     (CQMMSTR/CQRMSTR/ADHMSTR)
  Stopping CQMMSTR:
  
  The recommended procedure for stopping the CQMMSTR (after all
  instances of Query Monitor and S-TAP running on the
  MVS image have been stopped), is to start CQM with
  PARM='SM,MSTOP'
  (refer to SCQMSAMP member CQMMSTR for an example of the
  "SM,MSTOP" parameters).
  Stopping ADHMSTR:
  The recommended procedure for stopping the ADHMSTR
  (after all instances of Query Monitor and S-TAP running
  on the MVS image have been stopped), is to start ADH with
  PARM='AX,MSTOP'
  (refer to SADHSAMP member ADHMSTR for an example of the
  "AX,MSTOP" parameters).
  
   Stopping CQRMSTR:
  
   The recommended procedure for stopping the CQRMSTR (after all
   instances of Query Monitor, Workload Replay and S-TAP running
   on the MVS image have been stopped), is to start CQR with
   PARM='AX,MSTOP'
   (refer to SCQRSAMP member CQRMSTR for an example of the
  "AX,MSTOP" parameters).
  
  3. Restart CQM during low SQL activity.
  
  4. After CQM startup has been fully completed, then restart CQR
      and S-TAP.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Overlay in EB - Execution control block *
  *                      in DB2 address space by Query Monitor   *
  *                      may cause DB2 to be in an inconsistent  *
  *                      state and abend with Abend04e           *
  *                      RCRC00E50076 , ABEND04E RC00E501A1.     *
  *                      Additional symptoms                     *
  *                      High CPU, CQM1205E                      *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UI19618 UI19619

Modules/Macros

•    CQM#REST CQMMALOX CQMMALRX CQMMCALX CQMMCMOX
  CQMMEMTX CQMMEXXX CQMMFRX1 CQMMHSX9 CQMMINDX CQMOREDX
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R310 PSY UI19618

     UP14/07/18 P F407 Ž

• R320 PSY UI19619

     UP14/07/18 P F407 Ž

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.