IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR51450

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-10-07

  • Closed date

    2014-12-10

  • Last modified date

    2014-12-10

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
10 December 2014