openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Albert Lee (JIRA)" <j...@apache.org>
Subject [jira] [Created] (OPENJPA-1972) DB2 V9.7 changed the default behavior concerning blocking behavior with isolation levels greater then read uncommitted
Date Thu, 31 Mar 2011 20:07:05 GMT
DB2 V9.7 changed the default behavior concerning blocking behavior with isolation levels greater
then read uncommitted
----------------------------------------------------------------------------------------------------------------------

                 Key: OPENJPA-1972
                 URL: https://issues.apache.org/jira/browse/OPENJPA-1972
             Project: OpenJPA
          Issue Type: Improvement
          Components: sql
    Affects Versions: 2.1.0, 2.0.2, 2.2.0
            Reporter: Albert Lee
            Assignee: Albert Lee
            Priority: Minor
             Fix For: 2.1.1, 2.2.0


This is an intentional change in DB2 9.7.  Refer to articles:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.wn.doc/doc/c0053503.html
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.perf.doc/doc/c0053760.html
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.config.doc/doc/r0053556.html

DB2 9.7 added a cur_commit database configuration setting.  By default, for new databases,
cur_commit is "ON", which is described as follows in the 2nd article above:

"Under the new currently committed semantics, only committed data is returned, as was the
case previously, but now readers do not wait for writers to release row locks. Instead, readers
return data that is based on the currently committed version; that is, data prior to the start
of the write operation."

This change affected the expected outcome of a deadlock test, which need to enhance adapting
to this behavior change.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message