PM59627: SQLCODE199 WHEN CQM TRIES TO EXTRACT INTERVAL TIMES WHEN SWITCHING TO AN ARCHIVE CONNECTION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If you have an archive connection that has the same
  system/cqm-subsystem name as a QM Subsystem "Target", then you
  can receive a sqlcode -199 error if you switch to the archive
  connection.
  *
  This error will normally occur if you have previously had the
  analagous QM Subsystem "Target" selected in the Activity Browser
  (even if that QM Subsystem was the default selection when you
  opened the Activity Browser page).
  

Local fix

• Workaround
  
  1.select the desired offload connection
  2.select desired first request (e.g. summary by plan)
  3.press the Go button
  4.after the error, reload the whole page in the web browser.
  
  NOTES:
  1.If you bookmark an "Archive" result, then you can avoid the
    need to do the preceding steps if you go directly to
    that bookmark without having loaded the Activity Browser
    page previously.
  2.If that error recurs, pressing "Go" and reloading the whole
    page should remove the error and allow you to proceed.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: If you have an archive connection that  *
  *                      has the same system/cqm-subsystem name  *
  *                      as a QM Subsystem "Target", then you    *
  *                      can receive a sqlcode -199 error if you *
  *                      switch to the archive connection. This  *
  *                      error will normally occur if you have   *
  *                      previously had the analagous QM         *
  *                      Subsystem "Target" selected in the      *
  *                      Activity Browser (even if that QM       *
  *                      Subsystem was the default selection     *
  *                      when you opened the Activity Browser    *
  *                      page).                                  *
  ****************************************************************
  * 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:

  UK78119

Modules/Macros

•    CQMBLOB  CQMCAEPT CQMCPXPT CQMJAR
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R310 PSY UK78119

     UP12/04/26 P F204

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.