PQ91477: SQLCODE811 ( -811 ) in option S(SQL) in summary activity

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When more than one packageset (of the form CQMxxxx) is bound for
  the same DB2 ssid, certain functions using singleton SELECT will
  raise the -811 SQLCODE.
  
  These occurrences are properly handled by the CQM application
  code, but the -811 occurrences are visible in the CQM collected
  and displayed data, unless excluded by filtering or monitoring
  profiles.
  
  If not so filtered, there may be a significant number of these
  exceptions displayed, possibly obscuring other important data
  being collected.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: When more than one packageset (of the   *
  *                      form CQMxxxx) is bound for the same DB2 *
  *                      ssid, certain functions using singleton *
  *                      SELECT will raise the -811 SQLCODE.     *
  *                                                              *
  *                      These occurrences are properly handled  *
  *                      by the CQM application code, but the    *
  *                      -811 occurrences are visible in the     *
  *                      CQM collected and displayed data,       *
  *                      unless excluded by filtering or         *
  *                      monitoring profiles.                    *
  *                                                              *
  *                      If not so filtered, there may be a      *
  *                      significant number of these exceptions  *
  *                      displayed, possibly obscuring other     *
  *                      important data being collected.         *
  ****************************************************************
  * 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:

Modules/Macros

•    CQMCAE
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R210 PSY UQ93292

     UP04/10/13 P F410

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.