PK52347: IMPROVE PERFORMANCE IN THE GUI INTERFACE WHEN NAVIGATING INFORMATION DIRECTORIES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• 1. Currently when a leaf node is selected in the tree view
  on the Left Panel of the GUI interface, the information
     is collected from the CAE Server/Agent and displayed in
     the tabular display of the GUI.
  
     If the parent node is then selected (by using the '-'
     option) information may be reprocessed causing unnecessary
     delays.
  
     After this enhancement, "Instance folders" in
     Activity Summary displays will display no data
     (if you select one, the table will simply display an
     informational message). A new folder will be
     added, called "Text Metrics", and selecting this folder
     will display the same data currently displayed for the
     instance folders.
  
  2. This change will also reduce the default browsing history
     length from 24 to 5. When navigating data in the Activity
     Browser, a browsing history is kept that allows users to
     view previously viewed data. By default the history is
     kept for 24 tables of data. This APAR reduces the number
     of tables kept, and hence reduces the overall load on the
     server.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Currently when a leaf node is        *
  *                      selected in the tree view on the Left   *
  *                      Panel of the GUI interface, the         *
  *                      information is collected from the CAE   *
  *                      Server/Agent and displayed in the       *
  *                      tabular display of the GUI.             *
  *                      If the parent node is then selected     *
  *                      (by using the '-' option) information   *
  *                      may be reprocessed causing unnecessary  *
  *                      delays.                                 *
  *                      After this enhancement, "Instance       *
  *                      folders" in Activity Summary displays   *
  *                      will display no data (if you select     *
  *                      one, the table will simply display an   *
  *                      informational message). A new folder    *
  *                      will be added, called "Text Metrics",   *
  *                      and selecting this folder will display  *
  *                      the same data currently displayed for   *
  *                      the instance folders.                   *
  *                      2. This change will also reduce the     *
  *                      default browsing history length from    *
  *                      24 to 5. When navigating data in the    *
  *                      Activity Browser, a browsing history    *
  *                      is kept that allows users to view       *
  *                      previously viewed data. By default the  *
  *                      history is kept for 24 tables of data.  *
  *                      This APAR reduces the number of tables  *
  *                      kept, and hence reduces the overall     *
  *                      load on the server.                     *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

  UK30183 UK30184

Modules/Macros

•    CQMBLOB  CQMCAEPT CQMJAR
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R220 PSY UK30183

     UP07/10/18 P F710

• R221 PSY UK30184

     UP07/10/18 P F710

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.