PQ77650: SELECTION OF SOME HISTORY INTERVALS FROM INTV PANEL CAN YIELD EMPTY PANEL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A Query Monitor V110 (CQM) user can select a single interval of
  CQM data for display from a list presented in the
  DB2/QM Intervals panel (Panel CQM$INTV).
  
  If a row has an "H" in the "AVAIL" column on this panel, it
  indicates the row represents data reloaded via the supplied
  CQM@LDB2 job stream.
  
  Rows loaded to this table by prior execution of job CMQ@LDB2
  should have been removed by a subsequent execution of job
  CQM@LDB2.  However, these old/invalid rows are displayed in
  error from this selection panel.  When one of these invalid
  rows is selected for display, an empty panel is displayed.
  
  The reload code will be changed to properly reflect the
  actual reload status of a time interval.
  

Local fix

• Please add the following to the "Local Fix" space for APAR
  PQ77650:
  .
  Execute the attached SQL on the DB2 subsystem before an
  execution of jobstream CQM@LDB2.  This SQL can be executed
  either interactivly (as through SPUFI or QMF) or as part
  of a batch process.
  .
  IF you have not applied PTF UQ78977, remove the last
  two DELETE statements.
  .
  In the following, the "xxxx" must be replaced with the
  DB2 ssid of the system where job CQM@LDB2 will be executing.
  .
  delete from
  CQMxxxx.intervals_v11
  where data_available = 'H';
    commit;
    delete from CQMxxxxH.summs_v11;
    commit;
    delete from CQMxxxxH.bufferpools_v11;
    commit;
    delete from CQMxxxxH.statements_v11;
    commit;
    delete from CQMxxxxH.dbrms_v11;
    commit;
    delete from CQMxxxxH.threads_v11;
    commit;
    delete from CQMxxxH.intervals_v11;
    commit;
    delete from CQMxxxxH.DET_SC_v11;
    commit;
    delete from CQMxxxxH.SUMM_SC_v11;
    commit;
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: A Query Monitor V110 (CQM) user can     *
  *                      select a single interval of CQM data    *
  *                      for display from a list presented in    *
  *                      the DB2/QM Intervals panel              *
  *                      (Panel CQM$INTV).                       *
  *                                                              *
  *                      If a row has an "H" in the "AVAIL"      *
  *                      column on this panel, it indicates the  *
  *                      row represents data reloaded via the    *
  *                      supplied CQM@LDB2 job stream.           *
  *                                                              *
  *                      Rows loaded to this table by prior      *
  *                      execution of job CMQ@LDB2 should have   *
  *                      been removed by a subsequent execution  *
  *                      of job CQM@LDB2.  However, these        *
  *                      old/invalid rows are displayed in       *
  *                      error from this selection panel.        *
  *                      When one of these invalid rows is       *
  *                      selected for display, an empty panel    *
  *                      is displayed.                           *
  *                                                              *
  *                      The reload code will be changed to      *
  *                      properly reflect the actual reload      *
  *                      status of a time interval.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  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:

  UQ84267

Modules/Macros

•    CQM@LDB2
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R110 PSY UQ84267

     UP04/01/28 P F401

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.