PH03715: INCORRECT CALCULATION OF SQLCODE OCCURRENCES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE occurrences can be calculated incorrectly for the
  following scenarios.
  ..
  1. SQLCODE occurrences for one user are counted incorrectly.
  2. SQLCODE occurrences for many users are counted incorrectly.
  3. DB2_SQLCODE_DUPLICATES and DB2_SQLCODE_DUPLICATES_TIME are
    processed incorrectly.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Db2 Query Monitor z/OS                   *
  *                 users of component                           *
  *                 - CQM ISPF                                   *
  *                 - SQL codes                                  *
  *                 - Summaries                                  *
  *                 - Data Sharing                               *
  *                 - CAE server                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: VSAM dataset quickly flooded with the   *
  *                      negative SQLCODE detail records by the  *
  *                      misbehaving application.                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Former implementation did not allow efficiently filtering out
  duplicate occurrences or limiting a misbehaving application's
  ability to flood VSAM datasets for SQLCODEs.
  

Problem conclusion

• Implementation changes the logic to allow only the first
  occurrence of every distinct failed SQL statement to be recorded
  to the VSAM for the specified amount of time. All subsequent
  occurrences of the same failing SQL will be ignored until the
  timeout expiration.
  
  
  Search Keywords:
  THREAD_SQLCODE_DUPLICATES DB2_SQLCODE_DUPLICATES
  

Temporary fix

Comments

• ×**** PE19/10/22 FIX IN ERROR. SEE APAR PH18400  FOR DESCRIPTION
  

APAR Information

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

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

  UI65330

Modules/Macros

• CQM$SQCI 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 UI65330

     UP19/09/18 P F909

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.