Isolation Levels
- Last Updated: April 16, 2026
- 1 minute read
- ADO.NET
- Documentation
The DB2 data provider defines the isolation level through the BeginTransaction(IsolationLevel) method of the DB2Connection class (Refer to DB2Connection in the online help).
The following table lists the mapping of the supported .NET transaction isolation levels to the appropriate DB2 transaction isolation levels.
Supported Isolation Levels
| .NET Isolation Level | DB2 Isolation Level |
| ReadCommitted (default) | Cursor Stability |
| ReadUncommitted | Uncommitted Read |
| RepeatableRead | Read Stability |
| Serializable | Repeatable Read |
| N/A | No Commit1 |
1 When connected to a DB2 for i5/OS V5R3, V5R4 database that has the No Logging option enabled, local and distributed transactions are not supported. If an application attempts to start a transaction, the data provider throws an exception.
For more information, refer to Locking and Isolation Levels in the DataDirect Connect Series for ADO.NET Reference.