Use the A_DB2_ISOLATION_LEVEL variable to set the isolation level. The default ordering of isolation levels is:
You can change the isolation level by setting this variable to an integer in the ACUFH configuration file. The settings are:
| Isolation level | Setting in ACUFH configuration file |
|---|---|
| SQL_TXN_READ_UNCOMMITTED | 1 |
| SQL_TXN_READ_COMMITTED | 2 |
| SQL_TXN_REPEATABLE_READ | 3 |
| SQL_TXN_SERIALIZABLE | 4 |
For example, to set the isolation level to SQL_TXN_READ_COMMITTED, add the following entry to the ACUFH configuration file:
A_DB2_ISOLATION_LEVEL 2
If the user-set isolation level is not supported by the driver, the default method of selecting a level is used.