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® for i 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.