PI62800: SORTING BY "DIMENSIONAL" COLUMN (E.G., AUTHID) CAN RESULT IN A SQLCODE=-122 WHEN USING ARCHIVE CONNECTION IN ACTIVITY BROWSER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This error can occur when selecting the following drilldown:
  # create Archive Connection in Activity Browser and execute any
  drilldown in Summaries  (for example, Plan)
  # sort by dimensional column (in our example, Plan)
  # select any other drilldown
  Progress Indicator in Activity Browser reports error:
  ...
  com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
  SQLCODE=-122, SQLSTATE=42803, SQLERRMC=null, DRIVER=3.61.75
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Query Monitor z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: This error can occur when selecting     *
  *                      the following drilldown:                *
  *                      # create Archive Connection in          *
  *                      Activity Browser and execute any        *
  *                      drilldown in Summaries  (for example,   *
  *                      Plan)                                   *
  *                      # sort by dimensional column (in our    *
  *                      example, Plan)                          *
  *                      # select any other drilldown            *
  *                      Progress Indicator in Activity Browser  *
  *                      reports error:                          *
  *                      com.ibm.db2.jcc.am                      *
  *                      .SqlSyntaxErrorException: DB2 SQL       *
  *                      Error: SQLCODE=-122, SQLSTATE=42803,    *
  *                      SQLERRMC=null, DRIVER=3.61.75           *
  ****************************************************************
  * 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:

  UI40159

Modules/Macros

• CQMBLOB  CQMCAEPT CQMJAR
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R320 PSY UI40159

     UP16/08/24 P F608

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.