IBM Support

JR48226: LOCK WAIT DURING WORK ITEM UPDATE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • During a work basket update, the following exception occurs:
    com.ibm.db2.jcc.am.SqlTransactionRollbackException: DB2 SQL
    Error: SQLCODE=-911, SQLSTATE=40001, SQLERRMC=68, DRIVER=3.61.65
    

Local fix

  • NA
    

Problem summary

  • For better query performance, changed work items need to be
    transformed into shared work item patterns.  During this, a
    database row is inserted within a global transaction, and while
    this transaction is suspended, this row is selected within a
    local transaction. Due to the chosen isolation level, a
    LOCK_WAIT occurs.
    

Problem conclusion

  • A new select statement has been added to the code: the row is
    now selected with uncommitted-read.  In the special situation
    (see above), this new statement is used.
    
    FIX AVAILABILITY:
    iFix for 7.5.1.1 is/will be available on Fix Central; search for
    APAR JR48226 at http://www.ibm.com/support/fixcentral/
    Fix is also targetted for inclusion in next fixpack for
    BPM V7.5.1, BPM V8.0.1
    
    When obtaining any of the above fixes, be sure to download the
    accompanying readme, for itself, and any prerequisite fixes, and
    review them thoroughly.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR48226

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    751

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-10-28

  • Closed date

    2014-05-19

  • Last modified date

    2014-05-19

  • 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 ADVANCED

  • Fixed component ID

    5725C9400

Applicable component levels

  • R751 PSY

       UP

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

Document Information

Modified date:
19 May 2014