PK65039: ABEND 0C6-00000006 MAY OCCUR IN THE QM COLLECTOR WHEN MONITORINGDB2 V9 WORKLOADS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND 0C6-00000006 may occur in the QM collector when monitoring
  DB2 V9 workloads.  The ABEND0C6 occurs following an ABEND0C4 in
  CQMMCL91 when an attempt to invoke its FRR (CQMMMFRR) is done.
  CQMMCL91 does a SETFRR passing a 24 bit ADDRESS of the FRR
  instead of a 31 bit ADDRESS.  The ADDRESS of the FRR in this
  case is 9067C000, but because the LLGT load bits 1-31 of the
  four bytes pointed to by R5, 1067C000 is incorrectly passed to
  the SETFRR.  SYSTRACE shows:
  00000000  PGM    010 070C2001 8DF9B15A  00060010 00000000
                                                   32AB4000
  00000000  *RCVY PROG                    940C4000 00000010
  00000000   SSRV   78          811BF072  4000EF50 00000998
  00000000  *RCVY FRR  070C0000 1067C000  940C4000 00000010
  00000000  *PGM   006 070C0000 1067C000  00000006 00000000
  00000000  *RCVY PROG                    940C6000 00000006
  00000000  *RCVY FRR  070C0000 905EA0C8  940C6000 00000006
  ... the 24 bit ADDRESS in the PSW causing the ABEND0C6.
  905EA0C8 points into DB2's CSECT DSNTFEST, 8DF9B15A points
  into CQMMCL91.  This will not occur with R230 of QM.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND 0C6-00000006 may occur in the QM  *
  *                      collector when monitoring DB2 V9        *
  *                      workloads.  The ABEND0C6 occurs         *
  *                      following an ABEND0C4 in CQMMCL91 when  *
  *                      an attempt to invoke its FRR (CQMMMFRR) *
  *                      is done. CQMMCL91 does a SETFRR passing *
  *                      a 24 bit ADDRESS of the FRR instead of  *
  *                      a 31 bit ADDRESS.  The ADDRESS of the   *
  *                      FRR in this case is 9067C000, but       *
  *                      because the LLGT load bits 1-31 of the  *
  *                      four bytes pointed to by R5, 1067C000   *
  *                      is incorrectly passed to the SETFRR.    *
  *                      SYSTRACE shows:                         *
  *                      00000000  PGM    010 070C2001 8DF9B15A  *
  *                        00060010 00000000                     *
  *                                                   32AB4000   *
  *                      00000000  *RCVY PROG                    *
  *                      00000000   SSRV   78          811BF072  *
  *                        4000EF50 00000998                     *
  *                      00000000  *RCVY FRR  070C0000 1067C000  *
  *                        940C4000 00000010                     *
  *                      00000000  *PGM   006 070C0000 1067C000  *
  *                        00000006 00000000                     *
  *                      00000000  *RCVY PROG                    *
  *                        940C6000 00000006                     *
  *                      00000000  *RCVY FRR  070C0000 905EA0C8  *
  *                        940C6000 00000006                     *
  *                      ... the 24 bit ADDRESS in the PSW       *
  *                      causing the ABEND0C6. 905EA0C8 points   *
  *                      into DB2's CSECT DSNTFEST, 8DF9B15A     *
  *                      points into CQMMCL91.                   *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK36406 UK36407

Modules/Macros

•    CQMMAB91 CQMMCL91 CQMMCM91 CQMMCO91 CQMMPR91
  CQMMSQ91
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R220 PSY UK36406

     UP08/05/15 P F805

• R221 PSY UK36407

     UP08/05/15 P F805

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.