PM62933: EXAGGERATED ELAPSE TIMES IN SUMMARIES, GLOBAL CONTENTION DELAY TOTAL AND NO ASSOCIATED TIMES RESULTING IN INCORRECT DELAYS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Exaggerated elapse times in summaries , Global Contention Delay
  total has value but no associated times resulting in incorrect
  delays on delays panel and in higher summary panels in
  datasharing environments resulting in under weight elapse times.
  Incorrect Global contention delays cause the aggregate of cpu,
  delays and total elapse time to be erroneously large. Notify
  Message Delays captured incorrectly for some SQL running in a
  datasharing environment.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Exaggerated elapse times in summaries,  *
  *                      Global Contention Delay total has       *
  *                      value but no associated times resulting *
  *                      in incorrect delays on delays panel and *
  *                      in higher summary panels in datasharing *
  *                      environments resulting in under weight  *
  *                      elapse times. Incorrect Global          *
  *                      contention delays cause the aggregate   *
  *                      of cpu, delays and total elapse time to *
  *                      be erroneously large. Notify Message    *
  *                      Delays captured incorrectly for some    *
  *                      SQL running in a datasharing            *
  *                      environment.                            *
  ****************************************************************
  * 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:

  PM62932

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

  UK78904

Modules/Macros

•    CQM$DELY CQMMCALX CQMMEMTX CQMMINDX CQMMSACX
  CQMMSAPX CQMMSARX CQMMSASX CQMMSSQX CQMMS8CX CQMMS8PX CQMMS8RX
  CQMMS8SX CQMMS9CX CQMMS9PX CQMMS9RX CQMMS9SX
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R230 PSY UK78904

     UP12/05/31 P F205

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.