PI95524: SQLCODE DUPLICATE ELIMINATION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Overview:
  This feature enables Db2 Query Monitor to detect duplicate
  SQLCODEs at the thread level (looping thread scenario) or the
  Db2 subsystem level.
  .
  Description:
  This feature enables Db2 Query Monitor to detect a loop within
  an application that is running on a thread or a Db2 subsystem.
  When DB2 Query Monitor detects such a loop, it reports the first
  'n' is number of occurrences of the SQLCODE, where 'n' is
  user-specified. Users can also specify a time period, after
  which Db2 Query Monitor restarts duplicate SQLCODE detection
  (and thus allows the detection of SQLCODE loops at different
  time points within an interval).
  .
  NOTE:
  Duplicates SQLCODEs are not added to the totals that are
  reported by Db2 Query Monitor for summary and detail SQLCODEs.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Overview:                               *
  *                      This feature enables Db2 Query Monitor  *
  *                      to detect duplicate SQLCODEs at the     *
  *                      thread level (looping thread scenario)  *
  *                      or the Db2 subsystem level.             *
  *                      Description:                            *
  *                      This feature enables Db2 Query Monitor  *
  *                      to detect a loop within an application  *
  *                      that is running on a thread or a Db2    *
  *                      subsystem. When DB2 Query Monitor       *
  *                      detects such a loop, it reports the     *
  *                      first 'n' is number of occurrences of   *
  *                      the SQLCODE, where 'n' is               *
  *                      user-specified. Users can also specify  *
  *                      a time period, after which Db2 Query    *
  *                      Monitor restarts duplicate SQLCODE      *
  *                      detection (and thus allows the          *
  *                      detection of SQLCODE loops at           *
  *                      different time points within an         *
  *                      interval).                              *
  *                      NOTE:                                   *
  *                      Duplicates SQLCODEs are not added to    *
  *                      the totals that are reported by Db2     *
  *                      Query Monitor for summary and detail    *
  *                      SQLCODEs.                               *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

  UI57275

Modules/Macros

• CQM#INIX CQM#PARM CQMMEACX CQMMEAPX CQMMEARX
  CQMMEASX CQMMEBCX CQMMEBPX CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX
  CQMMECRX CQMMECSX CQMMSQLX
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI57275

     UP18/07/20 P F807

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.