IBM Support

JR45566: EXECUTE BUSINESS DATA CONSTRAINT EXPRESSION SUBQUERY WITH (NOLOCK) IN SQL SERVER.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Execute the buiness data constraint expression subquery with
    (NOLOCK) in MS SQL Server.
    

Local fix

  • n/a
    

Problem summary

  • Problem Description:
    If (and only if) the BPM database is Microsoft SQL Server, task
    searches which include search constraints on business data may
    cause high numbers of read locks on the
    lsw_bpd_instance_variables table. This may lead to deadlocks and
    bad performance.
    
    Problem Summary:
    Deadlocks and bad performance of task searches with business
    data on Microsoft SQL Server
    
    Problem Conclusion:
    The isolation level for the business data subquery is lowered on
    the lsw_bpd_instance_variables table.
    

Problem conclusion

  • Problem fixed with V8011
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR45566

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-30

  • Closed date

    2013-02-27

  • Last modified date

    2013-02-27

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

    JR45553

  • 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":"LOB45","label":"Automation"}}]

Document Information

Modified date:
27 February 2013