IBM Support

JR45553: 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

  • iFix available on top of BPM 7.5.1.1
    Targeted for inclusion in fixpack BPM 7.5.1.2
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR45553

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    751

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-29

  • Closed date

    2013-03-26

  • Last modified date

    2013-03-26

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

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

    JR45565 JR45566

Fix information

  • Fixed component name

    BPM STANDARD

  • Fixed component ID

    5725C9500

Applicable component levels

  • R751 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":"7.5.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
26 March 2013