PI52777: INCORRECT SUMMARY DATA DISPLAYED IN ISPF SQL CODE SUMMARY PANEL WHEN AN INTERVAL CONTAINING NO DATA IS SELECTED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Incorrect summary data can be displayed on the ISPF SQL Code
  Summary panel (CQM$SQCM, option 2 from CQM$MAIN) when multiple
  intervals are selected and any of the selected intervals are
  empty. When grouped by SQLCode (S), the intervals are still
  summarized properly, but drill-down data is incorrect. When
  grouped by anything other than SQLCode: Plan (P), DBRM/Package
  (D), or A (Authid), the summary shows only summary data up to
  the empty interval. In cases where the first interval selected
  is an empty interval, no summary data is displayed.
  

Local fix

• Ensure that no empty intervals are selected.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor z/OS.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect summary data can be displayed *
  *                      on the ISPF SQL Code Summary panel      *
  *                      (CQM$SQCM, option 2 from CQM$MAIN) when *
  *                      multiple intervals are selected and any *
  *                      of the selected intervals are empty.    *
  *                      When grouped by SQLCode (S), the        *
  *                      intervals are still summarized          *
  *                      properly, but drill-down data is        *
  *                      incorrect. When grouped by anything     *
  *                      other than SQLCode: Plan (P),           *
  *                      DBRM/Package (D), or A (Authid), the    *
  *                      summary shows only summary data up to   *
  *                      the empty interval. In cases where the  *
  *                      first interval selected is an empty     *
  *                      interval, no summary data is displayed. *
  ****************************************************************
  * 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:

  UI34386

Modules/Macros

• CQM$SQCI
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R320 PSY UI34386

     UP16/01/15 P F601

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.