PI56652: ENHANCEMENT TO REFESH DATA BETWEEN DISPLAYS IN ISPF FOR DB2 QUERY MONITOR

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• In DB2 Query Monitor’ISPF interface, data that is displayed in
  tables is not refreshed after a user goes into a detail display
  and returns to table displays using PF3.
  When using this option, a PF3 from the detail display back to
  the table display, does not cause data to be refreshed from the
  DB2 Data Access Common Collector.
  This feature improves ease of use for the ISPF interface by
  reducing the time required to navigate to a prior display in a
  drill down path.
  This feature is present by default, there is no option to
  disable it. The feature is present when the user presses PF3
  from D-Delays, B-BP stats, Q-Misc Stats, L-Locks, V-view SQL.
  Benefit to Customer
  Improvements to the behavior of PF3 now enables customers to
  navigate from table displays to detail displays and back
  without the PF3 back to the table requiring a refresh from
  the IBM DB2 Data Access Common Collector. This feature
  provides improved ease of use for the customer.
  Use Case
  In Operational Summaries, a customer navigates to a detail
  display and then uses PF3 to retrace their steps back up to
  the table display. When the customer goes back to the table
  display, it is not refreshed and displays table information
  more quickly than if it went back to the IBM DB2 Data Access
  Common Collector to get the table data.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor z/OS.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Query Monitor tables is not      *
  *                      refreshed after a user goes into a      *
  *                      detail display and returns to table     *
  *                      displays using PF3. When using this     *
  *                      option, a PF3 from the detail display   *
  *                      back to the table display, does not     *
  *                      cause data to be refreshed from the     *
  *                      DB2 Data Access Common Collector.       *
  *                      This feature improves ease of use for   *
  *                      the ISPF interface by reducing the      *
  *                      time required to navigate to a prior    *
  *                      display in a drill down path. This      *
  *                      feature is present by default, there    *
  *                      is no option to disable it. The         *
  *                      feature is present when the user        *
  *                      presses PF3 from D-Delays, B-BP stats,  *
  *                      Q-Misc Stats, L-Locks, V-view SQL.      *
  *                      Benefit to Customer Improvements        *
  *                      to the behavior of PF3 now enables      *
  *                      customers to navigate from table        *
  *                      displays to detail displays and back    *
  *                      without the PF3 back to the table       *
  *                      requiring a refresh from the IBM DB2    *
  *                      Data Access Common Collector. This      *
  *                      feature provides improved ease of use   *
  *                      for the customer. Use Case In           *
  *                      Operational Summaries, a customer       *
  *                      navigates to a detail display and then  *
  *                      uses PF3 to rettrace their steps back   *
  *                      up to the table display.                *
  *                      When the customer goes back to the      *
  *                      table display, it is not refreshed and  *
  *                      displays table information more         *
  *                      quickly than if it went back to the     *
  *                      IBM DB2 Data Access Common Collector    *
  *                      to get the table data.                  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• SPPLY 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:

  UI36504

Modules/Macros

•    CQM$ACTV CQM$DB2C CQM$SM01 CQM$SQCI CQM$SQCM
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R320 PSY UI36504

     UP16/03/29 P F603

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.