PH44547: SQLCODE -208 WHEN ATTEMPTING A SORT IN QUERY MONITOR GUI.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Drilling down from a plan to a database, then attempting to sort
  on database causes -208 SQLCODE.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Query Monitor web UI                *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE -208 When Attempting a SORT in  *
  *                      Query Monitor GUI                       *
  ****************************************************************
  Sorting on Database in web UI fails due to invalid SQL and
  affects all sorting on any column in the Summaries display
  

Problem conclusion

• Cleared residual data following internal sort operation
  

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:

Modules/Macros

• CQMBLOB  CQMCFPAX CQMCPXPT CQMJAR   CQMMEACX CQMMEAPX CQMMEARX
  CQMMEASX CQMMEBCX CQMMEBPX CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX
  CQMMECRX CQMMECSX CQMMFREX CQMSSV   CQMUPXPT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI79945

     UP22/03/31 P F203

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.