PK46442: ABEND S878 AND/OR ABEND S0C3 MAY OCCUR WHEN MONITORING WORKLOADS CONTAINING DSNTIAUL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When monitoring workloads containing DSNTIAUL, ABEND878 and
  ABEND0C3 can occur in the Query Monitor collector.  This can
  occur when the DSNTIAUL SYSIN contains multiple SQL statements.
  
  S0C3 occurs in CQMMSTXT+X'836'
  
  OTHER KEYWORDS: ABEND0C3 ABENDS0C3 S0C3 0C3 ABENDS878 S878 878
  ABEND878
  

Local fix

• * Insure there is only one SQL statement per DSNTIAUL step or
  
  * Turn off monitoring for DSNTIAUL workloads by creating
    an EXCLUDE line in the QM monitoring profile as described
    in "Chapter 11. Working with profiles" of the QM Users Guide
    by specifying the following:
    - INCLUDE/EXCLUDE            'E'
    - Disable Summary Reporting  'Y'
    - Gather Host Variables      'Y'
    - Program Name               'DSNTIAUL'
  
    *** REFRESH the monitoring profile to make this takes affect.
    *** Add the exclude near the top of your profiles to make it
        as efficient as possible.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IBM DB2 Query Monitor.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND S878 AND/OR ABEND S0C3 MAY OCCUR  *
  *                      WHEN MONITORING WORKLOADS CONTAINING    *
  *                      DSNTIAUL                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code changes have been made to address these issues.
  

Problem conclusion

• Apply 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:

  UK26219 UK26220

Modules/Macros

•    CQMTTEXT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R220 PSY UK26219

     UP07/06/22 P F706

• R221 PSY UK26220

     UP07/06/22 P F706

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.