PI93444: ABILITY TO SUPPRESS CAE SERVER RESPONSES FOR CHILDREN THREADS OF ONE PARALLELIZED SQL STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2 can run several parallel children threads to execute one SQL
  statement. If several of these children threads exceed Alerts
  thresholds then one Alert will be generated for each such
  thread. Currently the CAE Server doesn't allow suppressing
  Responses for children threads. As a result, the CAE Server may
  execute several times the same Response (sending mail,
  cancelling threads, submitting JOB and so on) for one actual SQL
  statement. This is not always the expected behavior and this
  enhancement provides the ability to suppress Responses for
  children threads.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Db2 can run several parallel children   *
  *                      threads to execute one SQL statement.   *
  *                      If several of these children threads    *
  *                      exceed Alerts thresholds then one Alert *
  *                      will be generated for each such         *
  *                      thread. Currently the CAE Server        *
  *                      doesn't allow suppressing Responses for *
  *                      children threads. As a result, the CAE  *
  *                      Server may execute several times the    *
  *                      same Response (sending mail,            *
  *                      cancelling threads, submitting JOB and  *
  *                      so on) for one actual SQL statement.    *
  *                      This is not always the expected         *
  *                      behavior and this enhancement provides  *
  *                      the ability to suppress Responses for   *
  *                      children threads.                       *
  ****************************************************************
  * 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:

  UI56279 UI56280

Modules/Macros

•    CQMBLOB  CQMCAEPT CQMCPXPT CQMICRT  CQMJAR
  CQMMGRT  CQMPTFRM CQMUPXCF
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R320 PSY UI56279

     UP18/06/19 P F806

• R330 PSY UI56280

     UP18/06/19 P F806

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.