Skip to main content

APAR IY63975: Business Process Choreographer (BPC) database deadlocks during simultaneous claim or queryWorkItem requests.


Fix readme


Abstract

This problem occurs only under high system load when a very high
number of claim requests and query work item requests are
started simultaneously. Some requests cannot be completed
successfully and end with a deadlock exception.
Concurrent threads query work items for claimable activities and
then try to claim the same activity. This can lead to deadlocks
in some situations.

Content

PROBLEM CONCLUSION:

This fix includes the following changes:
1. Change to the locking strategy in the appropriate claim
request.
2. The ability to specify a different database transaction
isolation level for the work item query.
The transaction isolation level for the query can be changed
only for DB2 UDB, DB2 zOS V7, and DB2 iSeries. For other
database systems, the transaction isolation level cannot be
changed.

To enable the "Uncommitted Read" isolation level for queries,
create a file with the name 'bpe.properties' in the
WebSphere\AppServer\properties directory (on every node if it
is a cluster). This bpe.properties file must contain the
following line:

queryIsolationLevel=UR                                      

Fixed in WBISF 5.1.1 CF1 (5.1.1.1)


Rate this page:

(0 users)Average rating

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

WebSphere Business Integration Server Foundation

Process Choreographer


Software version:
5.1.1


Operating system(s):
AIX, HP-UX, Linux, Linux Red Hat - pSeries, Linux zSeries, Solaris, Windows


Reference #:
1468929


Modified date:
2011-02-22

Translate my page

Content navigation