JR51450: AN SQL QUERY FOR DURABLE MESSAGES THAT EXECUTES FREQUENTLY USES LITERALS INSTEAD OF PARAMETER MARKERS

8.0.1.1-WS-BPM-IFJR51450
Version 8.5 Refresh Pack 6 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• An SQL query for durable messages that executes frequently uses
  literals instead of parameter markers. However, using literals
  increases the shared memory and degrades performance.
  

Local fix

Problem summary

• This performance issue is caused by frequent executions of an
  SQL statement that has different arguments. Because the
  arguments are passed as literals into the query, the database
  statement cache grows.
  

Problem conclusion

• A fix is available for IBM BPM V8.0.1.1 that uses parameter
  markers instead of literals in a query for durable messages. For
  the database manager, an SQL query with the number of parameter
  markers is the same regardless of the values and can be reused
  by the optimizer despite the individual literals.
  
  On Fix Central (http://www.ibm.com/support/fixcentral), search
  for JR51450:
  
  1. Select IBM Business Process Manager with your edition from
    the product selector, the installed version to the fix pack
    level, and your platform, and then click Continue.
  
  2. Select APAR or SPR, enter JR51450, and click Continue.
  
  When you download fix packages, ensure that you also download
  the readme file for each fix. Review each readme file for
  additional installation instructions and information about the
  fix.
  

Temporary fix

• Not applicable
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  BPM STANDARD

• Fixed component ID

  5725C9500

Applicable component levels

• R801 PSY

     UP