A_DB2_ISOLATION_LEVEL configuration variable

Restriction: This topic applies only when a Database Connectors license has been installed via the Micro Focus License Management System.

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.