No commit
For all operations, the rules of level UR apply to No Commit (NC) except:
- Commit and rollback operations have no effect on SQL statements. Cursors
are not closed, and LOCK TABLE locks are not released. However, connections
in the release-pending state are ended.
- Any changes are effectively committed at the end of each successful change
operation and can be immediately accessed or changed by other application
groups using different commitment definitions.
DB2 UDB for iSeries supports No Commit through COMMIT(*NONE) or COMMIT(*NC).
Note:
(For distributed applications.) When
a requested isolation level is not supported by an application server, the isolation
level is escalated to the next highest supported isolation level. For example,
if RS is not supported by an application server, the RR isolation level is used.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.